Which three true about recovering tables using RMAN? (Choose three.)
Which three true about recovering tables using RMAN? (Choose three.)
RMAN always uses an auxiliary instance when recovering tables to ensure the primary database remains unaffected during the process. RMAN can recover a table even after a DDL operation has altered the table structure, as long as the necessary backups are available. However, RMAN cannot recover tables owned by the SYS user or from the SYSTEM and SYSAUX tablespaces, making option G regarding the SYSTEM user pertinent. RMAN does support the recovery of tables owned by the SYSTEM user.
DFG correct https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED-37C3-44C6-B205-AF1621008DCE
A, B, C, E are false. agree DFG correct
To quote from RinD's link, it specifically states that ABCE are wrong: 22.1.4 Limitations of Recovering Tables and Table Partitions from RMAN Backups Recovering tables and table partitions from RMAN backups by using the RECOVER command is subject to certain limitations. The limitations include the following: 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. So, DFG definitely correct.
A. RMAN can recover tables in the SYSAUX tablespace. - WRONG B. RMAN can recover tables owned by the SYS user. - WRONG C. RMAN can recover tables in the SYSTEM tablespace.- WRONG D. RMAN always uses an auxiliary instance. E. RMAN can recover tables in a standby database.- WRONG F. RMAN can recover a table after a DDL operation has altered the table structure. G. RMAN can recover tables owed by the SYSTEM user. 22.1.4 Backup Guide DFG -Correct
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED-37C3-44C6-B205-AF1621008DCE
see https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED-37C3-44C6-B205-AF1621008DCE
DFG are correct options. Tested it.
The limitations include the following: 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.
DFG - I think
DFG The below explicitly provides the answers https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695
DFG correct. see aldrid