两台服务器都是win2003系统,其中一台oracle总是自动关闭,重装了oracle,问题依旧,另一台服务器是干净的新服务器,刚刚装完oracle运行没两天,又自己关闭,搞得头都大了,第一台服务器的alert.log如下:
Thu Mar 03 14:45:07 2011
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Fri Mar 04 15:24:20 2011
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Sat Mar 05 16:00:22 2011
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Sun Mar 06 16:35:22 2011
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Mon Mar 07 17:26:25 2011
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Dump file d:\oracle\admin\cygc\bdump\alert_cygc.log
Thu Mar 10 09:47:37 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Thu Mar 10 09:47:37 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\cygc\CONTROL01.CTL, D:\oracle\oradata\cygc\CONTROL02.CTL, D:\oracle\oradata\cygc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = cygc
dispatchers = (PROTOCOL=TCP) (SERVICE=cygcXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\cygc\bdump
user_dump_dest = D:\oracle\admin\cygc\udump
core_dump_dest = D:\oracle\admin\cygc\cdump
sort_area_size = 524288
db_name = cygc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Mar 10 09:47:40 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 09:47:42 2011
/* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 09:47:46 2011
Successful mount of redo thread 1, with mount id 1766216702.
Thu Mar 10 09:47:46 2011
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 09:47:47 2011
/* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 09:47:47 2011
Beginning crash recovery of 1 threads
Thu Mar 10 09:47:47 2011
Started first pass scan
Thu Mar 10 09:47:47 2011
Completed first pass scan
4258 redo blocks read, 65 data blocks need recovery
Thu Mar 10 09:47:48 2011
Started recovery at
Thread 1: logseq 12, block 172474, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Thu Mar 10 09:47:48 2011
Ended recovery at
Thread 1: logseq 12, block 176732, scn 0.337548397
65 data blocks read, 65 data blocks written, 4258 redo blocks read
Crash recovery completed successfully
Thu Mar 10 09:47:48 2011
Thread 1 advanced to log sequence 13
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Successful open of redo thread 1.
Thu Mar 10 09:47:48 2011
SMON: enabling cache recovery
Thu Mar 10 09:47:49 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 09:47:49 2011
SMON: enabling tx recovery
Thu Mar 10 09:47:49 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 10:01:21 2011
found dead shared server 'S000', pid = (10, 1)
Dump file d:\oracle\admin\cygc\bdump\alert_cygc.log
Thu Mar 10 16:43:32 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Thu Mar 10 16:43:32 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\cygc\CONTROL01.CTL, D:\oracle\oradata\cygc\CONTROL02.CTL, D:\oracle\oradata\cygc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = cygc
dispatchers = (PROTOCOL=TCP) (SERVICE=cygcXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\cygc\bdump
user_dump_dest = D:\oracle\admin\cygc\udump
core_dump_dest = D:\oracle\admin\cygc\cdump
sort_area_size = 524288
db_name = cygc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Mar 10 16:43:36 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 16:43:37 2011
/* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 16:43:42 2011
Successful mount of redo thread 1, with mount id 1766200953.
Thu Mar 10 16:43:42 2011
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 16:43:42 2011
/* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 16:43:42 2011
Beginning crash recovery of 1 threads
Thu Mar 10 16:43:42 2011
Started first pass scan
Thu Mar 10 16:43:43 2011
Completed first pass scan
4290 redo blocks read, 68 data blocks need recovery
Thu Mar 10 16:43:43 2011
Started recovery at
Thread 1: logseq 13, block 11545, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 13 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Thu Mar 10 16:43:43 2011
Ended recovery at
Thread 1: logseq 13, block 15835, scn 0.337591403
68 data blocks read, 68 data blocks written, 4290 redo blocks read
Crash recovery completed successfully
Thu Mar 10 16:43:43 2011
Thread 1 advanced to log sequence 14
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Successful open of redo thread 1.
Thu Mar 10 16:43:44 2011
SMON: enabling cache recovery
Thu Mar 10 16:43:45 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 16:43:45 2011
SMON: enabling tx recovery
Thu Mar 10 16:43:45 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 03 14:45:07 2011
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Fri Mar 04 15:24:20 2011
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Sat Mar 05 16:00:22 2011
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Sun Mar 06 16:35:22 2011
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Mon Mar 07 17:26:25 2011
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Dump file d:\oracle\admin\cygc\bdump\alert_cygc.log
Thu Mar 10 09:47:37 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Thu Mar 10 09:47:37 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\cygc\CONTROL01.CTL, D:\oracle\oradata\cygc\CONTROL02.CTL, D:\oracle\oradata\cygc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = cygc
dispatchers = (PROTOCOL=TCP) (SERVICE=cygcXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\cygc\bdump
user_dump_dest = D:\oracle\admin\cygc\udump
core_dump_dest = D:\oracle\admin\cygc\cdump
sort_area_size = 524288
db_name = cygc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Mar 10 09:47:40 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 09:47:42 2011
/* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 09:47:46 2011
Successful mount of redo thread 1, with mount id 1766216702.
Thu Mar 10 09:47:46 2011
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 09:47:47 2011
/* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 09:47:47 2011
Beginning crash recovery of 1 threads
Thu Mar 10 09:47:47 2011
Started first pass scan
Thu Mar 10 09:47:47 2011
Completed first pass scan
4258 redo blocks read, 65 data blocks need recovery
Thu Mar 10 09:47:48 2011
Started recovery at
Thread 1: logseq 12, block 172474, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 12 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\CYGC\REDO02.LOG
Thu Mar 10 09:47:48 2011
Ended recovery at
Thread 1: logseq 12, block 176732, scn 0.337548397
65 data blocks read, 65 data blocks written, 4258 redo blocks read
Crash recovery completed successfully
Thu Mar 10 09:47:48 2011
Thread 1 advanced to log sequence 13
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Successful open of redo thread 1.
Thu Mar 10 09:47:48 2011
SMON: enabling cache recovery
Thu Mar 10 09:47:49 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 09:47:49 2011
SMON: enabling tx recovery
Thu Mar 10 09:47:49 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 10:01:21 2011
found dead shared server 'S000', pid = (10, 1)
Dump file d:\oracle\admin\cygc\bdump\alert_cygc.log
Thu Mar 10 16:43:32 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Thu Mar 10 16:43:32 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\cygc\CONTROL01.CTL, D:\oracle\oradata\cygc\CONTROL02.CTL, D:\oracle\oradata\cygc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = cygc
dispatchers = (PROTOCOL=TCP) (SERVICE=cygcXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\cygc\bdump
user_dump_dest = D:\oracle\admin\cygc\udump
core_dump_dest = D:\oracle\admin\cygc\cdump
sort_area_size = 524288
db_name = cygc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Mar 10 16:43:36 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 16:43:37 2011
/* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 16:43:42 2011
Successful mount of redo thread 1, with mount id 1766200953.
Thu Mar 10 16:43:42 2011
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Thu Mar 10 16:43:42 2011
/* OracleOEM */ ALTER DATABASE OPEN
Thu Mar 10 16:43:42 2011
Beginning crash recovery of 1 threads
Thu Mar 10 16:43:42 2011
Started first pass scan
Thu Mar 10 16:43:43 2011
Completed first pass scan
4290 redo blocks read, 68 data blocks need recovery
Thu Mar 10 16:43:43 2011
Started recovery at
Thread 1: logseq 13, block 11545, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 13 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\CYGC\REDO03.LOG
Thu Mar 10 16:43:43 2011
Ended recovery at
Thread 1: logseq 13, block 15835, scn 0.337591403
68 data blocks read, 68 data blocks written, 4290 redo blocks read
Crash recovery completed successfully
Thu Mar 10 16:43:43 2011
Thread 1 advanced to log sequence 14
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLE\ORADATA\CYGC\REDO01.LOG
Successful open of redo thread 1.
Thu Mar 10 16:43:44 2011
SMON: enabling cache recovery
Thu Mar 10 16:43:45 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 16:43:45 2011
SMON: enabling tx recovery
Thu Mar 10 16:43:45 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Dump file d:\oracle\admin\glis\bdump\alert_glis.log
Thu Mar 10 13:36:28 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Thu Mar 10 13:36:28 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\glis\CONTROL01.CTL, D:\oracle\oradata\glis\CONTROL02.CTL, D:\oracle\oradata\glis\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = glis
dispatchers = (PROTOCOL=TCP) (SERVICE=glisXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\glis\bdump
user_dump_dest = D:\oracle\admin\glis\udump
core_dump_dest = D:\oracle\admin\glis\cdump
sort_area_size = 524288
db_name = glis
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
DBW2 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
CJQ0 started with pid=10
QMN0 started with pid=11
Thu Mar 10 13:36:31 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 13:36:32 2011
alter database mount exclusive
Thu Mar 10 13:36:39 2011
Successful mount of redo thread 1, with mount id 1007197859.
Thu Mar 10 13:36:39 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Mar 10 13:36:39 2011
alter database open
Thu Mar 10 13:36:39 2011
Beginning crash recovery of 1 threads
Thu Mar 10 13:36:39 2011
Started first pass scan
Thu Mar 10 13:36:39 2011
Completed first pass scan
4233 redo blocks read, 107 data blocks need recovery
Thu Mar 10 13:36:39 2011
Started recovery at
Thread 1: logseq 9, block 179401, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 9 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\GLIS\REDO02.LOG
Thu Mar 10 13:36:39 2011
Ended recovery at
Thread 1: logseq 9, block 183634, scn 0.1619319
107 data blocks read, 106 data blocks written, 4233 redo blocks read
Crash recovery completed successfully
Thu Mar 10 13:36:39 2011
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 3 seq# 10 mem# 0: D:\ORACLE\ORADATA\GLIS\REDO03.LOG
Successful open of redo thread 1.
Thu Mar 10 13:36:39 2011
SMON: enabling cache recovery
Thu Mar 10 13:36:39 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 13:36:39 2011
SMON: enabling tx recovery
Thu Mar 10 13:36:39 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file d:\oracle\admin\glis\bdump\alert_glis.log
Thu Mar 10 14:53:26 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Thu Mar 10 14:53:26 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\glis\CONTROL01.CTL, D:\oracle\oradata\glis\CONTROL02.CTL, D:\oracle\oradata\glis\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = glis
dispatchers = (PROTOCOL=TCP) (SERVICE=glisXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\glis\bdump
user_dump_dest = D:\oracle\admin\glis\udump
core_dump_dest = D:\oracle\admin\glis\cdump
sort_area_size = 524288
db_name = glis
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
DBW2 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
CJQ0 started with pid=10
QMN0 started with pid=11
Thu Mar 10 14:53:29 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 14:53:30 2011
alter database mount exclusive
Thu Mar 10 14:53:36 2011
Successful mount of redo thread 1, with mount id 1007216044.
Thu Mar 10 14:53:36 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Mar 10 14:53:36 2011
alter database open
Thu Mar 10 14:53:37 2011
Beginning crash recovery of 1 threads
Thu Mar 10 14:53:37 2011
Started first pass scan
Thu Mar 10 14:53:37 2011
Completed first pass scan
5265 redo blocks read, 181 data blocks need recovery
Thu Mar 10 14:53:37 2011
Started recovery at
Thread 1: logseq 10, block 5866, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 10 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\GLIS\REDO03.LOG
Thu Mar 10 14:53:37 2011
Ended recovery at
Thread 1: logseq 10, block 11131, scn 0.1656666
181 data blocks read, 181 data blocks written, 5265 redo blocks read
Crash recovery completed successfully
Thu Mar 10 14:53:37 2011
Thread 1 advanced to log sequence 11
Thread 1 opened at log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\ORADATA\GLIS\REDO01.LOG
Successful open of redo thread 1.
Thu Mar 10 14:53:37 2011
SMON: enabling cache recovery
Thu Mar 10 14:53:37 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 14:53:37 2011
SMON: enabling tx recovery
Thu Mar 10 14:53:37 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Dump file d:\oracle\admin\glis\bdump\alert_glis.log
Thu Mar 10 16:00:08 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Thu Mar 10 16:00:08 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\glis\CONTROL01.CTL, D:\oracle\oradata\glis\CONTROL02.CTL, D:\oracle\oradata\glis\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = glis
dispatchers = (PROTOCOL=TCP) (SERVICE=glisXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\glis\bdump
user_dump_dest = D:\oracle\admin\glis\udump
core_dump_dest = D:\oracle\admin\glis\cdump
sort_area_size = 524288
db_name = glis
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
DBW2 started with pid=5
LGWR started with pid=6
CKPT started with pid=7
SMON started with pid=8
RECO started with pid=9
CJQ0 started with pid=10
QMN0 started with pid=11
Thu Mar 10 16:00:11 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Mar 10 16:00:12 2011
alter database mount exclusive
Thu Mar 10 16:00:18 2011
Successful mount of redo thread 1, with mount id 1007201614.
Thu Mar 10 16:00:18 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Mar 10 16:00:18 2011
alter database open
Thu Mar 10 16:00:19 2011
Beginning crash recovery of 1 threads
Thu Mar 10 16:00:19 2011
Started first pass scan
Thu Mar 10 16:00:19 2011
Completed first pass scan
4149 redo blocks read, 123 data blocks need recovery
Thu Mar 10 16:00:19 2011
Started recovery at
Thread 1: logseq 11, block 4006, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 11 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\GLIS\REDO01.LOG
Thu Mar 10 16:00:19 2011
Ended recovery at
Thread 1: logseq 11, block 8155, scn 0.1690428
123 data blocks read, 123 data blocks written, 4149 redo blocks read
Crash recovery completed successfully
Thu Mar 10 16:00:19 2011
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 2 seq# 12 mem# 0: D:\ORACLE\ORADATA\GLIS\REDO02.LOG
Successful open of redo thread 1.
Thu Mar 10 16:00:19 2011
SMON: enabling cache recovery
Thu Mar 10 16:00:19 2011
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Mar 10 16:00:19 2011
SMON: enabling tx recovery
Thu Mar 10 16:00:19 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open