Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Secure backup restore

jay430640Apr 25 2014 — edited Apr 25 2014

Hi Experts,

I have a question related to oracle secure backup restore.

Is that possible to restore only the incremental backup?

My full backup is on Sunday, all other days am taking incr backup. I want to restore my data back on Wednesday. For the same, do i need to restore Full backup and incr on Monday, Tuesday and Wednesday ?

Or is there is any other option to recover a file which is available in Wednesday incremental backup?

Thanks and Regards

Jay

Comments

rdoogan-Oracle

If the file was changed on the Wednesday then it would be included in the Wednesday incremental job, so if you were viewing "latest" and chose the file it would just restore that from the Wednesday backup job. It would only go back to the Full backup if the file hadn't changed so wasn't included in the incr.

You can tell the view to be "as of date" and set it to "exclusive" so you'll only see the files included in that incr job.

Thanks

Rich

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 23 2014
Added on Apr 25 2014
#backup, #performance-availability, #secure-backup
1 comment
1,022 views