Home » RDBMS Server » Backup & Recovery » Want to purge Obsolete Archive Backups. (Windows 2003)
Want to purge Obsolete Archive Backups. [message #381692] Mon, 19 January 2009 05:04 Go to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
I am using RMAN control file backup and file size is increasing to reduce the size of control file want to purge Obsolete archive,Backups?
what is the best procedure.
Re: Want to purge Obsolete Archive Backups. [message #381698 is a reply to message #381692] Mon, 19 January 2009 05:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Set a retention policy and then use DELETE NOPROMPT OBSOLETE.
Re: Want to purge Obsolete Archive Backups. [message #381710 is a reply to message #381698] Mon, 19 January 2009 06:41 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
DELETE NOPROMPT OBSOLETE will remove both (Backups & archives set) and also release the space of control file?
Re: Want to purge Obsolete Archive Backups. [message #381711 is a reply to message #381710] Mon, 19 January 2009 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A control file never shrinks.
Space will be reused as soon as entries are needed and backups are no more needed giving your retention policy.

Regards
Michel
Re: Want to purge Obsolete Archive Backups. [message #381716 is a reply to message #381711] Mon, 19 January 2009 06:56 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
RMAN> show all;
Right now i have these parameters in retention policy i already set for 7 days.
then why control file is growing.

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\BK_RMAN\SNAPCF_EMCC.CTL';
Re: Want to purge Obsolete Archive Backups. [message #381718 is a reply to message #381716] Mon, 19 January 2009 06:57 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
should i have to configure CONFIGURE ARCHIVELOG DELETION POLICY TO NONE to purge the Archives automatically.
Re: Want to purge Obsolete Archive Backups. [message #381721 is a reply to message #381718] Mon, 19 January 2009 07:29 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
REDUNDANCY 7 is not necessarily 7 days. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE is the default setting and does not automatically delete archivelogs.

How often do you take backups ? Do you have any guaranteed restore points ?

As was mentioned previously, the way to have control over when the archivelogs are purged is to remove them with DELETE OBSOLETE or DELETE INPUT.

You can check V$CONTROLFILE_RECORD_SECTION to see what is using space in your control file. If your controlfile expanded excessivley for what ever reason and you really need to "shrink" it, you'll have to recreate it.
Previous Topic: Problem with backup
Next Topic: Unable to issue DELETE OBSOLETE....in RMAN
Goto Forum:
  


Current Time: Sun Dec 11 06:24:19 CST 2016

Total time taken to generate the page: 0.09530 seconds