Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Undo Tablespace ..Is it the most important part of recovery

Maran ViswarayarMay 18 2007 — edited May 20 2007
I just got a doubt

Redologs files are filles with COMMITED AND UNCOMMTTED transactions and archived assume archive log

ORacle uses undo tablespace to rollback the uncommited transactions

What happens if we loose undo tablespace?

sunday i took full backup...
after eactly one menoth i take another full backup meant time somewhere in the middle of the month i database crashes and also undo tablespace lost

how ill oracle recover in this scenario

Message was edited by:
Maran Viswarayar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2007
Added on May 18 2007
10 comments
640 views