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.</