星期三, 4月 11, 2012

[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 ;

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...