How to delete old useless archivelog in FLASHDG diskgroup in ASM

If FLASHDG diskDG was not enough, delete previous days old archivelog and crosscheck archivelog in RMAN also(Please make sure we have archivelog backup before you delete them

select 'alter diskgroup DSKGRP1 drop file
''+FLASHDG/pcard/arch/'|| to_char(b.creation_date,'YYYY_MM_DD') ||'/'|| a.name||''';'
from v$asm_alias a, v$asm_file b
where a.group_number = b.group_number
and a.file_number = b.file_number
and b.type='ARCHIVELOG'
order by a.name;

rman target sys/@pcard catalog=rmanusr/@rman

RMAN > crosscheck archivelog all;
delete expired archivelog all;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/317003/viewspace-591614/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/317003/viewspace-591614/