Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close