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;