Q

Recovering database with newly added datafiles

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?

This Content Component encountered an error
  1. 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?
  2. 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?
  3. 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?
  1. 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.
  2. 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.
  3. 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.
This was first published in June 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close