Shutting down instance (abort)
License high water mark = 12
Instance terminated by USER, pid = 5688
Sun Mar 27 11:24:26 2011
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Sun Mar 27 11:24:26 2011
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
resource_limit = TRUE
__shared_pool_size = 96468992
shared_pool_size = 96468992
__large_pool_size = 16777216
large_pool_size = 16777216
__java_pool_size = 4194304
java_pool_size = 4194304
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 167772160
control_files = G:ORACLEPRODUCT10.2.0ORADATATESTCONTROL01.CTL, G:ORACLEPRODUCT10.2.0ORADATATESTCONTROL02.CTL, G:ORACLEPRODUCT10.2.0ORADATATESTCONTROL03.CTL
db_block_size = 8192
__db_cache_size = 41943040
db_cache_size = 41943040
db_writer_processes = 4
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = g:oracleproduct10.2.0flash_recovery_area
db_recovery_file_dest_size= 107374182400
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers =
shared_servers = 0
job_queue_processes = 10
audit_file_dest = G:ORACLEPRODUCT10.2.0ADMINTESTADUMP
background_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTBDUMP
user_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTUDUMP
core_dump_dest = G:ORACLEPRODUCT10.2.0ADMINTESTCDUMP
audit_trail = DB_EXTENDED
db_name = test
open_cursors = 300
pga_aggregate_target = 41943040
statistics_level = ALL
PMON started with pid=2, OS id=5148
PSP0 started with pid=3, OS id=6084
MMAN started with pid=4, OS id=4632
DBW0 started with pid=5, OS id=5096
DBW1 started with pid=6, OS id=4708
DBW2 started with pid=7, OS id=4684
DBW3 started with pid=8, OS id=5264
LGWR started with pid=9, OS id=5276
CKPT started with pid=10, OS id=832
SMON started with pid=11, OS id=5316
RECO started with pid=12, OS id=4232
CJQ0 started with pid=13, OS id=5224
MMON started with pid=14, OS id=5604
MMNL started with pid=15, OS id=5432
Sun Mar 27 11:24:27 2011
ALTER DATABASE MOUNT
Sun Mar 27 11:24:31 2011
Setting recovery target incarnation to 1
Sun Mar 27 11:24:31 2011
Successful mount of redo thread 1, with mount id 2045045995
Sun Mar 27 11:24:31 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Mar 27 11:24:31 2011
ALTER DATABASE OPEN
Sun Mar 27 11:24:31 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Sun Mar 27 11:24:32 2011
Started redo scan
Sun Mar 27 11:24:32 2011
Completed redo scan
77056 redo blocks read, 2959 data blocks need recovery
Sun Mar 27 11:24:33 2011
Started redo application at
Thread 1: logseq 59, block 656
Sun Mar 27 11:24:33 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 59 Reading mem 0
Mem# 0 errs 0: G:ORACLEPRODUCT10.2.0ORADATATESTREDO02.LOG
Sun Mar 27 11:24:35 2011
Buffer cache too small: 126 buffers remain in apply pass 2
Sun Mar 27 11:24:36 2011
Completed redo application
Sun Mar 27 11:24:36 2011
Completed crash recovery at
Thread 1: logseq 59, block 77712, scn 2160523
2959 data blocks read, 2959 data blocks written, 77056 redo blocks read
Sun Mar 27 11:24:37 2011
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=24, OS id=2124
Sun Mar 27 11:24:37 2011
ARC0: Archival started
ARC1 started with pid=25, OS id=872
Sun Mar 27 11:24:37 2011
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 60
Thread 1 opened at log sequence 60
Current log# 3 seq# 60 mem# 0: G:ORACLEPRODUCT10.2.0ORADATATESTREDO03.LOG
Successful open of redo thread 1
Sun Mar 27 11:24:37 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Mar 27 11:24:37 2011
ARC0: STARTING ARCH PROCESSES
Sun Mar 27 11:24:37 2011
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Sun Mar 27 11:24:37 2011
SMON: enabling cache recovery
Sun Mar 27 11:24:37 2011
ARC2: Archival started
Sun Mar 27 11:24:37 2011
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Sun Mar 27 11:24:38 2011
db_recovery_file_dest_size of 102400 MB is 0.19% 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.
ARC2 started with pid=26, OS id=5788
Sun Mar 27 11:24:40 2011
Successfully onlined Undo Tablespace 1.
Sun Mar 27 11:24:40 2011
SMON: enabling tx recovery
Sun Mar 27 11:24:40 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=36, OS id=4668
Sun Mar 27 11:24:48 2011
SMON: Parallel transaction recovery tried
Sun Mar 27 11:24:50 2011
Completed: ALTER DATABASE OPEN
Sun Mar 27 11:30:29 2011
--======================================
另外042的题库里有一个题目说的也是实例恢复的过程，其中答案D说的也是db open之后再rollback掉那些Uncommitted changes，不知道这个答案是不是有问题也无从考证。
2. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware
failure, the instance has shut down before synchronizing all the database files.
Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and uncommitted data.
Answer: AD
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1047824/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1047824/
扫一扫
135
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
