Tablespace recovery

0 pts.
Tags:
Oracle 9i
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)
ASKED: July 26, 2005  4:53 AM
UPDATED: July 26, 2005  11:00 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mljsher
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following