Which two statements are true about recovering logically corrupted tables or table partitions
from an RMAN backup?
A.
Tables or table partitions can be recovered by using an auxiliary instance only.
B.
Tables or table partitions with a foreign key cannot be recovered.
C.
Tables or table partitions can be recovered only when the database is in mount state.
D.
Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
E.
Tables with not null constraints cannot be recovered.
Explanation:
Reference:
http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695 (Limitations of
Recovering Tables and Table Partitions from RMAN Backups)
D and E
Answer: A,D
“Tables with named NOT NULL constraints cannot be recovered with the REMAP option.”
There is a tricky question.. i will go for D and E too. bcoz we can also use flash back technologies to recover the table.
No trick at all. Answer is A and D .
Read people.
Tables with named not null constraints can be recovered. They cant be recovered with remap.
A is absolutely correct as the question clearly states that recover is done from rman backup.
Thanks Vonpire!
Why not D. I found docs here:
Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered. >> D
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695
Sorry. I mean D.
A. is here
https://www.pythian.com/blog/table-recovery-with-rman-in-database-12c/
AD
AD .. Siegfried and Vonpire are working really hard<
AD
https://docs.oracle.com/cd/E49329_01/backup.121/b71297/rcmresind.htm#BEIGFBDI
D & E is correct
Limitations of Recovering Tables and Table Partitions from RMAN Backups
When you use the RECOVER command to recover tables or table partitions contained in an RMAN backup, the following limitations exist.
Tables and table partitions belonging to SYS schema cannot be recovered.
Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered.
Tables and table partitions on standby databases cannot be recovered.
Tables with named NOT NULL constraints cannot be recovered with the REMAP option.
AD
AD