11G OCM Configure archivelog deletion policy for the dataguard configuration

References

Oracle® Data Guard Concepts and Administration 11g Release 1 (11.1)

• Chapter 11, "Using RMAN to Back Up and Restore Files"
  • Recommended RMAN and Oracle Database Configurations
    • RMAN Configurations at the Primary Database
    • RMAN Configurations at a Standby Database Where Backups are Performed

Overview

The OCM objective is:

Configure archivelog deletion policy for the dataguard configuration

This procedure deletes archived REDO log files on the primary once they have been applied to all the standby databases, and deletes them on the standby databases once they have been backed up at least once.

Procedure

Primary Database

Under RMAN on the primary database,

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

Standby Database

Under RMAN on the standby where the backups are done,

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DEVICE TYPE DISK;