ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to delete old useless archivelog in FLASHDG diskgroup in ASM

How to delete old useless archivelog in FLASHDG diskgroup in ASM

原创 Linux操作系统 作者:yexichang 时间:2009-04-23 17:40:15 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-08-30

  • 博文量
    32
  • 访问量
    35224