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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading