OraFAQ Forum: Backup & Recovery » Want to purge Obsolete Archive Backups.

Home » RDBMS Server » Backup & Recovery » Want to purge Obsolete Archive Backups. (Windows 2003)

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

Want to purge Obsolete Archive Backups. [message #381692]

Mon, 19 January 2009 05:04

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.

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381698 is a reply to message #381692]

Mon, 19 January 2009 05:52

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Set a retention policy and then use DELETE NOPROMPT OBSOLETE.

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381710 is a reply to message #381698]

Mon, 19 January 2009 06:41

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?

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381711 is a reply to message #381710]

Mon, 19 January 2009 06:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381716 is a reply to message #381711]

Mon, 19 January 2009 06:56

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';

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381718 is a reply to message #381716]

Mon, 19 January 2009 06:57

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.

Report message to a moderator

Re: Want to purge Obsolete Archive Backups. [message #381721 is a reply to message #381718]

Mon, 19 January 2009 07:29

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.

Report message to a moderator

Previous Topic:	Problem with backup
Next Topic:	Unable to issue DELETE OBSOLETE....in RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 08:31:10 CST 2024