Control file corruption scenarios

CASE 1: LOST ONLY ONE CONTROL FILE - MULTIPLEXED CONTROL FILE

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

CASE 3: LOST ALL CONTROL FILES AND USING RECOVERY CATALOG BUT NOT FLASH RECOVER AREA (FRA)

CASE 4: LOST ALL CONTROL FILES AND NOT USING EITHER RECOVERY CATALOG OR FLASH RECOVER AREA (FRA)

CASE 5: RECREATING THE CONTROL FILES (FOR DATABASE CLONING)



CASE 1: LOST ONLY ONE CONTROL FILE - MULTIPLEXED CONTROL FILE
=======
--- This applies to both the cases whether your database is not open and your database is open schenario

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

startup

shut immediate

shutdown abort;

Method 1: Copy the good control file that we have available to the missing control file location
=========
cd /u01/app/oracle/fast_recovery_area/DEVDB/

cp control02.ctl /u01/app/oracle/oradata/DEVDB/control01.ctl

sqlplus / as sysdba

startup


Method 2: modify the control_files parameter in the initialization file or spfile
=========
startup nomount;

show parameter control_files

alter system set control_files='/u01/app/oracle/fast_recovery_area/DEVDB/control02.ctl' scope=spfile;

shutdown immediate;

startup

show parameter control_files


#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