oracle检查归档日志大小和删除

show parameter db_recovery_file_dest_size;

select sum(a.BLOCK_SIZE*a.BLOCKS)/1024/1024 from v$archived_log a where a.DELETED='NO';

SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024 AS "Size(M)",TRUNC(completion_time) FROM v$archived_log
GROUP BY TRUNC(completion_time)

删除归档日志

RMAN>connect target /

RMAN>list archivelog all;

RMAN>list copy of archivelog until time ‘SYSDATE-10′;

RMAN>list copy of archivelog from time ‘SYSDATE-10′

RMAN>list copy of archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;

RMAN>list copy of archivelog from sequence 1000;

RMAN>list copy of archivelog until sequence 1500;

RMAN>list copy of archivelog from sequence 1000 until sequence 1500;

RMAN>delete archivelog all;

RMAN>delete archivelog until time ‘SYSDATE-10′;

RMAN>delete archivelog from time ‘SYSDATE-10′

RMAN>delete archivelog from time ‘SYSDATE-10′ until time ‘SYSDATE-2′;

RMAN>delete archivelog from sequence 1000;

RMAN>delete archivelog until sequence 1500;

RMAN>delete archivelog from sequence 1000 until sequence 1500;

RMAN>delete noprompt archivelog until time ‘SYSDATE-10′;