DB version: 19c
OS Platform : Oracle Linux 7.8
I have a 400GB database, where I currently run LEVEL0 backup on Mondays and Wednesdays and run LEVEL1 incremental backups on the remaining days.
My backup strategy is based on a basic requirement that I should be able to do PITR (Point in Time Recovery) for my database anytime within the last 7 days. So, I have configured retention policy using the below command.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN schedule:
SUN 3AM ---> Level 0 [RMAN > backup as backupset incremental level 0 database plus archivelog delete all input;]
MON 4AM ---> Level 1 [RMAN > backup as backupset incremental level 1 database plus archivelog delete all input;]
TUE 4AM ---> Level 1 [RMAN > backup as backupset incremental level 1 database plus archivelog delete all input;]
WED 3AM ---> Level 0 [RMAN > backup as backupset incremental level 0 database plus archivelog delete all input;]
THU 4AM ---> Level 1 [RMAN > backup as backupset incremental level 1 database plus archivelog delete all input;]
FRI 4AM ---> Level 1 [RMAN > backup as backupset incremental level 1 database plus archivelog delete all input;]
SAT 4AM ---> Level 1 [RMAN > backup as backupset incremental level 1 database plus archivelog delete all input;]
I work for Finance industry. So, occasionally, I have to restore old versions of this database for various purposes.
For each week's Sunday 3AM to Saturday 4AM's backups, I call it a 'Generation'.
Similarly, I have to store 6 months of data for compliance reasons. i.e. I need to store 24 Generations of backups.
Currently, I backup to disk (a filesytem allocated from SAN storage). This fileystem can only accomadate 1 week's backups + arch logs.
So, I am thinking of taping out (using Netbackup) the backups once every week from the backup location.
Two questions on this:
1. I do DELETE NOPROMPT OBSOLETE; after every LEVEL0 and LEVEL1 backups. Is this safe ?
Should I include DELETE NOPROMPT OBSOLETE; only in Sunday's Level0 backup script ?
2. When should I initiate taping out for each generation ? Just before Sunday 3 a.m.'s Level0 backup ?
Using this 'generation', I should be able to consistently restore and recover the database till the time when Sunday 3 AM's level0 backup started.