OraFAQ Forum: Backup & Recovery » Retention Policy for Control File Auto Backups

Home » RDBMS Server » Backup & Recovery » Retention Policy for Control File Auto Backups (Oracle 11g R2, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retention Policy for Control File Auto Backups [message #664968]

Tue, 15 August 2017 05:11

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.

Report message to a moderator

Re: Retention Policy for Control File Auto Backups [message #664974 is a reply to message #664968]

Tue, 15 August 2017 05:28

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post the output of

RMAN> show all;

Report message to a moderator

Re: Retention Policy for Control File Auto Backups [message #664976 is a reply to message #664974]

Tue, 15 August 2017 05:52

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

Report message to a moderator

Re: Retention Policy for Control File Auto Backups [message #664981 is a reply to message #664976]

Tue, 15 August 2017 09:54

Mahesh Rajendran
Messages: 10706
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

Report message to a moderator

Re: Retention Policy for Control File Auto Backups [message #664984 is a reply to message #664981]

Tue, 15 August 2017 22:21

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.

Report message to a moderator

Previous Topic:	Error in logging in
Next Topic:	Prepare Cold Standby Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 23:09:33 CDT 2023