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 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?
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