Deleting Archive Log files in a Data Guard environment
Gepubliceerd: Auteur: Bastiaan Bak Categorie: Oracle
Reacties (8)
Thanks for your Quality information the product developed by the company is perfect.Thanks for giving such a wonderful blog. https://www.erptree.com/course/oracle-r12-financials-training-in-ameerpet-hyderabad/
Thanks Bastiaan! This blog helped me.
Thanks for informative article
I wonder if behavior is same when using shipped option like below
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
Thank you. The "shipped" option can be used in situations where we do not apply the redo on the standby database immediately.
2 situations when the redo is shipped to the standby, but not applied are :
- DELAY=minutes attribute of the LOG_ARCHIVE_DEST_n initialization parameter
- when you convert the standby database to a snapshot standby
So, then you can choose to create a policy that deletes the archives from the primary when they are shipped to the standby , but not yet applied. The rest of the behavior should be the same indeed.
Very useful information ..Great
Does FRA retention target db_flashback_retention_target plays part in this delayed removal ?
What if we want to set threshold for archive logs deletion(which are already applied on standby DB) ? is there any way we can do that ?
Thank you so much for sharing this well written article with all - very objectively presented indeed!
God Bless!
Thank You so much for such a detailed and simple explanation with examples.