Hello All,
We have a Oracle Database(Rac one node) in 12.1.0.2.
We have an image copy and incremental backups daily to disk.Merge incremental runs on tuesday and friday.
The Backups are transferred to tape daily.
The thing i noticed is some of the datafile Image copies keeps getting deleted after 4 days.
I have 62 datafiles and everytime the Incremental backups run it comes back with something like the below
no parent backup or copy of datafile 14 found
no parent backup or copy of datafile 34 found
no parent backup or copy of datafile 31 found
no parent backup or copy of datafile 40 found
no parent backup or copy of datafile 35 found
no parent backup or copy of datafile 26 found
no parent backup or copy of datafile 61 found
no parent backup or copy of datafile 59 found
A new image copy of above datafiles are taken and during the next run it comes back with some other datafiles like below (not the same datafiles as previous run)
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 67 found
no parent backup or copy of datafile 7 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 12 found
no parent backup or copy of datafile 46 found
no parent backup or copy of datafile 37 found
no parent backup or copy of datafile 52 found
The Image copy datafiles(different each time) gets lost daily and during each run it needs to create a new image copy of datafile.I have checked the scripts and i couldn't see anything which deletes the image copies.My guess is whether the retention policy is deleting the Image copies,but i couldn't able to prove it .Should we need to use KEEP when taking image copy as i can't see anything in the documentation advising to use keep.My RMAN settings are below
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name Primary are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+FRA/%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 4;
CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 4;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/snapcf_primary.f';
Are there anything that i needs to do to prevent the Image copy getting deleted.
Thanks
CB