Home » RDBMS Server » Backup & Recovery » Retention Policy for Control File Auto Backups (Oracle 11g R2, Windows)
Retention Policy for Control File Auto Backups [message #664968] Tue, 15 August 2017 05:11 Go to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Despite of defined retention policy to recovery window of 7 days, the auto backups of control file & SP file are not marked as obsolete and are not removed by executing following statement:

DELETE OBSOLETE;

Pl guide.
Re: Retention Policy for Control File Auto Backups [message #664974 is a reply to message #664968] Tue, 15 August 2017 05:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post the output of
RMAN> show all;

Re: Retention Policy for Control File Auto Backups [message #664976 is a reply to message #664974] Tue, 15 August 2017 05:52 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Pls see below:

RMAN> show all;

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'F:\RMAN_BACKUPS\Control_File\%T\cf_%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'F:\RMAN_BACKUPS\Database\rman_%d_s%s_p%p_t%t_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\ZUBAIR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFISDB.ORA'; # default
Re: Retention Policy for Control File Auto Backups [message #664981 is a reply to message #664976] Tue, 15 August 2017 09:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
So does it work for datafiles and arcxhivelogs?
If that is the case and report/delete obsolete is not working only for controlfile/spfiles , it is a known bug.
Check with Oracle support.

There could be a lot we are overlooking.
control_file_record_keep_time / your backups (last full, incremental) etc
Re: Retention Policy for Control File Auto Backups [message #664984 is a reply to message #664981] Tue, 15 August 2017 22:21 Go to previous message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Yes, REPORT OBSOLETE is working fine for Datafiles & Archivelog files backups. I'm doing a manual delete of old control file backups folders using DOS script.
Previous Topic: Error in logging in
Next Topic: Prepare Cold Standby Server
Goto Forum:
  


Current Time: Thu Mar 28 11:09:04 CDT 2024