Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

The correct answer is B. An AUXILIARY instance is started only if there is sufficient disk space E. They may be recovered to a different schema in the same pluggable database (PDB). Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rcmrf/RECOVER.html#GUID-CA98040F- 9865-4F4F-BAF2-91C518612E95

New Features for High Availability

Question

Options

AThey may be recovered to a schema in a different PDB
BAn AUXILIARY instance is started only if there is sufficient disk space
CThey can be recovered by RMAN without an AUXILIARY instance
DThey must be un-partitioned tables
EThey may be recovered to a different schema in the same pluggable database (PDB)

How the community answered

(18 responses)

A
17% (3)
B
72% (13)
C
6% (1)
D
6% (1)

Explanation

Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rcmrf/RECOVER.html#GUID-CA98040F- 9865-4F4F-BAF2-91C518612E95

Topics

#RMAN table recovery#AUXILIARY instance#PDB table restore#cross-schema recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice