OraFAQ Forum: Backup & Recovery » manage my old archive logs

Home » RDBMS Server » Backup & Recovery » manage my old archive logs

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

manage my old archive logs [message #228783]

Wed, 04 April 2007 03:11

dashraf
Messages: 1
Registered: March 2007

Junior Member

Dear All,

I have a situation where my archived logs sizes coming bigger and bigger, why? because I removed the 'delete input' from my backup script.

I have two physical standby databases and when the 'delete input' was in my script I lost archived logs that were not transfered to my standby databases, so I desided to stop the delete in my scripts.

and Now I have many archived logs that needs to be deleted and also to automate this delete in a script after my initial backup script to delete old archived logs. for example: to delete old archived logs from 'sysdate -3' to 'sysdate -1'

By this I gurantee the transfer of logs before deleting and tidy up by archivelog directory. Can someone help?

Report message to a moderator

Re: manage my old archive logs [message #228914 is a reply to message #228783]

Wed, 04 April 2007 09:17

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may want to set the following in your RMAN configuration:

Code: [Select all] [Show/ hide]

configure archivelog deletion policy to applied on standby;

With this, the archive logs won't be eligible for deletion until they have been successfully applied to all manadatory standby databases.

Report message to a moderator

Previous Topic:	New DBA trying recovery scenarios
Next Topic:	Export Error EXP-00008 and ORA-00904

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 03:51:21 CDT 2025