ORA-01033 error when taking backup
I have an Oracle database (8i) server running on a Unix platform. Today when I wanted to take a backup I received the error "ORA-01033: Oracle initialization or shutdown is in progress." When we ran the command SHUTDOWN ABORT FOLLOWED BY STARTUP, there were two more errors:
ORA-01157 Cannot Identify/Lock data file 4 ORA-01110 datafile
Please help me. Thanks.
It looks like your datafile is missing or cannot be found. Verify that the /home2/oracle/oradata/orcl/ directory is available on your server and that the 'oracle' user can read and write to it.
Since this datafile is for your temp tablespace, you have not lost any data. You can restore this file from your backup, or you can start the database without it using these steps:
- STARTUP MOUNT (mount the database)
- ALTER TABLESPACE temp OFFLINE;
- DROP TABLESPACE temp;
- ALTER DATABASE OPEN;
- Recreate the tablespace.
This was first published in October 2005