ORA-00257 mysql_晚上客户端报错ORA-00257，求高手分析

问题：晚上23点30分左右，所有客户端无法通过pl\sql或者其他工具登如到oracle，报错信息：ORA-00257: archiver error. Connect internal only, until freed

从20点到凌晨1点10分的alert日志

Sat Jan 11 20:29:17 2014

Thread 1 advanced to log sequence 215 (LGWR switch)

Current log# 8 seq# 215 mem# 0: +DATA/crmdb/redo08.log

Sun Jan 12 00:06:06 2014

minact-scn: got error during useg scan e:12751 usn:20

minact-scn: useg scan erroring out with error e:12751

Sun Jan 12 00:08:23 2014

opidcl aborting process unknown ospid (16449836) as a result of ORA-604

Sun Jan 12 00:08:26 2014

opidcl aborting process unknown ospid (19070996) as a result of ORA-604

Sun Jan 12 00:11:12 2014

minact-scn: got error during useg scan e:12751 usn:20

minact-scn: useg scan erroring out with error e:12751

Sun Jan 12 01:06:16 2014

minact-scn: got error during useg scan e:12751 usn:20

minact-scn: useg scan erroring out with error e:12751

Sun Jan 12 01:09:27 2014

ORA-01555 caused by SQL statement below (SQL ID: fzwnuj0amdfvr, Query Duration=5913 sec, SCN: 0x0000.94c6568e):

DELETE FROM MGMT_JOB_HISTORY H WHERE STEP_ID = :B1 AND NOT EXISTS (SELECT 1 FROM MGMT_JOB_EXECUTION E WHERE E.STEP_ID = H.STEP_ID AND E.STEP_STATUS = H.STEP_STATUS)

由于当晚不是本人做的操作，1点10分左右重启数据库(做了删除部分归档日志操作)，事后想排查故障原因

简单介绍下信息

1.11.2.0.3.0的双节点rac

2.现有维护方式欠佳，不确定当晚是否是因为归档日志满导致，只是做了删除归档日志(约100g大小)

3.以下信息为正常后信息，不知道有没有高人能帮忙分析下故障原因

(从目前情况看，小弟实在看不出什么原因导致，重启实例后闪回也清了，不确定是否是因为闪回空间满导致)

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

GROUP#    THREAD# STATUS           ARC

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

1          1 INACTIVE         YES

2          1 CURRENT          NO

3          1 INACTIVE         YES

4          2 INACTIVE         YES

5          2 INACTIVE         YES

6          2 CURRENT          NO

7          1 INACTIVE         YES

8          1 INACTIVE         YES

8 rows selected.

select * from v$logfile;

返回结果也是8个，没有物理文件的缺失

SQL> select * from v$logfile;

GROUP# STATUS  TYPE  MEMBER  IS_

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

3  ONLINE +DATA/crmdb/redo03.log  NO

2  ONLINE +DATA/crmdb/redo02.log  NO

1  ONLINE +DATA/crmdb/redo01.log  NO

4  ONLINE +DATA/crmdb/redo04.log  NO

5  ONLINE +DATA/crmdb/redo05.log  NO

6  ONLINE +DATA/crmdb/redo06.log  NO

7  ONLINE +DATA/crmdb/redo07.log  NO

8  ONLINE +DATA/crmdb/redo08.log  NO

select * from v$flash_recovery_area_usage;

no rows selected

SQL> show parameter recover;

NAME                                 TYPE        VALUE

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

db_recovery_file_dest                string

db_recovery_file_dest_size           big integer 0

db_unrecoverable_scn_tracking        boolean     TRUE

recovery_parallelism                 integer     0

SQL>

SQL> show parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE

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

db_recovery_file_dest_size           big integer 0

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +ARCH

Oldest online log sequence     214

Next log sequence to archive   218

Current log sequence           218