Your multitenant container database (CDB) contains three pluggable database (PDBs). You
find that the control file is damaged. You plan to use RMAN to recover the control file. There
are no startup triggers associated with the PDBs. Which three steps should you perform to
recover the control file and make the database fully operational?
A.
Start the database instance in the nomount stage and restore the control file from control
file auto backup.
B.
Recover each pluggable database.
C.
Open all the pluggable databases.
D.
Mount the CDB and then recover and open the database, with the RESETLOGS option.
E.
Mount the container database (CDB) and restore the control file from the control file auto
backup.
F.
Recover and open the CDB in NORMAL mode.
A
D
C
I will immediately grab your rss feed as I can’t find your e-mail subscription link or e-newsletter service. Do you have any? Kindly let me know so that I could subscribe. Thanks.
http://www.bastcilkdoptb.com/
A,D,C are the Correct answers.
[oracle@ora12c cdb2]$ rman target /
Recovery Manager: Release 12.1.0.1.0 – Production on Thu Mar 24 21:21:00 2016
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB2 (not mounted)
RMAN> restore controlfile from autobackup;
Starting restore at 24-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=124 device type=DISK
recovery area destination: /u01/app/oracle/fast_recovery_area
database name (or database unique name) used for search: CDB2
channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/CDB2/autobackup/2016_03_24/o1_mf_s_907362401_ch81j68w_.bkp found in the recovery area
AUTOBACKUP search with format “%F” not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/CDB2/autobackup/2016_03_24/o1_mf_s_907362401_ch81j68w_.bkp
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/oradata/cdb2/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/cdb2/control02.ctl
Finished restore at 24-MAR-16
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> recover database;
Starting recover at 24-MAR-16
Starting implicit crosscheck backup at 24-MAR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=124 device type=DISK
Crosschecked 25 objects
Finished implicit crosscheck backup at 24-MAR-16
Starting implicit crosscheck copy at 24-MAR-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 24-MAR-16
searching for all files in the recovery area
cataloging files…
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/CDB2/autobackup/2016_03_24/o1_mf_s_907362401_ch81j68w_.bkp
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 229 is already on disk as file /u01/app/oracle/oradata/cdb2/red001.log
archived log file name=/u01/app/oracle/oradata/cdb2/red001.log thread=1 sequence=229
creating datafile file number=46 name=/home/oracle/hell01.dbf
archived log file name=/u01/app/oracle/oradata/cdb2/red001.log thread=1 sequence=229
media recovery complete, elapsed time: 00:00:00
Finished recover at 24-MAR-16
RMAN> alter database open resetlogs;
Statement processed
RMAN> alter pluggable database all open;
Statement processed
RMAN>