Mon May 12 23:06:00 BEIST 2014
Thread 1 advanced to log sequence 1034 (LGWR switch)
Current log# 2 seq# 1034 mem# 0: /oradata/orcl/redo02.log
Mon May 12 23:06:48 BEIST 2014
Starting control autobackup
Control autobackup written to DISK device
handle '/oradata/rmanbak/ctl_c-1320042450-20140512-00'
Tue May 13 11:21:44 BEIST 2014
Thread 1 advanced to log sequence 1035 (LGWR switch)
Current log# 3 seq# 1035 mem# 0: /oradata/orcl/redo03.log ----->注意此处,没有关库的痕迹。
Tue May 13 18:26:42 BEIST 2014
Detected change in CPU count to 6 ----->注意此处cpu_count变成6个
Tue May 13 18:26:42 BEIST 2014
RM cpu_count => Low Server Threshold (6) : High Server Threshold (8)----->注意此处:原本的cpu是8个
Tue May 13 19:53:06 BEIST 2014
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
IMODE=BR
ILAT =121
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.5.0.
System parameters with non-default values:
processes = 1000
sessions = 1105
sga_max_size = 6442450944
__shared_pool_size = 1140850688
__large_pool_size = 16777216
__java_pool_size = 33554432
__streams_pool_size = 0
sga_target = 6442450944
control_files = /oradata/orcl/control01.ctl, /oradata/orcl/control02.ctl, /oradata/orcl/control03.ctl
db_block_size = 8192
__db_cache_size = 5234491392
compatible = 10.2.0.5.0
log_archive_dest_1 = LOCATION=/oradata/arch
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/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=orclXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/orcl/bdump
user_dump_dest = /u01/app/oracle/admin/orcl/udump
core_dump_dest = /u01/app/oracle/admin/orcl/cdump
audit_file_dest = /u01/app/oracle/admin/orcl/adump
db_name = orcl
open_cursors = 300
pga_aggregate_target = 2147483648
MMAN started with pid=4, OS id=282922
PMON started with pid=2, OS id=159760
PSP0 started with pid=3, OS id=139482
DBW0 started with pid=5, OS id=233512
LGWR started with pid=6, OS id=131248
CKPT started with pid=7, OS id=233790
SMON started with pid=8, OS id=332064
RECO started with pid=9, OS id=204856
CJQ0 started with pid=10, OS id=340258
MMON started with pid=11, OS id=237598
Tue May 13 19:53:09 BEIST 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=258322
Tue May 13 19:53:09 BEIST 2014
starting up 1 shared server(s) ...
Tue May 13 19:53:11 BEIST 2014
ALTER DATABASE MOUNT
Tue May 13 19:53:16 BEIST 2014
Setting recovery target incarnation to 1
Tue May 13 19:53:16 BEIST 2014
Successful mount of redo thread 1, with mount id 1375240744
Tue May 13 19:53:16 BEIST 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue May 13 19:53:16 BEIST 2014
ALTER DATABASE OPEN
Tue May 13 19:53:16 BEIST 2014
Beginning crash recovery of 1 threads
parallel recovery started with 5 processes
Tue May 13 19:53:17 BEIST 2014
Started redo scan
Tue May 13 19:53:17 BEIST 2014
Completed redo scan
1290 redo blocks read, 345 data blocks need recovery
Tue May 13 19:53:17 BEIST 2014
Started redo application at
Thread 1: logseq 1035, block 450056
Tue May 13 19:53:17 BEIST 2014
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1035 Reading mem 0
Mem# 0: /oradata/orcl/redo03.log
Tue May 13 19:53:17 BEIST 2014
Completed redo application
Tue May 13 19:53:18 BEIST 2014
Completed crash recovery at
Thread 1: logseq 1035, block 451346, scn 133235449
345 data blocks read, 345 data blocks written, 1290 redo blocks read
Tue May 13 19:53:19 BEIST 2014
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=21, OS id=311420
Tue May 13 19:53:19 BEIST 2014
ARC0: Archival started
ARC1 started with pid=22, OS id=467326
Tue May 13 19:53:19 BEIST 2014
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Tue May 13 19:53:19 BEIST 2014
Thread 1 advanced to log sequence 1036 (thread open)
Thread 1 opened at log sequence 1036
Current log# 1 seq# 1036 mem# 0: /oradata/orcl/redo01.log
Successful open of redo thread 1
Tue May 13 19:53:19 BEIST 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 13 19:53:19 BEIST 2014
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue May 13 19:53:19 BEIST 2014
ARC0: Becoming the heartbeat ARCH
Tue May 13 19:53:19 BEIST 2014
SMON: enabling cache recovery
Tue May 13 19:53:23 BEIST 2014
Successfully onlined Undo Tablespace 1.
Tue May 13 19:53:23 BEIST 2014
SMON: enabling tx recovery
Tue May 13 19:53:23 BEIST 2014
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=319618
Tue May 13 19:53:28 BEIST 2014
Completed: ALTER DATABASE OPEN