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 
4:'/home2/oracle/oradata/orcl/temp01.dbf'
Please help me. Thanks.

    Requires Free Membership to View

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:

  1. STARTUP MOUNT (mount the database)
  2. ALTER TABLESPACE temp OFFLINE;
  3. DROP TABLESPACE temp;
  4. ALTER DATABASE OPEN;
  5. Recreate the tablespace.

This was first published in October 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: