Forum Discussion

rafanto's avatar
rafanto
Level 5
7 months ago

Delete after making copies in Oracle Archive Logs backup

Hello,

Please help with this query, we have an Oracle RAC environment (two nodes) replicated to a remote site through DataGuard, the query is:

In the OIP, in the Oracle tab, we can activate the option in the backups of the Archive Logs "Delete after making copies", if we enable this option, after 3 satisfactory backups, NetBackup performs a cross-check and validates that the archive logs have they already been applied to the remote site before to remove them?

Regards!

Rafael

  • Hello,

    yes it is validated, but not NetBackup, it is Oracle RMAN performing this crosscheck. If the archive logs are needed by DataGuard, their deletion will fail with the warning:

    RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby Or Upstream Capture Process

    Regards

    Michal

  • Hello,

    yes it is validated, but not NetBackup, it is Oracle RMAN performing this crosscheck. If the archive logs are needed by DataGuard, their deletion will fail with the warning:

    RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby Or Upstream Capture Process

    Regards

    Michal

  • I am not an expert in Oracle but as far as I know ,whatever configuration you see under Oracle Tab is basically options that you enable in the script (which is used by RMAN).
    so by saying delete after making copies 3,we are telling RMAN to not delete the logs until it has a record of them being backed up at least 3  times.it is RMAN duty to check the Redo logs and to find out which logs needed to be deleted from Oracle node(s) according to the script and commands which is being run.

    I hope someone with expertise in Oracle will read this and provide more information (and correct me if I am missing something as well) for you.