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 (8)
  1. om 08:08

    Thanks for your Quality information the product developed by the company is perfect.Thanks for giving such a wonderful blog.

  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


    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 ?

  6. om 14:02

    Thank you so much for sharing this well written article with all - very objectively presented indeed!

    God Bless!

  7. om 15:03

    Thank You so much for such a detailed and simple explanation with examples.

Reactie plaatsen