Using target database control file instead of recovery catalog All rights reserved.Ĭonnected to target database: ORCL (not mounted)Ĭurrently none of the control files are mounted so RMAN does not know about the backups or any pre-configured RMAN settings. Since all of the control files are missing we will need to restore them from a backup using ctl]$ rman
ORA-00202: control file: '/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'Ĭhecker run found 2 new persistent data failures ORA-00202: control file: '/u03/app/oracle/oradata/orcl/ctl/control03.ctl' Looking at the alert log we see that none of the control files are available. In anticipation of restoring a control we get a list of the control file locations. When starting the database we see the following error.
Scenario 2: All control files are corrupt or missing SQL> ~]$ cp /u01/app/oracle/flash_recovery_area/orcl/control02.ctl ~]$ exitīy having a multiplexed copy of the control file we were able to recover from a corrupt or missing control file without having to go to a database backup. We know from the alert log that /u02/app/oracle/oradata/orcl/ctl/control01.ctl is the control file that is having problems so we will copy the one from the /u01/app/oracle/flash_recovery_area/orcl/control02.ctl and then mount and open the database. To resolve this problem we simply copy a control file from one of the other locations.Ĭontrol_files string /u02/app/oracle/oradata/orcl/c
See the post Multiplexing Control Files for more information on multiplexing the control file. In either case, to recover from this problem is simple and does not require going to the last backup provided your control files are multiplexed. Linux Error: 2: No such file or directory Or you may see the file is missing when looking in the alert log. ORA-205 signalled during: ALTER DATABASE MOUNT.Ĭhecker run found 1 new persistent data failures ORA-27048: skgfifi: file header information is invalid ORA-00202: control file: '/u02/app/oracle/oradata/orcl/ctl/control01.ctl' ORA-00210: cannot open the specified control file
Looking the alert log you see that the /u02/app/oracle/oradata/orcl/ctl/control01.ctl is corrupt. ORA-00205: error in identifying control file, check alert log for more info When attempting to start the database you see the following error. Scenario 1: Corrupt or Missing control file See the post Setting up RMAN for backup and restore using Database Control for information on setting up RMAN. This document will detail recovery scenarios dealing with missing or corrupted control files using RMAN disk based backups.