问题说明

此数据库为自己通过重建控制文件，利用已有的数据文件进行恢复的。

恢复之后一直出现现在看到的这个数据库自动关闭的问题。

早上来查看了告警日志，进行问题诊断和解决。

告警日志如下：

******************************begin of log********************************************

Fri Apr 24 11:28:22 2009
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 2512
Fri Apr 24 11:28:59 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 75497472
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 289406976
  control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 201326592
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
  db_name                  = orcl
  open_cursors             = 300
  pga_aggregate_target     = 95420416
PMON started with pid=2, OS id=2020
PSP0 started with pid=3, OS id=1788
MMAN started with pid=4, OS id=1880
DBW0 started with pid=5, OS id=612
LGWR started with pid=6, OS id=3876
CKPT started with pid=7, OS id=3152
SMON started with pid=8, OS id=3136
RECO started with pid=9, OS id=1484
CJQ0 started with pid=10, OS id=3688
MMON started with pid=11, OS id=2376
Fri Apr 24 11:28:59 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3992
Fri Apr 24 11:28:59 2009
starting up 1 shared server(s) ...
Fri Apr 24 11:28:59 2009
ALTER DATABASE   MOUNT
Fri Apr 24 11:29:03 2009
Setting recovery target incarnation to 2
Fri Apr 24 11:29:03 2009
Successful mount of redo thread 1, with mount id 1212815611
Fri Apr 24 11:29:03 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Apr 24 11:29:04 2009
ALTER DATABASE OPEN
Fri Apr 24 11:29:04 2009
Beginning crash recovery of 1 threads
Fri Apr 24 11:29:04 2009
Started redo scan
Fri Apr 24 11:29:04 2009
Completed redo scan
 177 redo blocks read, 39 data blocks need recovery
Fri Apr 24 11:29:04 2009
Started redo application at
 Thread 1: logseq 10, block 317
Fri Apr 24 11:29:05 2009
Recovery of Online Redo Log: Thread 1 Group 2 Seq 10 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Apr 24 11:29:05 2009
Completed redo application
Fri Apr 24 11:29:05 2009
Completed crash recovery at
 Thread 1: logseq 10, block 494, scn 3745943
 39 data blocks read, 39 data blocks written, 177 redo blocks read
Fri Apr 24 11:29:06 2009
Thread 1 advanced to log sequence 11
Thread 1 opened at log sequence 11
  Current log# 1 seq# 11 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Fri Apr 24 11:29:06 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 24 11:29:06 2009
SMON: enabling cache recovery
Fri Apr 24 11:29:07 2009
Successfully onlined Undo Tablespace 1.
Fri Apr 24 11:29:07 2009
SMON: enabling tx recovery
Fri Apr 24 11:29:07 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=2324
Fri Apr 24 11:29:14 2009
Completed: ALTER DATABASE OPEN
Fri Apr 24 11:29:14 2009
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Apr 24 11:29:18 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_2376.trc:
ORA-00600: internal error code, arguments: [4194], [41], [39], [], [], [], [], []

Doing block recovery for file 2 block 11018
Block recovery from logseq 11, block 65 to scn 3746152
Fri Apr 24 11:29:21 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 11.69.16, scn 0.3746154
Doing block recovery for file 2 block 73
Block recovery from logseq 11, block 65 to scn 3746148
Fri Apr 24 11:29:22 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 11.66.16, scn 0.3746150
Fri Apr 24 11:29:24 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_1960.trc:
ORA-00600: 内部错误代码, 参数: [4194], [41], [39], [], [], [], [], []

Fri Apr 24 11:29:26 2009
DEBUG: Replaying xcb 0x34a2f844, pmd 0x34baf0bc for failed op 8
Doing block recovery for file 2 block 11018
Block recovery from logseq 11, block 65 to scn 3746152
Fri Apr 24 11:29:26 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 11.69.16, scn 0.3746154
Fri Apr 24 11:29:27 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_1960.trc:
ORA-00600: 内部错误代码, 参数: [4194], [41], [39], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [41], [39], [], [], [], [], []

Fri Apr 24 11:29:29 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_1960.trc:
ORA-00600: 内部错误代码, 参数: [4194], [41], [39], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: [4194], [41], [39], [], [], [], [], []

Fri Apr 24 11:29:31 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_1960.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4194], [41], [39], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [41], [39], [], [], [], [], []

Fri Apr 24 11:29:32 2009
DEBUG: Replaying xcb 0x34a2f844, pmd 0x34baf0bc for failed op 8
Doing block recovery for file 2 block 11018
Block recovery from logseq 11, block 65 to scn 3746152
Fri Apr 24 11:29:32 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 11.69.16, scn 0.3746154
Fri Apr 24 11:29:33 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3136.trc:
ORA-00600: internal error code, arguments: [4194], [41], [39], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing shrinking of rollback segments.
SMON encountered 1 out of maximum 100 non-fatal internal errors.

******************************end of log***********************************************

10:58:00
SQL>SHUTDOWN IMMEDIATE;
ORA-00607:当更改数据块是出现内部错误
ORA-00608:内部错误代码，参数：[4194],[41],[39],[],[],[],[],[]

恢复undo table space即可

SQL>create spfile from pfile;
SQL>shutdown immediate;
SQL>startup;
SQL>alter database datafile 'd:\oracle\oradata\orcl\undotbs01.dbf' offline drop;
database altered;

SQL>create unto tablespace undotbs2 datafile 'd:\oracle\oradata\orcl\undotbs02.dbf' size 10m;
tablespace created;

SQL>alter system set undo_tablespace='undotbs2';
system altered;

系统自己shutdown的问题解决。