ORACLE归档日志清理

su - oracle

rman target /

crosscheck archivelog all;

delete  archivelog until time "sysdate-1";

delete noprompt force archivelog until time "sysdate-7";

SELECT NAME,TOTAL_MB / 1024 总量G,COLD_USED_MB /1024 使用量G, FREE_MB / 1024 剩余G FROM V$ASM_DISKGROUP;