1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252
| Dump file d:\oradata\CONSO\bdump\alert_CONSO.log
Tue Dec 04 02:38:37 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Tue Dec 04 02:38:37 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.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 260046848
large_pool_size = 150994944
java_pool_size = 25165824
control_files = D:\oradata\CONSO\CONTROL01.CTL, D:\oradata\CONSO\CONTROL02.CTL, D:\oradata\CONSO\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 780140544
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
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CONSO
dispatchers = (PROTOCOL=TCP) (SERVICE=CONSOXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oradata\CONSO\bdump
user_dump_dest = D:\oradata\CONSO\udump
core_dump_dest = D:\oradata\CONSO\cdump
sort_area_size = 524288
db_name = CONSO
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 258998272
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 Dec 04 02:38:40 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Dec 04 02:38:40 2007
alter database mount exclusive
Tue Dec 04 02:38:45 2007
Successful mount of redo thread 1, with mount id 969163761
Tue Dec 04 02:38:45 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 04 02:38:45 2007
alter database open
Tue Dec 04 02:38:45 2007
Thread 1 opened at log sequence 6910
Current log# 3 seq# 6910 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Successful open of redo thread 1
Tue Dec 04 02:38:45 2007
SMON: enabling cache recovery
Tue Dec 04 02:38:46 2007
Successfully onlined Undo Tablespace 1.
Tue Dec 04 02:38:46 2007
SMON: enabling tx recovery
Tue Dec 04 02:38:46 2007
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Dec 04 02:38:48 2007
Starting ORACLE instance (normal)
Tue Dec 04 02:39:47 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Dec 04 02:41:57 2007
Thread 1 advanced to log sequence 6911
Current log# 1 seq# 6911 mem# 0: E:\ORADATA\CONSO\REDO01.LOG
Tue Dec 04 04:53:57 2007
Thread 1 advanced to log sequence 6912
Current log# 2 seq# 6912 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Tue Dec 04 06:56:27 2007
Thread 1 advanced to log sequence 6913
Current log# 3 seq# 6913 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Tue Dec 04 09:03:28 2007
Thread 1 advanced to log sequence 6914
Current log# 1 seq# 6914 mem# 0: E:\ORADATA\CONSO\REDO01.LOG
Tue Dec 04 11:11:57 2007
Thread 1 advanced to log sequence 6915
Current log# 2 seq# 6915 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Tue Dec 04 13:22:58 2007
Thread 1 advanced to log sequence 6916
Current log# 3 seq# 6916 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Tue Dec 04 15:31:58 2007
Thread 1 advanced to log sequence 6917
Current log# 1 seq# 6917 mem# 0: E:\ORADATA\CONSO\REDO01.LOG
Tue Dec 04 17:39:28 2007
Thread 1 advanced to log sequence 6918
Current log# 2 seq# 6918 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Tue Dec 04 19:48:28 2007
Thread 1 advanced to log sequence 6919
Current log# 3 seq# 6919 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Tue Dec 04 21:55:28 2007
Thread 1 advanced to log sequence 6920
Current log# 1 seq# 6920 mem# 0: E:\ORADATA\CONSO\REDO01.LOG
Wed Dec 05 00:03:28 2007
Thread 1 advanced to log sequence 6921
Current log# 2 seq# 6921 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Wed Dec 05 00:32:02 2007
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Dec 05 00:32:07 2007
alter database close normal
Wed Dec 05 00:32:08 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Dec 05 00:32:08 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 6921
Successful close of redo thread 1
Wed Dec 05 00:32:11 2007
Completed: alter database close normal
Wed Dec 05 00:32:11 2007
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\oradata\CONSO\bdump\alert_CONSO.log
Wed Dec 05 00:59:29 2007
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Wed Dec 05 00:59:29 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.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 260046848
large_pool_size = 150994944
java_pool_size = 25165824
control_files = D:\oradata\CONSO\CONTROL01.CTL, D:\oradata\CONSO\CONTROL02.CTL, D:\oradata\CONSO\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 780140544
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
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CONSO
dispatchers = (PROTOCOL=TCP) (SERVICE=CONSOXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oradata\CONSO\bdump
user_dump_dest = D:\oradata\CONSO\udump
core_dump_dest = D:\oradata\CONSO\cdump
sort_area_size = 524288
db_name = CONSO
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 258998272
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 Dec 05 00:59:31 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Dec 05 00:59:32 2007
alter database mount exclusive
Wed Dec 05 00:59:38 2007
Successful mount of redo thread 1, with mount id 969273910
Wed Dec 05 00:59:38 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Dec 05 00:59:38 2007
alter database open
Wed Dec 05 00:59:39 2007
Thread 1 opened at log sequence 6921
Current log# 2 seq# 6921 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Successful open of redo thread 1
Wed Dec 05 00:59:39 2007
SMON: enabling cache recovery
Wed Dec 05 00:59:39 2007
Successfully onlined Undo Tablespace 1.
Wed Dec 05 00:59:39 2007
SMON: enabling tx recovery
Wed Dec 05 00:59:39 2007
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed Dec 05 01:00:39 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Dec 05 02:34:18 2007
Thread 1 advanced to log sequence 6922
Current log# 3 seq# 6922 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Wed Dec 05 03:09:46 2007
Starting ORACLE instance (normal)
Wed Dec 05 04:37:48 2007
Thread 1 advanced to log sequence 6923
Current log# 1 seq# 6923 mem# 0: E:\ORADATA\CONSO\REDO01.LOG
Wed Dec 05 06:40:47 2007
Thread 1 advanced to log sequence 6924
Current log# 2 seq# 6924 mem# 0: E:\ORADATA\CONSO\REDO02.LOG
Wed Dec 05 08:43:17 2007
Thread 1 advanced to log sequence 6925
Current log# 3 seq# 6925 mem# 0: E:\ORADATA\CONSO\REDO03.LOG
Wed Dec 05 08:53:35 2007
alter database backup controlfile to trace
Wed Dec 05 08:53:35 2007
Completed: alter database backup controlfile to trace
Wed Dec 05 10:32:17 2007
Thread 1 advanced to log sequence 6926
Current log# 1 seq# 6926 mem# 0: E:\ORADATA\CONSO\REDO01.LOG |
Partager