ORA-00257解决

ORA-00257: archiver error.Connect internal only, until freed.
 
Cause: Thearchiver process received an error while trying to archive a redo log. If theproblem is not resolved soon, the database will stop executing transactions.The most likely cause of this message is the destination device is out of spaceto store the redo log file.
 
Action: Checkthe archiver trace file for a detailed description of the problem. Also, verifythat the device specified in the initialization parameterarchive_log_dest isset up properly for archiving.

Archivelog对应的Mount point空间不足，删除过期文件

SQL> show parameter log_archive_dest;

 

NAME                                 TYPE

--------------------------------------------------------------------

VALUE

------------------------------

log_archive_dest                     string

/export/home/xxx/admin/arch/

因为环境不是生产环境，只是QA环境，所以直接把LOG删除了。

 cd admin
cd arch
arch> cd xxx
rm -rf *arc*

 

SQL> alter system archive log current;

System altered.