CASE 2: LOST ALL CONTROL FILES AND USING FLASH RECOVER AREA (FRA) BUT NOT RECOVERY CATALOG
— OPTION 1: AUTOBACKUP OF CONTROL FILE IS ENABLED
— OPTION 2: AUTOBACKUP OF CONTROL FILE IS NOT ENABLED
OPTION 1: AUTOBACKUP OF CONTROL FILE IS ENABLED
=========
Control file 1: /u01/app/oracle/oradata/DEVDB/control01.ctl
Control file 2: /u01/app/oracle/fast_recovery_area/DEVDB/control02.ctl
show parameter control_file
rman target /
startup nomount;
restore controlfile from autobackup;
alter database open resetlogs; ----------------------------- Error
alter database mount;
alter database open resetlogs; ----------------------------- Error
recover database;
alter database open resetlogs;
OPTION 2: AUTOBACKUP OF CONTROL FILE IS NOT ENABLED
==========
Remember that control files autobackup OFF doesn’t mean you don’t have control files backup.
RMAN will by default back up your control file anytime you back up datafile 1 (which is SYSTEM data file),
regardless of whether you have the autobackup of your control file feature enabled.
RMAN# BACKUP DATAFILE 1;
rman target /
startup nomount;
restore controlfile from '/u01/app/oracle/fast_recovery_area/DEVDB/backupset/2020_10_13/o1_mf_ncsnf_TAG20201013T013446_hr9fq6ob_.bkp';
alter database mount;
recover database;
alter database open resetlogs;
#RMAN #ControlfileLost #RestoreCOntrolfile #MultiplexControlfile #Backup #Restore #Recovery #Oracle #RAC #Database #Exadata #ASM
Please do follow me and support me on,
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg