Q

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close