This content has been marked as final. Show 6 replies
So, what you mean is
Whenever we set "CONFIGURE ARCHIVE LOG DELETION POLICY TO APPLIED to standby".
delete archivelog all
On standby ,
The RMAN will consider only the applied archives for the deletion .Right?
In that case , what should be the retention policy ( we are not taking any backups at standby).
I used to clean up the archived log files on STANDBY after they are applied.
To do that i just check it using broker (dgmgrl) and check the lag configuration...
Another option is to check v$archived_log applied status:
in both case is manual.
select * from v$archived_log where APPLIED='YES';
If you plan to use automatic clean up you should set the threshold for FRA...
Also how you set ARCHIVE LOG DELETION POLICY will depend upon where your RMAN backup occurs.
If you run it on the Standby you might set this to NONE.
Most of these questions can be answered by reading :
Using RMAN to Back Up and Restore Files in E25608-04
Edited by: mseberg on Jan 30, 2013 12:11 PM
1. What should be the retention policy at standby , if we are not taking backups at stand by,
2)What is the effect of logdeletion_policy setting at standby.
3) Does the below understanding correct ,
CONFIGURE ....applied to standby; is just a setting ,which will make sure that the archive logs that are not applied will not be deleted, and archivelog all will throw errors like "WARNING: archived log not deleted, needed for standby or upstream capture process".
CONFIGURE ...applied to standby; cannot make the archives obsolete , the retention policy setting is the only way to do it. If this is the case "when there is space crunch ,will the FRA auto purge process consider the applied archive logs for deletion".How to make them obsolete i.e what is the retention policy that need to be used at standby.
I read the 11.3 in " http://docs.oracle.com/cd/E11882_01/server.112/e25608/title.htm ".
And regarding " 11.3.4 RMAN Configurations at a Standby Where Backups Are Not Performed",
We generally don't have any rman scripts / rman cron jobs , where we are not performing any backups , so i thought like it would be automatic archival purge with the setting configure ..... on standby, but is not in real.And that is not mentioned in the document.