Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these…

Question

Exhibits

Options

• AIt will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• BIt will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• CIt will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
• DIt will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/ snapcf_cdb1control02.ctl'.
• EIt will fail because there is no autobackup of the controlfiles.

• A
  16% (6)
• B
  3% (1)
• C
  70% (26)
• D
  3% (1)
• E
  8% (3)

Explanation

When RMAN restores a deleted control file, it recreates the file at its original location as defined in the CONTROL_FILES initialization parameter - so the file returns exactly to /u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl, making C correct. Option A is wrong because $ORACLE_HOME/dbs stores initialization/password files, not control files. Option B points to a different data directory path - RMAN does not relocate files to a new path unless explicitly instructed. Option D describes a snapshot control file (snapcf_), which Oracle creates temporarily during RMAN backups and is not the actual control file being restored. Option E is incorrect because with the database still open (meaning the other multiplexed control files are intact), RMAN can simply copy a surviving control file to the missing location - no autobackup is required.

Memory tip: Think of RMAN restore as "return to sender" - it always ships the file back to the exact address recorded in CONTROL_FILES, not to a new location.

No community discussion yet for this question.