How to delete archive older than 1 day

Question

287 views17/04/2023Oracle Database

0

Amen1.09K 14/04/2023 0 Comments

How to delete archive older than 1 day? DBA scripts for deleting archive older than 1 day?

Ezana Answered question 17/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-17T15:34:33+00:00

Below are the sample SQL script for deleting archive older than 1 day:

RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-1';
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;