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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
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:
- 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.
Start the conversation
0 comments