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
|
Tue Jun 3 14:51:27 2008
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 = 104857600
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 536870912
control_files = /opt/app/oracle/oracle/product/10.2.0/oradata/lpntest/control01.ctl, /opt/app/oracle/oracle/product/10.2.0/oradata/lpntest/control02.ctl, /opt/app/oracle/oracle/product/10.2.0/oradata/lpntest/control03.ctl
db_block_size = 8192
__db_cache_size = 411041792
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest =/opt/app/oracle/oracle/product/10.2.0/db_1/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=lpntestXDB)
local_listener = LISTENER_LPNTEST
job_queue_processes = 10
background_dump_dest = /opt/app/oracle/oracle/product/10.2.0/db_1/admin/lpntest/bdump
user_dump_dest = /opt/app/oracle/oracle/product/10.2.0/db_1/admin/lpntest/udump
core_dump_dest = /opt/app/oracle/oracle/product/10.2.0/db_1/admin/lpntest/cdump
audit_file_dest = /opt/app/oracle/oracle/product/10.2.0/db_1/admin/lpntest/adump
db_name = lpntest
open_cursors = 300
pga_aggregate_target = 308281344
PMON started with pid=2, OS id=2402
PSP0 started with pid=3, OS id=2404
MMAN started with pid=4, OS id=2406
DBW0 started with pid=5, OS id=2408
LGWR started with pid=6, OS id=2410
CKPT started with pid=7, OS id=2412
SMON started with pid=8, OS id=2414
RECO started with pid=9, OS id=2416
CJQ0 started with pid=10, OS id=2418
MMON started with pid=11, OS id=2420
Tue Jun 3 14:51:28 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2422
Tue Jun 3 14:51:28 2008
starting up 1 shared server(s) ...
Tue Jun 3 14:51:28 2008
ALTER DATABASE MOUNT
Tue Jun 3 14:51:32 2008
Setting recovery target incarnation to 2
Tue Jun 3 14:51:32 2008
Successful mount of redo thread 1, with mount id 3117295344
Tue Jun 3 14:51:32 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jun 3 14:51:32 2008
ALTER DATABASE OPEN
Tue Jun 3 14:51:33 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Jun 3 14:51:33 2008
Started redo scan
Tue Jun 3 14:51:33 2008
Completed redo scan
74 redo blocks read, 35 data blocks need recovery
Tue Jun 3 14:51:33 2008
Started redo application at
Thread 1: logseq 1074, block 2750
Tue Jun 3 14:51:33 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1074 Reading mem 0
Mem# 0 errs 0: /opt/app/oracle/oracle/product/10.2.0/oradata/lpntest/redo02.log
Tue Jun 3 14:51:33 2008
Completed redo application
Tue Jun 3 14:51:33 2008
Completed crash recovery at
Thread 1: logseq 1074, block 2824, scn 6082629
35 data blocks read, 35 data blocks written, 74 redo blocks read
Tue Jun 3 14:51:34 2008
Thread 1 advanced to log sequence 1075
Thread 1 opened at log sequence 1075
Current log# 3 seq# 1075 mem# 0: /opt/app/oracle/oracle/product/10.2.0/oradata/lpntest/redo03.log
Successful open of redo thread 1
Tue Jun 3 14:51:34 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jun 3 14:51:34 2008
SMON: enabling cache recovery
Tue Jun 3 14:51:35 2008
Successfully onlined Undo Tablespace 1.
Tue Jun 3 14:51:35 2008
SMON: enabling tx recovery
Tue Jun 3 14:51:35 2008
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=2434
Tue Jun 3 14:51:39 2008
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.
Tue Jun 3 14:51:40 2008
Completed: ALTER DATABASE OPEN |
Partager