Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

Which two statements are true about recovering logically corrupted tables or table partitions

from an RMAN backup?

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 only when the database is in mount state.

B.
Tables or table partitions from the system and sysauxtablespaces cannot be recovered.

C.
Tables or table partitions with a foreign key cannot be recovered.

D.
Tables or table partitions can be recovered by using an auxiliary instance only.

E.
Tables with not null constraints cannot be recovered.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


srks

srks

BE

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.

Single table partitions can be recovered only if your Oracle Database version is Oracle Database 11g Release 1 or later.

Tables and table partitions on standby databases cannot be recovered.

Tables with named NOT NULL constraints cannot be recovered with the REMAP option.