Home » RDBMS Server » Backup & Recovery » Undo tablespace corrupt (Oracle 11g, Linux)
Undo tablespace corrupt [message #613283] Fri, 02 May 2014 11:16 Go to next message
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

Re: Undo tablespace corrupt [message #613284 is a reply to message #613283] Fri, 02 May 2014 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 23146
Registered: January 2009
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
Re: Undo tablespace corrupt [message #613289 is a reply to message #613284] Sat, 03 May 2014 01:14 Go to previous messageGo to next message
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
Re: Undo tablespace corrupt [message #613290 is a reply to message #613289] Sat, 03 May 2014 01:36 Go to previous messageGo to next message
John Watson
Messages: 4858
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 Go to previous message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Thank you John for the corrections.
Previous Topic: Reg : Dropped Table
Next Topic: ora 19698 file is from different database id= db_name=
Goto Forum:
  


Current Time: Thu Dec 18 16:24:04 CST 2014

Total time taken to generate the page: 0.12679 seconds