2

I need to perform an incomplete recovery. We keep 7 days of backups, and I want to restore the database as it was 7 days ago. I've not done this before.

My question is: I can use the SET UNTIL TIME for the restore / recovery. But, with regards to restoring the control file and SPFile........do I need to restore those separately with SET UNTIL TIME, or will RMAN be smart enough to restore everything I need based on the timeframe I set?

Thank you.

Improve this question
0

1 Answer 1

Reset to default
3

In general there should be no need to restore controlfile or spfile. You say '7 days of backups' but you didn't specify what type of backups, nor what your retention policy is, nor what kind of housekeeping you do. If its a vanilla inc 0 and inc 1 backups with retention policy of recovery period of 7 days or more, a simple 'set until' followed by 'restore database' followed by 'recover database' should do it

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.