ORA-00257 archiver error 處理思路

1.首先查下oerr給出的簡要說明

2.查詢V$RECOVERY_AREA_USAGE資訊

3.根據實際空間剩餘情況先适當增加歸檔目錄的大小，保證先恢複業務

4.檢視備份是否存在問題

`oerr ora 257`

```

00257, 00000, "archiver error. Connect internal only, until freed."

// *Cause: The archiver process received an error while trying to archive

// a redo log. If the problem is not resolved soon, the database

// will stop executing transactions. The most likely cause of this

// message is the destination device is out of space to store the

// redo log file.

// *Action: Check archiver trace file for a detailed description

//of the problem. Also verify that the

// device specified in the initialization parameter

// ARCHIVE_LOG_DEST is set up properly for archiving.

注：10g是<code>v$flash_recovery_area_usage</code>

确定歸檔位置：

SQL&gt; select NAME, TOTAL_MB, FREE_MB from v$asm_diskgroup;

NAME TOTAL_MB FREE_MB

DATA 3068928 2418353

crosscheck backup;

crosscheck archivelog all;

delete expired archivelog all;

delete archivelog until time 'sysdate-1';

backup archivelog all delete input fromat '';

delete noprompt obsolete;