ORA-00257: archiver error. Connect internal only. until freed，ora-00257freed

最後更新：2015-04-29 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

ORA-00257: archiver error. Connect internal only. until freed，ora-00257freed
1，plsq登入報錯

ORA-00257: archiver error. Connect internalonly. until freed

2，後台alert日誌報錯：

[oracle@powerlong4 ~]$ tail -fn 200/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.log

Tue Apr 28 10:00:56 2015

Errors in file/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_arc9_30051.trc:

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

************************************************************************

You have following choices to free up spacefrom recovery area:

1. Consider changing RMAN RETENTION POLICY.If you are using Data Guard,

then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such astape using RMAN

BACKUP RECOVERY AREA command.

3. Add disk space and increasedb_recovery_file_dest_size parameter to

reflect the new space.

4. Delete unnecessary files using RMANDELETE command. If an operating

system command was used to delete files, then use RMAN CROSSCHECK and

DELETE EXPIRED commands.

************************************************************************

Errors in file/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_arc9_30051.trc:

ORA-19809: limit exceeded for recoveryfiles

ORA-19804: cannot reclaim 31602688 bytesdisk space from 19327352832 limit

ARC9: Error 19809 Creating archive log fileto'/oracle/app/oracle/flash_recovery_area/PDUNQ/archivelog/2015_04_28/o1_mf_1_75_%u_.arc'

----------------------------------------------------------------------------------------------------------------
<著作權，文章允許轉載，但必須以連結方式註明源地址，否則追究法律責任!>
原部落格地址： http://blog.csdn.net/mchdba/article/details/45332505
原作者：黃杉 (mchdba)
----------------------------------------------------------------------------------------------------------------

3，查看歸檔日誌

RMAN> crosscheck archivelog all; --先檢查下

...

validation succeeded for archived log

archived log filename=/oracle/app/oracle/flash_recovery_area/PDUNQ/archivelog/2015_04_23/o1_mf_1_72_bmkbwfrg_.arcRECID=63633 STAMP=877796493

validation succeeded for archived log

archived log filename=/oracle/app/oracle/flash_recovery_area/PDUNQ/archivelog/2015_04_23/o1_mf_1_73_bmkyqplx_.arcRECID=63634 STAMP=877816822

validation succeeded for archived log

archived log file name=/oracle/app/oracle/flash_recovery_area/PDUNQ/archivelog/2015_04_23/o1_mf_1_74_bmkysysc_.arcRECID=63635 STAMP=877816895

Crosschecked 1635 objects

看到有很多歸檔日誌，麼有應用到sendary庫上面。

4，這裡採用刪除多餘的歸檔日誌的辦法來操作，查看到期歸檔日誌

[oracle@powerlong4 ~]$ rman target /

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=787 devicetype=DISK

specification does not match any archivedlog in the repository

RMAN>

5，刪除到期的歸檔日誌

delete expired archivelog all;

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=787 devicetype=DISK

specification does not match any archivedlog in the repository

RMAN>

看到沒有到期的歸檔日誌

6，看到沒有到期的，不夠我們可以刪除指定到具體的時間，這樣也可以騰出空間來

RMAN>delete archivelog until time"to_date('2015-04-27 13:00:00','yyyy-mm-dd hh24:mi:ss')";

部分執行過程如下：