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;

请使用浏览器的分享功能分享到微信等