Controlfile Lost Scenario #02 – Restore Controlfile Using FRA but not Using Recovery Catalog

Channel Avatar
Comment
X
Share
Controlfile Lost Scenario #02 - Restore Controlfile Using FRA but not Using Recovery Catalog
Controlfile Lost Scenario #02 – Restore Controlfile Using FRA but not Using Recovery Catalog
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

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *