Q
Problem solve Get help with specific problems with your technologies, process and projects.

Recovering crashed database with corrupted undo tablespace

I have a small Oracle 10g database. The database runs under archivelog mode. Recently my database crashed and it looks like the undo tablespace has been corrupted. How can I recover it?

I have a small Oracle 10g database. The database runs under archivelog mode. In August 2005 I shut down the database and copied all the database files manually, as my backup. Since then I have maintained all the archivelog files until now. During this period, I have added various objects and tablespaces. I do not have any other backups. Recently my database crashed and it looks like the undo tablespace has been corrupted. I can only mount the database but cannot open it. The database runs on Windows. My transactions are not that much and I don't mind applying the archivelogs. Please advise on how I can recover and where can I get a set of instructions to recover the database. Thank you.
If only your UNDO tablespace is corrupt, then recovering should be easy. Create another undo tablespace and drop the corrupt one similar to the following:
  1. STARTUP MOUNT
  2. CREATE UNDO TABLESPACE undotbs2 ....
  3. ALTER SYSTEM SET undo_tablespace=undotbs2 SCOPE=SPFILE;
  4. SHUTDOWN IMMEDIATE
  5. STARTUP MOUNT
  6. DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES;
  7. ALTER DATABASE OPEN;

Dig Deeper on Oracle database backup and recovery

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close