| 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?
|
|
|
|
| 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:
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
