ORA-19815: WARNING: db_recovery_file_dest_size is 100.00% 处理方法

报错如下

ORA-19815: WARNING: db_recovery_file_dest_size of 4294967296 bytes is 100.00% used, and has 0 remaining bytes available.

增大闪回区

    ALTER SYSTEM SET db_recovery_file_dest_size='6G' SCOPE=BOTH;

删除时间较久的日志

    ASMCMD> ls
        2016_09_26/
        2016_09_27/
        2016_09_28/
    ASMCMD> cd 2016_09_26
    ASMCMD> rm -rf ./*
    ASMCMD> cd 2016_09_27
    ASMCMD> rm -rf ./*

登录rman删除 expired的条目

    rman target /
    crosscheck backup;
    delete expired backup;
    crosscheck archivelog all;
    delete expired archivelog all;

效果

    Thread 1 advanced to log sequence 448 (LGWR switch)
    Current log# 1 seq# 448 mem# 0: +DATA/racdb/onlinelog/group_1.261.918146461
    Current log# 1 seq# 448 mem# 1: +FRA/racdb/onlinelog/group_1.257.918146461
    Wed Sep 28 10:21:22 2016
    Some DDE async actions failed or were cancelled
    Wed Sep 28 10:21:24 2016
    LNS: Standby redo logfile selected for thread 1 sequence 448 for destination LOG_ARCHIVE_DEST_2
    Wed Sep 28 10:21:24 2016
    LNS: Standby redo logfile selected for thread 1 sequence 448 for destination LOG_ARCHIVE_DEST_3
    Wed Sep 28 10:21:33 2016
    Archived Log entry 1933 added for thread 1 sequence 447 ID 0x36deac68 dest 1: