Home » RDBMS Server » Backup & Recovery » manage my old archive logs
manage my old archive logs [message #228783] Wed, 04 April 2007 03:11 Go to next message
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?
Re: manage my old archive logs [message #228914 is a reply to message #228783] Wed, 04 April 2007 09:17 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
You may want to set the following in your RMAN configuration:
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.
Previous Topic: problem creating auxiliary db using RMAN, Help
Next Topic: about back up and recovery
Goto Forum:

Current Time: Mon Aug 21 18:50:33 CDT 2017

Total time taken to generate the page: 0.08165 seconds