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