Home » RDBMS Server » Backup & Recovery » UNDOTBS01.dbf Corrupt - HELP!
icon9.gif  UNDOTBS01.dbf Corrupt - HELP! [message #159439] Sun, 19 February 2006 09:28 Go to next message
Sandi
Messages: 1
Registered: February 2006
Location: UK
Junior Member
Hi

MY PC crashed when I was trying to generate some test data this morning and it has left the UNDOTBS01.dbf file corrupted.

I had spend about 6 hours creating data (and no - I hadn't taken a backup )

Is there anyway round this problem or do I have to start from scratch?

If there is a workaround it may stop me having a nervous breakdown as I have until 5am to have a system ready for protyping with our cutomers!

Sandi.

Report message to a moderator

Re: UNDOTBS01.dbf Corrupt - HELP! [message #161154 is a reply to message #159439] Thu, 02 March 2006 05:08 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
[Source: http://www.dba-oracle.com/t_fix_undo_log_corruption.htm]
In cases of UNDO log corruption, the following steps to be followed:
• Change the undo_management parameter from “AUTO” to “MANUAL”
• Create a new UNDO tablespace
• Drop the old UNDO tablespace

--Girish

Report message to a moderator

Previous Topic: Restore my RMAN backups to a different server
Next Topic: Hot bkp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:07:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.