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 last published in October 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close