Q
Problem solve Get help with specific problems with your technologies, process and projects.

Database crash during hot backup

Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files associated with the affected database are in backup mode.

Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files associated with the affected database are in backup mode.

I cannot start the database. Starting it via services produces the result above with the following error logged...

in the ALRT.log:

ORA-1122 signalled during: alter database "cafe" open

Attempting to start the database via the svrmgr30 program produces the following errors:

LCC-00161: Message 161 not found; product=RDBMS80; facility=MGR
ORA-12203: TNS: unable to connect to destination

You'll have to start the instance manually and take the datafiles out of backup mode. Use these steps:

  1. svrmgr30
  2. connect internal
  3. startup mount
  4. alter database datafile '/directory/filename' end backup
  5. Repeat step 4 for each and every datafile.
  6. alter database open
  7. shutdown immediate
  8. Take a cold backup of your database.

You will not be able to open the database until all of your datafiles are out of backup mode. Once you have opened the database, you will want to take a backup of your database so that you will have a good clean backup to start from after recovery from this failure.

This was last published in August 2005

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close