By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
- We have scheduled hot backups at 9:30 every day. At 2:00 pm, we added two datafiles and at 3:00 pm the database crashed. We do not have log files. How do we recover the database with two newly added datafiles?
- We have a scheduled backup at 10:00 am. At 11:00 am, unfortunately, redo logs are deleted by a DBA. The database crashed at 12:00. How do we recover the database?
- We have a scheduled backup at 9:00 am. The database crashed at 11:00 am. How do we recover the database if the control files are corrupted?
- If you do not have log files, then your only recourse is incomplete recovery. You can use the RECOVER UNTIL command to recover up until a point in time, or recover up until your lost archived redo log. Once you have recovered as much as you can, you need to open the database with RESETLOGS. It is a very good idea to bring down your database at this point and take a backup.
- If you have the archived redo logs, then you can restore all transactions up to the ones in your last archived redo log. At that point, you need to open the database with RESETLOGS. It is a very good idea to bring down your database at this point and take a backup.
- Hopefully, you have multiplexed your control file. If so, copy one of your other control files to the same location and same name as the missing one. If you have not multiplexed your control file, then you can use a backup of the control file and recover your database with the RECOVER USING BACKUP CONTROLFILE command. If you do not have a backup control file, then you can manually create the control file with the CREATE CONTROLFILE command.
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.