What is backup control file in Oracle?
Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options: Back up the control file to a binary file (duplicate of existing control file) using the following statement: ALTER DATABASE BACKUP CONTROLFILE TO ‘/oracle/backup/control.
How do I manually create a control file?
1 Answer
- Shut down the database.
- Copy an existing control file to a new location, using operating system commands.
- Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control file name.
- Restart the database.
Is there a way to restore the Oracle Database?
To restore the Oracle database there must be a control file, but if the control file does not exist is there a way to restore the control file from a Data Protection backup so that the Oracle database can be recovered. The Data Protection for Oracle is unable to restore the database because there is no control file available to complete the task.
What to do if you lose a database control file?
If you lose a single control file (e.g. disk corruption) you can simply us an OS copy command (cp) to overlay the bad control file with the good control file. You can also use the command ” alter database backup controlfile to trace ” to place a “create database” command into a trace file. This file can be used to re-create a missing control file.
How to recover from a missing control file?
By 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. When starting the database we see the following error.
How to recover a missing control file in ORCL?
Our control file autobackup is /u03/app/oracle/oradata/orcl/backup/c-1239150297-20100426-00. The first number after the c-, 1239150297, is the DBID. We will use that number in the SET DBID command. With the DBID set, we can now recover the control files from the control file autobackup.