ARCHIVELOG DELETION POLICY

1. Базы primary и standby должны быть перезапущены с параметром: 

alter system set  "_log_deletion_policy" = 'ALL' scope=both;


2. На Primary:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;


3. На STANDBY:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;


CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT ARCHIVELOG ALL completed before 'SYSDATE-2/24';