OraFAQ Forum: Data Guard » CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

Home » Server Options » Data Guard » CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY (Oracle 11.2.0.2 Linux)

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

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #570855]

Fri, 16 November 2012 10:25

BeefStu
Messages: 208
Registered: October 2011

Senior Member

I have a DR setup with the following configuration

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
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;
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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

I dont want to backup the STDBY DB but I want the ARC files to be removed when applied so my flash area does not fill up. Is there some command(rman or not) that can fire off this policy? Any examples would be greatly appreciated.

Thanks to all who answer

Report message to a moderator

Re: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #570856 is a reply to message #570855]

Fri, 16 November 2012 10:41

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

Senior Member
Account Moderator

http://docs.oracle.com/cd/E11882_01/server.112/e25608/manage_ls.htm#SBYDB00810

Report message to a moderator

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #570858 is a reply to message #570856]

Fri, 16 November 2012 11:25

BeefStu
Messages: 208
Registered: October 2011

Senior Member

Mashesh,
to me it looks like the logs need to stay around for 24 hrs or 1440 based on db_flashback_retention_target.

What causes the deletion policy to kick in? Do I need to run some rman command?

Report message to a moderator

Re: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #570861 is a reply to message #570858]

Fri, 16 November 2012 12:35

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

If you run
delete archive log all;
on the standby, that should delete all the applied logs. Otherwise, I think you'll have to wait until the FRA is full before any automatic deletion kicks in. But I think your recovery window will distort things, better get rid of it.

Report message to a moderator

Re: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #570866 is a reply to message #570861]

Fri, 16 November 2012 13:21

BeefStu
Messages: 208
Registered: October 2011

Senior Member

thanks will test it out

Report message to a moderator

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #578221 is a reply to message #570855]

Mon, 25 February 2013 15:39

BeefStu
Messages: 208
Registered: October 2011

Senior Member

FYI:

The only automatic deletion of archive logs on the standby will occur if he flash recovery area becomes 100% full on the standby and considered obsolete according to the retention policy for rman. Then as space is needed, files that are in the FRA that are considered obsolete will be deleted (not all obsolete files, just enough to make the FRA no longer full).

The setting "CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; " does not mean that the standby database deletes the archive log after their file is applied, it means that the file can be deleted from the FRA when the FRA becomes full.

If you want the archive logs deleted sooner than that, you would need to use rman to delete archive logs.

In this example archive logs would be deleted after they are 7 days old:
delete archivelog until time 'trunc(sysdate-7)';

Report message to a moderator

Re: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY [message #578236 is a reply to message #578221]

Tue, 26 February 2013 00:46

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

Senior Member
Account Moderator

Thanks for these information.

Regards
Michel

Report message to a moderator

Previous Topic:	physical standby on windows 2003
Next Topic:	LGWR SYNC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:00:46 CST 2025