ORA-00350: log 2 of instance luda (thread 1) needs to be archived

 

SQL> select GROUP#,ARCHIVED ,STATUS from v$log;

 

    GROUP# ARC STATUS

———- — —————-

         1 NO  CURRENT

         3 NO  INACTIVE

         2 NO  INACTIVE

 

 

[oracle@dg1 09:50:38|~]oerr ora 262

00262, 00000, "current log %s of closed thread %s cannot switch"

// *Cause:  The log cannot be cleared or manually archived because it is

//          the current log of a closed thread, and it is not possible to

//          switch logs so another log is current. All other logs for the

//          thread need to be archived, or cleared, and cannot be reused.

// *Action: Archive another log in the same thread first, or complete the

//          clearing. See attached errors for the reason the switch cannot

//          be completed.

[oracle@dg1 09:59:25|~]oerr ora 312

00312, 00000, "online log %s thread %s: '%s'"

// *Cause:  This message reports the filename for details of another message.

// *Action: Other messages will accompany this message. See the

//          associated messages for the appropriate action to take.

[oracle@dg1 09:59:30|~]oerr ora 350

00350, 00000, "log %s of instance %s (thread %s) needs to be archived"

// *Cause:  The command cannot be done because the log has not been archived,

//          and media recovery has been enabled.

// *Action: Archive the log or disable media recovery. If the command supports

//          an UNARCHIVED option then it can be used. However this may result

//          in making backups unuseable, and forcing the drop of some offline

//          files.

 

 

这里报2个日志组，快速解决办法：