Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File.

SQL> select dbid from v$database;

DBID
———-
847839442
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 ‘D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFDBA02.ORA’; # default

RMAN> configure controlfile autobackup on;
RMAN> backup database;
SQL> select name from v$controlfile;
NAME
——————————————————
D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA02\CONTROL01.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA02\CONTROL02.CTL
D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA02\CONTROL03.CTL
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Delete control files and 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
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

The foundation stones for a balanced success are honesty, character, integrity, faith, love, and loyalty. 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:

Telegram Channel: https://t.me/helporacle

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

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.