Tue Sep 28 20:20:45 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMIS.ORA
System parameters with non-default values:
processes = 150
memory_target = 804M
control_files = "E:\APP\ADMINISTRATOR\ORADATA\MIS\CONTROL01.CTL"
control_files = "E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\MIS\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "E:\app\Administrator\flash_recovery_area"
db_recovery_file_dest_size= 8G
_allow_resetlogs_corruption= TRUE
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=MISXDB)"
audit_file_dest = "E:\APP\ADMINISTRATOR\ADMIN\MIS\ADUMP"
audit_trail = "DB"
db_name = "MIS"
open_cursors = 300
diagnostic_dest = "E:\APP\ADMINISTRATOR"
Tue Sep 28 20:20:45 2010
PMON started with pid=2, OS id=2468
Tue Sep 28 20:20:45 2010
VKTM started with pid=3, OS id=2632 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Sep 28 20:20:45 2010
GEN0 started with pid=4, OS id=2384
Tue Sep 28 20:20:45 2010
DIAG started with pid=5, OS id=544
Tue Sep 28 20:20:45 2010
DBRM started with pid=6, OS id=924
Tue Sep 28 20:20:45 2010
PSP0 started with pid=7, OS id=1224
Tue Sep 28 20:20:45 2010
DIA0 started with pid=8, OS id=3420
Tue Sep 28 20:20:45 2010
MMAN started with pid=9, OS id=2268
Tue Sep 28 20:20:45 2010
DBW0 started with pid=10, OS id=3816
Tue Sep 28 20:20:45 2010
LGWR started with pid=11, OS id=2640
Tue Sep 28 20:20:45 2010
CKPT started with pid=12, OS id=2700
Tue Sep 28 20:20:45 2010
SMON started with pid=13, OS id=2324
Tue Sep 28 20:20:45 2010
RECO started with pid=14, OS id=1968
Tue Sep 28 20:20:45 2010
MMON started with pid=15, OS id=1664
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = E:\app\Administrator
Tue Sep 28 20:20:46 2010
ALTER DATABASE MOUNT
Tue Sep 28 20:20:45 2010
MMNL started with pid=16, OS id=2988
Tue Sep 28 20:20:49 2010
Sweep [inc][172917]: completed
Sweep [inc2][172917]: completed
Successful mount of redo thread 1, with mount id 2124512606
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Sep 28 20:20:50 2010
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
read 28 KB redo, 4 data blocks need recovery
Started redo application at
Thread 1: logseq 2, block 3
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
Mem# 0: E:\APP\ADMINISTRATOR\ORADATA\MIS\REDO02.LOG
Completed redo application of 0.02MB
Completed crash recovery at
Thread 1: logseq 2, block 60, scn 6061339
4 data blocks read, 4 data blocks written, 28 redo k-bytes read
Thread 1 advanced to log sequence 3 (thread open)
Thread 1 opened at log sequence 3
Current log# 3 seq# 3 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\MIS\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Errors in file e:\app\administrator\diag\rdbms\mis\mis\trace\mis_smon_2324.trc (incident=174117):
ORA-00600: internal error code, arguments: [4194], [], [
Incident details in: e:\app\administrator\diag\rdbms\mis\mis\incident\incdir_174117\mis_smon_2324_i174117.trc
No Resource Manager plan active
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x42E19C1B] [PC:0x6D11343, _kgegpa()+47]
Tue Sep 28 20:20:52 2010
Errors in file e:\app\administrator\diag\rdbms\mis\mis\cdump\miscore.log
ORA-07445: caught exception [ACCESS_VIOLATION] at [_kgegpa()+47] [0x06D11343]
Trace dumping is performing id=[cdmp_20100928202053]
Doing block recovery for file 3 block 4305
PMON (ospid: 2468): terminating the instance due to error 397
Tue Sep 28 20:20:56 2010
Instance terminated by PMON, pid = 2468
-------------------以上是日志
启动出错
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 339739088 bytes
Database Buffers 188743680 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾
进程 ID: 1684
会话 ID: 125 序列号: 5