Skip to Main Content

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!

How long a backup is guaranteed using control file?

NuGlamSMSNov 12 2018 — edited Nov 14 2018

Hello,

If a perform a full database backup and I'm using control file instead of catalog, How long it will be available to restore it?

What I want to do is perform a full backup every Saturday and then Differential Incremental backups from Sunday to Friday. Today is Monday, so I would like to be sure I can restore to last Wednesday, and for that I would need not last Saturday full backup but two previous Saturday full backup (I hope I'm explaining right).

Sat(FBK)         Wen         Sat      Mon

----|-----------------|-------------|---------|

As a start point I think I should change the parameter Control_File_Record_Keep_Time from 7 (default) to 15.

How should I configure database and RMAN to be sure a full backup is kept at least 15 o 20 days?

Thank you for your help.

Comments
Post Details
Added on Nov 12 2018
12 comments
3,677 views