Pavan DBA's Blog

The DBA Knowledge Store

why it is not necessary to take undo backup?

Posted by Pavan DBA on September 29, 2010


really long time to see you…here is the new post of mine

You know…it is not necessary to take undo tablespace backup either in cold backup or hot backup. But ofcourse many of DBA’s will include that in their script…

Now a big question…if undo is not being backed up and lets say i need to do instance recovery or database recovery and need to rollback a transaction, how that will happen.

Here is the answer…

when you do some transaction, redo entries will be generated..accepted ! Just like that whenever some changes happend to undo tablespace (or more clearly undo segments) oracle will generate redo entries.

So even though you doesn’t backup undo, you have the redo entries through which you can recover or rollback the transactions.

Wann to read more…just check here

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: