启动数据库报ORA-03113错误；

jiawang

SQL> startup;

ORACLE 例程已经启动。

Total System Global Area 2505338880 bytes

Fixed Size                  2283824 bytes

Variable Size             603981520 bytes

Database Buffers         1879048192 bytes

Redo Buffers               20025344 bytes

数据库装载完毕。

ORA-03113: 通信通道的文件结尾

进程 ID: 3044

会话 ID: 125 序列号: 5

C:\Users\Administrator>sqlplus/ as sysdba

SQL*Plus: Release11.2.0.4.0 Production on 星期五 11月 10 10:12:19 2017

Copyright (c) 1982,2013, Oracle.  All rights reserved.

已连接到空闲例程。

SQL> startupmount;

ORACLE 例程已经启动。

Total System GlobalArea 2505338880 bytes

Fixed Size                  2283824 bytes

Variable Size             603981520 bytes

DatabaseBuffers         1879048192 bytes

Redo Buffers               20025344 bytes

数据库装载完毕。

SQL> showparameter background;

NAME                                 TYPE        VALUE

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

background_core_dump                 string      partial

background_dump_dest                 string      E:\app\ocal\diag\rdbms\oacl\orcl\trace

Oracle出现错误，去报警日志里去找问题根源在E:\app\ocal\diag\rdbms\oacl\orcl\trace\文件夹下找到orcl_ora_1828.trc，

Trace file E:\APP\OCAL\diag\rdbms\oacl\orcl\trace\orcl_ora_1828.trc

Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and RealApplication Testing options

Windows NT Version V6.0 Service Pack 1

CPU                 : 2 - type 8664, 2 PhysicalCores

Process Affinity   : 0x0x0000000000000000

Memory (Avail/Total): Ph:1107M/2046M,Ph+PgF:1076M/4330M

VM name            : VMWare Version (6)

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 19

Windows thread id: 1828, image: ORACLE.EXE (SHAD)

*** 2017-11-10 09:36:32.320

*** SESSION ID:(125.5) 2017-11-09 09:36:32.320

*** CLIENT ID:() 2017-11-09 09:36:32.320

*** SERVICE NAME:() 2017-11-09 09:36:32.320

*** MODULE NAME:(sqlplus.exe) 2017-11-09 09:36:32.320

*** ACTION NAME:() 2017-11-09 09:36:32.320

Initial buffer sizes: read 1024K, overflow 832K,change 805K

*** 2017-11-10 09:36:33.022

DDE rules only execution for: ORA 312

----- START Event Driven Actions Dump ----

---- END Event Driven Actions Dump ----

----- START DDE Actions Dump -----

Executing SYNC actions

----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK'(Async) -----

Successfully dispatched

----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK'(SUCCESS, 0 csec) -----

Executing ASYNC actions

----- END DDE Actions Dump (total 0 csec) -----

ORA-16014: 日志 1 sequence# 121 未归档, 没有可用的目的地

ORA-00312: 联机日志 1 线程 1: 'E:\APP\OCAL\REDO01.LOG'

kjzduptcctx: Notifying DIAG for crash event

----- Abridged Call Stack Trace -----

ksedsts()+585<-kjzdssdmp()+329<-kjzduptcctx()+288<-kjzdicrshnfy()+99<-ksuitm()+1525<-kcfopd()+6752<-adbdrv()+56896<-opiexe()+21915<-opiosq0()+4690<-kpooprx()+365<-kpoal8()+985<-opiodr()+1631<-ttcpip()+1462<-opitsk()+2201<-opiino()+1246<-opiodr()+1631<-opidrv()+861

<-sou2o()+98<-opimai_real()+158<-opimai()+191

----- End of Abridged Call Stack Trace -----

*** 2017-11-10 09:36:33.163

USER (ospid: 1828): terminating the instance due toerror 16014

*** 2017-11-10 09:36:35.721

ksuitm: waiting up to [5] seconds before killingDIAG(2184)

Trace fileE:\APP\OCAL\diag\rdbms\oacl\orcl\trace\orcl_ora_1828.trc

Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and RealApplication Testing options

Windows NT Version V6.0 Service Pack 1

CPU                : 2 - type 8664, 2 Physical Cores

Process Affinity   : 0x0x0000000000000000

Memory (Avail/Total): Ph:1231M/2046M,Ph+PgF:1285M/4330M

VM name            : VMWare Version (6)

Instance name: orcl

Redo thread mounted by this instance: 0 <none>

Oracle process number: 19

Windows thread id: 1828, image: ORACLE.EXE (SHAD)

*** 2017-11-10 10:12:59.168

*** SESSION ID:(125.3) 2017-11-09 10:12:59.168

*** CLIENT ID:() 2017-11-09 10:12:59.168

*** SERVICE NAME:() 2017-11-09 10:12:59.168

*** MODULE NAME:(sqlplus.exe) 2017-11-09 10:12:59.168

*** ACTION NAME:() 2017-11-09 10:12:59.168

Waiting for NSS2 [pid 1860] to initialize itself

krsu_start_ns: time appears to have jumped forwards

报错日志中显示日志未归档，没有可用的目的，可能是归档日志的问题。

解决办法：创建pfile文件查看归档日志路径，把数据库启动到mount状态，修改归档日志存放路径在D:\app\wangjia\arch目录下。

SQL>show parameter spfile;

NAME                                 TYPE        VALUE

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

spfile                               string      D:\APP\WANGJIA\PRODUCT\11.2.0\

                                                DBHOME_1\DATABASE\SPFILEOACL.ORA

SQL>create pfile='D:\app\wangjia\product\11.2.0\dbhome_1\database\init.ora' fromspfile;

文件已创建。

登录/注册后可看大图