【12c】ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

1 问题描述

1）登录数据库出错

[oracle@odd agent]$ sqlplus alen/alen@prod2
 
SQL*Plus: Release 12.1.0.2.0 Production on Fri May 22 23:46:30 2020
 
Copyright (c) 1982, 2014, Oracle. All rights reserved.
 
ERROR:
 
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

2 问题查看

1）查看ORA错误

[oracle@odd agent]$ oerr ora 00257
 
00257, 00000, "Archiver error. Connect AS SYSDBA only until resolved."
 
// *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 that the destination device is out of space to store the
 
// redo log file. Another possible cause is that a destination marked
 
// as MANDATORY has failed.
 
// *Action: Check the alert log and trace files for detailed error
 
// information.</