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; 文件已创建。 |