Tablespace recovery
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)
Software/Hardware used:
Software/Hardware used:
ASKED:
July 26, 2005 4:53 AM
UPDATED:
July 26, 2005 11:00 AM
RELATED QUESTIONS
- time-based & change-based recovery
- DB2 image copy that is no longer in SYSCOPY on zOS operating system
- How do you restore and recover RMAN incremental backup on a new Host in different HDD partition?
- How Do I release unused space from a tablespace after dropping a blob table
- Symantec backup exec system recovery 7 question
Answer Wiki:
You can do SELECT FILE#, NAME, STATUS FROM V$DATAFILE;
Datafiles with status OFFLINE are to be first restored from backup and then recovered. You can use FILE# instead of NAME for restore and recovery since it is easier.
After successful recovery you must bring datafile online.
To see all answers submitted to the Answer Wiki: View Answer History.
IN response to your second question, the Oracle recovery mechanism is smart enough to know what needs recovery. If you have a tablespace with multiple datafiles and you lose only one of them, you can do a ‘recover tablespace’ after you’ve restored that file and Oracle will know which datafile is bad and recover that one.