归档错误（ORA-16038）致数据库不能open解决(二)
Copyright (c) 1982, 2011,
Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL>
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
------------------------------------------------------------
MOUNTED
SQL> alter session set tracefile_identifier='16038error';
Session altered.
SQL> alter session set events '16038 trace name errorstack level 3';
Session altered.
SQL> alter database open;
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 25550
Session ID: 191 Serial number: 3
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
引用
[oracle@rac5 ~]$
[oracle@rac5 ~]$ find /u01/app/ -name '*16038error*'
/u01/app/oracle/diag/rdbms/prodb/prodb/trace/prodb_ora_25550_16038error.trm
/u01/app/oracle/diag/rdbms/prodb/prodb/trace/prodb_ora_25550_16038error.trc
[oracle@rac5 ~]$
查看跟踪文件，注意红色字体
引用
[oracle@rac5 ~]$ more /u01/app/oracle/diag/rdbms/prodb/prodb/trace/prodb_ora_25550_16038error.trc
Trace file /u01/app/oracle/diag/rdbms/prodb/prodb/trace/prodb_ora_25550_16038error.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/db
System name:
Linux
Node name: rac5
Release: 2.6.32-358.el6.x86_64
Version: #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine: x86_64
VM name: VMWare Version: 6
Instance name: prodb
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 25550, image: oracle@rac5 (TNS V1-V3)
*** 2013-09-18 16:38:19.409
*** SESSION ID:(191.3) 2013-09-18 16:38:19.409
*** CLIENT ID:() 2013-09-18 16:38:19.409
*** SERVICE NAME:() 2013-09-18 16:38:19.409
*** MODULE NAME:(sqlplus@rac5 (TNS V1-V3)) 2013-09-18 16:38:19.409
*** ACTION NAME:() 2013-09-18 16:38:19.409
Initial buffer sizes: read 1024K, overflow 832K, change 805K
Log read is SYNCHRONOUS though disk_asynch_io is enabled!
Failed to create file '/u01/app/oracle/oradata/prodb/archivelog/1_6_823603498.dbf' (file not accessible )
*** 2013-09-18 16:38:19.410 4320 krsh.c
ARCH: Error 19504 Creating archive log file to '/u01/app/oracle/oradata/prodb/archivelog/1_6_823603498.dbf'