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.
I cannot start the database. Starting it via services produces the result above with the following error logged...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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
- svrmgr30
- connect internal
- startup mount
- alter database datafile '/directory/filename' end backup
- Repeat step 4 for each and every datafile.
- alter database open
- shutdown immediate
- 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.
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments