1 1 3820 pmon timer duration 300 0000012C 0 00 0 00 0 11374 WAITING
2 2 4868 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 3 WAITING
3 3 43691 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING
4 6 11 rdbms ipc message timeout 180000 0002BF20 0 00 0 00 0 11311 WAITING
5 7 2280 rdbms ipc message timeout 500 000001F4 0 00 0 00 0 11361 WAITING
6 4 9655 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 3 WAITING
7 5 905 smon timer sleep time 300 0000012C failed 0 00 0 00 0 1236 WAITING
8 15 2997 pipe get handle address 1275533420 4C07186C buffer length 4096 00001000 timeout 100 00000064 0 135 WAITING
9 9 1445 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 11361 WAITING
10 32 2477 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 140 WAITING
11 31 73 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 8602 WAITING
12 30 1078 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 8619 WAITING
13 29 38 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 2 0 WAITED KNOWN TIME
14 27 69 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 0 WAITING
15 26 23031 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 147 WAITING
16 25 23846 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 132 WAITING
17 24 247 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 5675 WAITING
18 23 6593 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 8554 WAITING
19 39 469 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 2750 WAITING
20 37 912 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 61 WAITING
21 36 1048 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 3454 WAITING
22 35 5952 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 3513 WAITING
23 33 15784 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 4848 WAITING
24 10 1563 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 6379 WAITING
25 14 19139 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 3 WAITING
26 20 5360 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 264 WAITING
27 22 20958 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 22 WAITING
28 21 169 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 10843 WAITING
29 13 4421 SQL*Net message from client driver id 1413697536 54435000 #bytes 1 00000001 0 00 0 1047 WAITING
30 8 940 wakeup time manager 0 00 0 00 0 00 0 20 WAITING
до этого корявого востановления из холодного бакапа полгода база работала без перерыва, такого не было
вот в 13.05 я базу запустил в 16.31 все пользоваетили намертво повисли, лог за этот период
/* OracleOEM */ ALTER DATABASE MOUNT
Wed Dec 05 12:59:37 2007
Successful mount of redo thread 1, with mount id 927807733
Wed Dec 05 12:59:37 2007
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Wed Dec 05 13:05:32 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:11:35 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:17:38 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:23:41 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:29:44 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:35:47 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:41:47 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 13:44:06 2007
/* OracleOEM */ ALTER DATABASE OPEN
Wed Dec 05 13:44:06 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 17
Current log# 2 seq# 17 mem# 0: F:\BASE_OOO\REDO02.LOG
Successful open of redo thread 1
Wed Dec 05 13:44:07 2007
SMON: enabling cache recovery
Wed Dec 05 13:44:07 2007
Successfully onlined Undo Tablespace 1.
Wed Dec 05 13:44:07 2007
SMON: enabling tx recovery
Wed Dec 05 13:44:07 2007
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Wed Dec 05 15:26:44 2007
Thread 1 cannot allocate new log, sequence 18
All online logs needed archiving
Current log# 2 seq# 17 mem# 0: F:\BASE_OOO\REDO02.LOG
Wed Dec 05 15:31:15 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 19
Dump file c:\base_ooo\bdump\alert_ooo.log
Wed Dec 05 15:34:55 2007
ORACLE V9.2.0.7.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Wed Dec 05 15:34:55 2007
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.7.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 218103808
large_pool_size = 0
java_pool_size = 58720256
spfile = c:\base_OOO\spfileOOO.ora
control_files = c:\base_OOO\CONTROL01.CTL, e:\base_OOO\CONTROL02.CTL, f:\base_OOO\CONTROL03.CTL, g:\base_OOO\CONTROL04.CTL
db_block_size = 8192
db_cache_size = 452984832
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 10
cluster_database = FALSE
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = OOO
dispatchers = (PROTOCOL=TCP) (SERVICE=OOOXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
hash_area_size = 1048576
background_dump_dest = c:\base_OOO\bdump
user_dump_dest = c:\base_OOO\udump
core_dump_dest = c:\base_OOO\cdump
sort_area_size = 1048576
db_name = OOO
open_cursors = 300
star_transformation_enabled= TRUE
optimizer_index_cost_adj = 50
optimizer_index_caching = 90
query_rewrite_enabled = TRUE
pga_aggregate_target = 33554432
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=4
LGWR started with pid=3
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 Dec 05 15:34:59 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Dec 05 15:35:00 2007
alter database mount exclusive
Wed Dec 05 15:35:04 2007
Successful mount of redo thread 1, with mount id 927842148
Wed Dec 05 15:35:04 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Dec 05 15:35:04 2007
alter database open
Wed Dec 05 15:35:04 2007
Beginning crash recovery of 1 threads
Wed Dec 05 15:35:04 2007
Started redo scan
Wed Dec 05 15:35:04 2007
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Wed Dec 05 15:35:04 2007
Started recovery at
Thread 1: logseq 17, block 204799, scn 0.520199490
Wed Dec 05 15:35:04 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0
Mem# 0 errs 0: F:\BASE_OOO\REDO02.LOG
Wed Dec 05 15:35:04 2007
Completed redo application
Wed Dec 05 15:35:04 2007
Ended recovery at
Thread 1: logseq 17, block 204799, scn 0.520219491
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Wed Dec 05 15:35:04 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Wed Dec 05 15:35:04 2007
ARCH: Evaluating archive log 3 thread 1 sequence 15
ARCH: Beginning to archive log 3 thread 1 sequence 15
Creating archive destination LOG_ARCHIVE_DEST_1: 'C:\ORACLE\ORA92\RDBMS\ARC00015.001'
ARCH: Completed archiving log 3 thread 1 sequence 15
Wed Dec 05 15:35:13 2007
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 18
Thread 1 opened at log sequence 18
Current log# 3 seq# 18 mem# 0: C:\BASE_OOO\REDO03.LOG
Successful open of redo thread 1
Wed Dec 05 15:35:13 2007
SMON: enabling cache recovery
Wed Dec 05 15:35:14 2007
Successfully onlined Undo Tablespace 1.
Wed Dec 05 15:35:14 2007
SMON: enabling tx recovery
Wed Dec 05 15:35:14 2007
Database Characterset is CL8MSWIN1251
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed Dec 05 15:35:17 2007
SMON: Parallel transaction recovery tried