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