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
- 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
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