oracle 每天自动重启服务

[haofly1987]

Tue May 17 00:44:18 2011
Thread 1 advanced to log sequence 6614
Current log# 1 seq# 6614 mem# 0: D:\ORACLE\ORADATA\ming\REDO01.LOG
Tue May 17 00:54:56 2011
Thread 1 advanced to log sequence 6615
Current log# 2 seq# 6615 mem# 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Tue May 17 01:05:20 2011
Thread 1 advanced to log sequence 6616
Current log# 3 seq# 6616 mem# 0: D:\ORACLE\ORADATA\ming\REDO03.LOG
Tue May 17 01:15:14 2011
Thread 1 advanced to log sequence 6617
Current log# 1 seq# 6617 mem# 0: D:\ORACLE\ORADATA\ming\REDO01.LOG
Tue May 17 01:25:28 2011
Thread 1 advanced to log sequence 6618
Current log# 2 seq# 6618 mem# 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Dump file d:\oracle\admin\ming\bdump\alert_ming.log
Tue May 17 06:03:02 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
Tue May 17 06:03:02 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\ming\CONTROL01.CTL, D:\oracle\oradata\ming\CONTROL02.CTL, D:\oracle\oradata\ming\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 = ming
dispatchers = (PROTOCOL=TCP) (SERVICE=mingXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ming\bdump
user_dump_dest = D:\oracle\admin\ming\udump
core_dump_dest = D:\oracle\admin\ming\cdump
sort_area_size = 524288
db_name = ming
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
Tue May 17 06:03:06 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue May 17 06:03:07 2011
alter database mount exclusive
Tue May 17 06:03:12 2011
Successful mount of redo thread 1, with mount id 522585051.
Tue May 17 06:03:12 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue May 17 06:03:12 2011
alter database open
Tue May 17 06:03:12 2011
Beginning crash recovery of 1 threads
Tue May 17 06:03:12 2011
Started first pass scan
Tue May 17 06:03:12 2011
Completed first pass scan
3494 redo blocks read, 65 data blocks need recovery
Tue May 17 06:03:12 2011
Started recovery at
Thread 1: logseq 6618, block 134912, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6618 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Tue May 17 06:03:12 2011
Ended recovery at
Thread 1: logseq 6618, block 138406, scn 0.635125029
65 data blocks read, 65 data blocks written, 3494 redo blocks read
Crash recovery completed successfully
Tue May 17 06:03:13 2011
Thread 1 advanced to log sequence 6619
Thread 1 opened at log sequence 6619
Current log# 3 seq# 6619 mem# 0: D:\ORACLE\ORADATA\ming\REDO03.LOG
Successful open of redo thread 1.
Tue May 17 06:03:13 2011
SMON: enabling cache recovery
Tue May 17 06:03:14 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.
Tue May 17 06:03:14 2011
SMON: enabling tx recovery
Tue May 17 06:03:14 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed May 18 00:44:52 2011
Thread 1 advanced to log sequence 6620
Current log# 1 seq# 6620 mem# 0: D:\ORACLE\ORADATA\ming\REDO01.LOG
Wed May 18 00:55:13 2011
Thread 1 advanced to log sequence 6621
Current log# 2 seq# 6621 mem# 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Wed May 18 01:05:25 2011
Thread 1 advanced to log sequence 6622
Current log# 3 seq# 6622 mem# 0: D:\ORACLE\ORADATA\ming\REDO03.LOG
Wed May 18 01:15:18 2011
Thread 1 advanced to log sequence 6623
Current log# 1 seq# 6623 mem# 0: D:\ORACLE\ORADATA\ming\REDO01.LOG
Wed May 18 01:25:24 2011
Thread 1 advanced to log sequence 6624
Current log# 2 seq# 6624 mem# 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Dump file d:\oracle\admin\ming\bdump\alert_ming.log
Wed May 18 06:02:57 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
Wed May 18 06:02:57 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\ming\CONTROL01.CTL, D:\oracle\oradata\ming\CONTROL02.CTL, D:\oracle\oradata\ming\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 = ming
dispatchers = (PROTOCOL=TCP) (SERVICE=mingXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\ming\bdump
user_dump_dest = D:\oracle\admin\ming\udump
core_dump_dest = D:\oracle\admin\ming\cdump
sort_area_size = 524288
db_name = ming
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
Wed May 18 06:03:01 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed May 18 06:03:02 2011
alter database mount exclusive
Wed May 18 06:03:07 2011
Successful mount of redo thread 1, with mount id 522711382.
Wed May 18 06:03:07 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed May 18 06:03:07 2011
alter database open
Wed May 18 06:03:07 2011
Beginning crash recovery of 1 threads
Wed May 18 06:03:07 2011
Started first pass scan
Wed May 18 06:03:07 2011
Completed first pass scan
3519 redo blocks read, 70 data blocks need recovery
Wed May 18 06:03:07 2011
Started recovery at
Thread 1: logseq 6624, block 154791, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6624 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Wed May 18 06:03:07 2011
Ended recovery at
Thread 1: logseq 6624, block 158310, scn 0.636276114
70 data blocks read, 70 data blocks written, 3519 redo blocks read
Crash recovery completed successfully
Wed May 18 06:03:08 2011
Thread 1 advanced to log sequence 6625
Thread 1 opened at log sequence 6625
Current log# 3 seq# 6625 mem# 0: D:\ORACLE\ORADATA\ming\REDO03.LOG
Successful open of redo thread 1.
Wed May 18 06:03:08 2011
SMON: enabling cache recovery
Wed May 18 06:03:09 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.
Wed May 18 06:03:09 2011
SMON: enabling tx recovery
Wed May 18 06:03:09 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open


不知道为什么oracle每天自动重启服务。。。。这是alert日志文件。。大牛们看看

[oM落叶Mo]

Started recovery at
Thread 1: logseq 6624, block 154791, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6624 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ming\REDO02.LOG
Wed May 18 06:03:07 2011
Ended recovery at
Thread 1: logseq 6624, block 158310, scn 0.636276114
70 data blocks read, 70 data blocks written, 3519 redo blocks read
Crash recovery completed successfully
看到这一段，说明你的oracle是被异常关闭，因此在oracle启动的时候，自动做instance recovery,怀疑是你的系统自动关机

[秋雨飘落]

操作系统每天重启。。。
数据库当然重启了。。。

[tangren]

17日
Tue May 17 01:25:28 2011 异常中断
.....................
Tue May 17 06:03:02 2011 数据库重启
Starting ORACLE instance (normal)

18日
Wed May 18 01:25:24 2011 异常中断
...................
Wed May 18 06:02:57 2011 数据库重启
Starting ORACLE instance (normal)

上述日志说明每晚1:25数据库被强行DOWN掉，每天早晨6:03左右启动。
据此推断，你的操作系统上有自动开关机的任务。

如果是产品环境，这样比较危险，可能造成数据库损坏，
如果要关机，先执行行shutdown immediate，让数据库在一致状态下关闭。
然后再关机。

[njlywy]

查看下是不是有定时job、计划任务之类的…