实例恢复是需要经过buffer cache的！

最新推荐文章于 2021-04-10 17:45:12 发布

clt3617

最新推荐文章于 2021-04-10 17:45:12 发布

阅读量194

点赞数

文章标签：数据库

实例恢复是否需要经过buffer cache一直是我心中的疑问，oracle doc上提到了cache recovery，我一直认为应该是经过cache的，但是不好验证，今天无意中发现alert记录了这一信息：

Buffer cache too small: 126 buffers remain in apply pass 2

[@more@]

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
ALTER SYSTEM SET log_buffer=7028737 SCOPE=SPFILE;
Sun Mar 27 11:30:37 2011
Shutting down archive processes
Sun Mar 27 11:30:42 2011
ARCH shutting down
ARC2: Archival stopped

--=====================================

Shutting down instance (abort)
License high water mark = 15
Instance terminated by USER, pid = 1828
Mon Jun 13 16:50:37 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 =24
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 = 200
sessions = 225
__shared_pool_size = 71303168
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 167772160
control_files = G:ORADATATESTCONTROL01.CTL, G:ORADATATESTCONTROL02.CTL, G:ORADATATESTCONTROL03.CTL
db_block_size = 8192
__db_cache_size = 79691776
db_cache_size = 20971520
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= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
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
db_name = test
open_cursors = 300
pga_aggregate_target = 41943040
PMON started with pid=2, OS id=5408
PSP0 started with pid=3, OS id=5780
MMAN started with pid=4, OS id=1908
DBW0 started with pid=5, OS id=4528
LGWR started with pid=6, OS id=784
CKPT started with pid=7, OS id=5960
SMON started with pid=8, OS id=5696
RECO started with pid=9, OS id=2292
CJQ0 started with pid=10, OS id=5324
MMON started with pid=11, OS id=4280
MMNL started with pid=12, OS id=5736
Mon Jun 13 16:50:37 2011
ALTER DATABASE MOUNT
Mon Jun 13 16:50:41 2011
Setting recovery target incarnation to 1
Mon Jun 13 16:50:41 2011
Successful mount of redo thread 1, with mount id 2051816925
Mon Jun 13 16:50:41 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Jun 13 16:50:41 2011
ALTER DATABASE OPEN
Mon Jun 13 16:50:42 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Mon Jun 13 16:50:42 2011
Started redo scan
Mon Jun 13 16:50:43 2011
Completed redo scan
148006 redo blocks read, 4677 data blocks need recovery
Mon Jun 13 16:50:44 2011
Started redo application at
Thread 1: logseq 13, block 28359
Mon Jun 13 16:50:44 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 13 Reading mem 0
Mem# 0 errs 0: G:ORADATATESTREDO01.LOG
Mon Jun 13 16:50:45 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14 Reading mem 0
Mem# 0 errs 0: G:ORADATATESTREDO02.LOG
Mon Jun 13 16:50:47 2011
Buffer cache too small: 71 buffers remain in apply pass 2
Mon Jun 13 16:50:49 2011
Completed redo application
Mon Jun 13 16:50:49 2011
Completed crash recovery at
Thread 1: logseq 14, block 83964, scn 264909
4677 data blocks read, 4677 data blocks written, 148006 redo blocks read
Mon Jun 13 16:50:50 2011
Thread 1 advanced to log sequence 15
Thread 1 opened at log sequence 15
Current log# 3 seq# 15 mem# 0: G:ORADATATESTREDO03.LOG
Successful open of redo thread 1
Mon Jun 13 16:50:50 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 13 16:50:50 2011
SMON: enabling cache recovery
Mon Jun 13 16:50:50 2011
Successfully onlined Undo Tablespace 1.
Mon Jun 13 16:50:50 2011
SMON: enabling tx recovery
Mon Jun 13 16:50:50 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=30, OS id=4588
Mon Jun 13 16:50:59 2011
Completed: ALTER DATABASE OPEN
Mon Jun 13 16:51:00 2011
SMON: Parallel transaction recovery tried
Mon Jun 13 16:51:01 2011
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.