I am not clear with UNDO tablespace recovery.
consider below two scenario.
If we lost any of undo datafile how can we recover? can we just use RMAN restore and recover of that datafile alone?
If our undo datafile got corrupted then how could we recover?
When I googled it, it says like inorder to recover corrupted undo datafile we need to set the UNDO_MANAGEMENT paramter to MANUAL and need to create new undo tablespace then make it online followed by need to change UNDO_MANAGEMENT parameter to AUTO.
but why dont we use BLOCKREPAIR or just mran restore or recover command in scenario 2.
Kindly explain in detail.