Control-lfile Recovery in CDB

Control File Recovery

SQL> select name from V$controlfile;

NAME

--------------------------------------------------------------------------------

/oracle/product/oradata/sec_cdb/control01.ctl

/u01/app/oraInventory/fast_recovery_area/sec_cdb/control02.ctl

Manually removing both the controlfile to mitigate failure.

SQL> ! rm -f /oracle/product/oradata/sec_cdb/control01.ctl

SQL> ! rm -f /u01/app/oraInventory/fast_recovery_area/sec_cdb/control02.ctl

SQL> alter system archive log current;

alter system archive log current

*

ERROR at line 1:

ORA-00210: cannot open the specified control file

ORA-00202: control file: '/oracle/product/oradata/sec_cdb/control01.ctl'

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

RMAN> startup nomount;

Oracle instance started

Total System Global Area     658505728 bytes

Fixed Size                     2927864 bytes

Variable Size                490734344 bytes

Database Buffers             159383552 bytes

Redo Buffers                   5459968 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 24-AUG-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=22 device type=DISK

recovery area destination: /u01/app/oraInventory/fast_recovery_area

database name (or database unique name) used for search: SEC_CDB

channel ORA_DISK_1: AUTOBACKUP /u01/app/oraInventory/fast_recovery_area/SEC_CDB/autobackup/2015_08_24/o1_mf_s_888604049_bxowx3gf_.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/oraInventory/fast_recovery_area/SEC_CDB/autobackup/2015_08_24/o1_mf_s_888604049_bxowx3gf_.bkp

channel ORA_DISK_1: control file restore from AUTOBACKUP complete

output file name=/oracle/product/oradata/sec_cdb/control01.ctl

output file name=/u01/app/oraInventory/fast_recovery_area/sec_cdb/control02.ctl

Finished restore at 24-AUG-15

RMAN> alter database mount;

Statement processed

released channel: ORA_DISK_1

RMAN> recover database;

Starting recover at 24-AUG-15

Starting implicit crosscheck backup at 24-AUG-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=22 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=23 device type=DISK

Crosschecked 41 objects

Finished implicit crosscheck backup at 24-AUG-15

Starting implicit crosscheck copy at 24-AUG-15

using channel ORA_DISK_1

using channel ORA_DISK_2

Finished implicit crosscheck copy at 24-AUG-15

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u01/app/oraInventory/fast_recovery_area/SEC_CDB/archivelog/2015_08_24/o1_mf_1_56_bxoy5smr_.arc

File Name: /u01/app/oraInventory/fast_recovery_area/SEC_CDB/autobackup/2015_08_24/o1_mf_s_888604049_bxowx3gf_.bkp

using channel ORA_DISK_1

using channel ORA_DISK_2

starting media recovery

archived log for thread 1 with sequence 56 is already on disk as file /u01/app/oraInventory/fast_recovery_area/SEC_CDB/archivelog/2015_08_24/o1_mf_1_56_bxoy5smr_.arc

archived log for thread 1 with sequence 57 is already on disk as file /oracle/product/oradata/sec_cdb/redo03.log

archived log file name=/u01/app/oraInventory/fast_recovery_area/SEC_CDB/archivelog/2015_08_24/o1_mf_1_56_bxoy5smr_.arc thread=1 sequence=56

archived log file name=/oracle/product/oradata/sec_cdb/redo03.log thread=1 sequence=57

media recovery complete, elapsed time: 00:00:00

Finished recover at 24-AUG-15

RMAN> alter database open resetlogs;

Statement processed