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
