OraFAQ Forum: Backup & Recovery » Undo tablespace corrupt

Home » RDBMS Server » Backup & Recovery » Undo tablespace corrupt (Oracle 11g, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Undo tablespace corrupt [message #613283]

Fri, 02 May 2014 11:16

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi,

How to recover a undo tablespace if the datafile of it is corrupted ?

Thanks,
Suhas

Report message to a moderator

Re: Undo tablespace corrupt [message #613284 is a reply to message #613283]

Fri, 02 May 2014 11:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

suhasdba wrote on Fri, 02 May 2014 09:16

Hi,

How to recover a undo tablespace if the datafile of it is corrupted ?

Thanks,
Suhas

Restore DB from latest backups

Report message to a moderator

Re: Undo tablespace corrupt [message #613289 is a reply to message #613284]

Sat, 03 May 2014 01:14

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Blackswan,

Thanks.

1.Shutdown immediate

2.startup mount

3.restore database 

4.recover database.

5.alter database open resetlogs.

Can you once confirm the above steps to restore database from latest backups ?

Thanks,
Suhas

Report message to a moderator

Re: Undo tablespace corrupt [message #613290 is a reply to message #613289]

Sat, 03 May 2014 01:36

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Can you once confirm the above steps to restore database from latest backups ?

Yes, those are the steps to restore the database. But you do not need to restore the database: you need to restore and recover a datafile of the undo tablespace. So:

shutdown immediate;
startup mount;
restore datafile whatever_it_is_called;
recover datafile whaever_it_is_called;
alter database open;

[Updated on: Sat, 03 May 2014 01:37]

Report message to a moderator

Re: Undo tablespace corrupt [message #613291 is a reply to message #613290]

Sat, 03 May 2014 01:44

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Thank you John for the corrections.

Report message to a moderator

Previous Topic:	Reg : Dropped Table
Next Topic:	ora 19698 file is from different database id= db_name=

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 27 12:27:29 CDT 2023