UNDO tablespace in DG/DR/Standby database got corrupted.
========================================================
suppose we found block corruption issue in DG/DR we can fix with 2 ways. if it is other than UNDO tablespace ,
Restore datafiles and archive log files from backup servers and restart recovery, recovery will go fine.
To reduce recovery time , we can place corresponding tablespace in Begin backup and copy the corresponding datafile to DG/DR location , once copy is completed place tablespace in end backup and restart recovery.
But if corrupted block is on undo tablespace above activity don't try , Because Undo tablespace is used for both rollback and rollforward activity.
copying latest undo tablespace related datafile will not help to fix the issue.
in such cases better to rebuild DG/DR.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment