Saturday, October 14, 2023

Archive Log Deletion Policy in Oracle Database RMAN Configuration

RMAN> Show all;   --> use this command to view the RMAN configuration settings

1. Eligible to delete archivelog files applied on all standby databases (required for DR setup) and those files should be backed up 1 time on the database (primary/production).

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK;


2. No Deletion policy. Eligible to delete all available archivelog files from the database.

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;


3. Eligible to delete all archivelog files applied on all standby databases (DR environment).

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;


4. Eligible to delete archivelog files which are already backed up 1 time by the database.

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

No comments:

Post a Comment