Recover UNDO tablespace in 10g

All posts relating to Oracle database administration.

Moderator: Tim...

Recover UNDO tablespace in 10g

Postby vgandhi » Fri Sep 16, 2011 1:48 pm

One UNDO datafile went to suddenly offline as a result,it throws error sating that not able to read the file and i created new UNDO and it was assigned as a UNDO tbs but it was not getting assigned so please let me know how to recover this UNDO tablespace.

Version 10.2.0.4
RAC three node database
It happened in third node so no one was able to access the DB.

Thanks
VCarun.
vgandhi
Member
 
Posts: 6
Joined: Thu Sep 01, 2011 5:27 am

Re: Recover UNDO tablespace in 10g

Postby Tim... » Fri Sep 16, 2011 4:46 pm

Hi.

You can recover the tablespace from a backup.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17940
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron