Problem solve
Get help with specific problems with your technologies, process and projects.
Redo log files corrupted
We took a cold backup last week. Unfortunately due to media failure my redo log files are corrupted. I have no backup control file. How can I recover the database?
We are using: Platform - AIX 5L, Database - 9.2.0.4, Applications - 11i
We took a cold backup last week. Then we have archive log backup. Unfortunately due to media failure my redo log files are corrupted. I have no backup control file. How can I recover the database?
If you lose one of your online redo logs or they get corrupted, then your only course of action is to open the database with the RESETLOGS option. Opening with RESETLOGS will recreate your online redo logs. You do not need a backup of your control file for this operation. The current control files will work. To restore, perform the following:
1. STARTUP MOUNT
2. RECOVER DATABASE UNTIL CANCEL
3. CANCEL (cancel right away)
4. ALTER DATABASE OPEN RESETLOGS;
5. SHUTDOWN IMMEDIATE
6. Perform a cold backup of your database.
Once the database is open with RESETLOGS, it is always a very good idea to shutdown the database and perform a good backup of your database.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments