Today we are going to have look on the steps are used for “RMAN Recovery From Missing All Control File”.
Take a DBID
SQL> select dbid from v$database; DBID ———- 847839442
Check the RMAN configuration
RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFDBA20.ORA’; # default
Configure control file backup
RMAN> configure controlfile autobackup on;
BACKUP database
RMAN> backup database;
Check the controlfile location
SQL> select name from v$controlfile; NAME —————————————————— D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CONTROL01.CTL D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CONTROL02.CTL D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CONTROL03.CTL
Shutdown the database and remove the controlfile.
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Delete control files.
Try to start the database
SQL> startup; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 83887484 bytes Database Buffers 75497472 bytes Redo Buffers 7139328 bytes ORA-00205: error in identifying control file, check alert log for more info
Recover the controlfile
RMAN> set dbid 847839442 RMAN> restore controlfile from autobackup; RMAN> alter database mount; RMAN> restore database; RMAN> recover database; RMAN> alter database open resetlogs;
Today’s thought..
“If you are not willing to learn no one can help you. If you are determined to learn no one can stop you.” Zig Ziglar
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp