Deleting Archive Log files in a Data Guard environment

Deleting Archive Log files in a Data Guard environment

Gepubliceerd: Categorie: Oracle
Bastiaan Bak
Over auteur Bastiaan Bak

DBA met ruim 15 jaar ervaring. Ervaring in verschillende branches, met verschillende modules. Onder meer: Oracle Database, Oracle RAC, Oracle EBS en PL/SQL.

Meer posts van Bastiaan Bak
Reacties (6)
  1. om 08:08

    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/

  2. om 09:09

    Thanks Bastiaan! This blog helped me.

  3. om 06:06

    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;

    1. om 09:09

      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.

  4. om 11:11

    Very useful information ..Great

  5. om 12:12

    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 ?

Reactie plaatsen