[RMAN] Check archive log status in v$archived_log view

SQL>

select name , deleted , status from gv$archived_log;

如果DELETED=YES , Status=D 則代表已經被RMAN備份 且刪除

如果DELETED=NO , Status=A 則代表還未被RMAN備份 且會占用ASM/OS 空間.

SQL>

--檢查那些archive log 是否還沒被RMAN刪除 ( 兩天以前)

select name , deleted , status from gv$archived_log where FIRST_TIME < sysdate -2 and DELETED=NO ;