Q1: How do i find out which datafile i need to recover when doing a tablespace recovery?
Is it thru V$DATAFILE? Will oracle indicate this?
Q2: Under which circumstances shld i consider recovering a datafile / a tablespace?
It seems that i could recover a tablespace by just recovering a datafile (if only a datafile of that tablespace is corrupted)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!