[20170206]关于Data Guard Gap Detection and Resolution2.txt
--测试看看一些参数不设置是否可以解决gap问题.
1.环境:
SYS@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
--//节前花了一个上午安装一台dg,我一般安装dataguard,自己有一个标准的文档,dataguard实例名我一般选择主库实例名后面加dg
--//[注:如果长于8个字符,选择d1,d2.]
--//为了测试方便,使用文本参数文件,这样测试方便一些.
SYS@book> create pfile='/tmp/book.ora' from spfile ;
File created.
2.说明我一般修改如下参数:
--主库:
*.log_archive_config='DG_CONFIG=(book,bookdg)'
*.fal_client='book'
*.fal_server='bookdg'
*.standby_file_management='auto'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book'
*.log_archive_dest_2='SERVICE=bookdg LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bookdg'
*.db_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
*.log_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
*.db_unique_name='BOOK'
--备库:
*.log_archive_config='DG_CONFIG=(book,bookdg)'
*.fal_client='bookdg'
*.fal_server='book'
*.standby_file_management='auto'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bookdg'
*.log_archive_dest_2='SERVICE=book LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=book'
*.db_file_name_convert='mnt/ramdisk/book','/mnt/ramdisk/book'
*.log_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
*.db_unique_name='bookdg'
*.service_names='book'
--//注:备库我一般service_names设置跟主库一样.
3.测试前修改参数文件参数:
--主库:
#*.log_archive_config='DG_CONFIG=(book,bookdg)'
#*.fal_client='book'
#*.fal_server='bookdg'
*.standby_file_management='auto'
#*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book'
#*.log_archive_dest_2='SERVICE=bookdg LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bookdg'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
*.log_archive_dest_2='SERVICE=bookdg LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.db_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
*.log_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
#*.db_unique_name='BOOK'
--//注:取消fal_client,fal_server,log_archive_config,db_unique_name设置,并且log_archive_dest_N取消后面的DB_UNIQUE_NAME=XXX.
--备库:
#*.log_archive_config='DG_CONFIG=(book,bookdg)'
#*.fal_client='bookdg'
#*.fal_server='book'
*.standby_file_management='auto'
#*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bookdg'
#*.log_archive_dest_2='SERVICE=book LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=book'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
*.log_archive_dest_2='SERVICE=book LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.db_file_name_convert='mnt/ramdisk/book','/mnt/ramdisk/book'
*.log_file_name_convert='/mnt/ramdisk/book','/mnt/ramdisk/book'
#*.db_unique_name='bookdg'
*.service_names='book'
4.测试:
A.关闭2边数据库.使用对应文本参数文件启动看看.
B.先启动主库:
SYS@book> startup pfile='/tmp/book.ora'
ORACLE instance started.
Total System Global Area 634732544 bytes
Fixed Size 2255792 bytes
Variable Size 197133392 bytes
Database Buffers 427819008 bytes
Redo Buffers 7524352 bytes
Database mounted.
Database opened.
SYS@book>
SYS@book> show parameter unique
NAME TYPE VALUE
-------------- ------- ------
db_unique_name string book
--//不设置db_unique_name,缺省取ORACLE_SID.
SYS@book> alter system archive log current ;
System altered.
SYS@book> alter system archive log current ;
System altered.
SYS@book> alter system archive log current ;
System altered.
SYS@book> alter system archive log current ;
System altered.
SYS@book> alter system archive log current ;
System altered.
SYS@book> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/archivelog/book
Oldest online log sequence 286
Next log sequence to archive 288
Current log sequence 288
C.启动备库:
SYS@bookdg> startup nomount pfile='/tmp/bookdg.ora';
ORACLE instance started.
Total System Global Area 634732544 bytes
Fixed Size 2255792 bytes
Variable Size 197133392 bytes
Database Buffers 427819008 bytes
Redo Buffers 7524352 bytes
SYS@bookdg> alter database mount standby database;
Database altered.
SYS@bookdg> show parameter unique
NAME TYPE VALUE
-------------- ------ -------
db_unique_name string book
--//???可以发现不是我想像的那样.现在2边db_unique_name是一样的.
SYS@bookdg> @ &r/dg/dg
PROCESS PID STATUS GROUP# THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------- ------------ ------ ------- ---------- ---------- ---------- ----------
ARCH 23523 CONNECTED N/A 0 0 0 0 0
--//没有开始传输...
SYS@bookdg> alter database recover managed standby database using current logfile disconnect ;
Database altered.
--等一小会...
SYS@bookdg> @ &r/dg/dg
PROCESS PID STATUS GROUP# THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------- ------------ ------- ------- ---------- ---------- ---------- ----------
RFS 23537 IDLE N/A 0 0 0 0 0
RFS 23539 IDLE 3 1 289 38 1 0
ARCH 23523 CLOSING 4 1 288 1 324 0
MRP0 23525 APPLYING_LOG N/A 1 289 38 102400 0
--//可以发现已经传输并应用...
--//如果不传,我一般在/主库执行:
SYS@book> alter system set log_archive_dest_state_2=enable scope=memory;
System altered.
======
--//检查alert文件,注意这个时候alert文件不再是原来的现在指向:
/u01/app/oracle/diag/rdbms/book/bookdg/trace/alert_${ORACLE_SID}.log
--//而原来是:
/u01/app/oracle/diag/rdbms/bookdg/bookdg/trace/alert_${ORACLE_SID}.log
Mon Feb 06 11:06:25 2017
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (bookdg)
Mon Feb 06 11:06:25 2017
MRP0 started with pid=21, OS id=23525
MRP0: Background Managed Standby Recovery process started (bookdg)
started logmerger process
Mon Feb 06 11:06:31 2017
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Completed: alter database recover managed standby database using current logfile disconnect
Recovery of Online Redo Log: Thread 1 Group 4 Seq 282 Reading mem 0
Mem# 0: /mnt/ramdisk/book/redostb01.log
Mon Feb 06 11:08:19 2017 <==等了2,3分钟,要快一点可以在主库执行alter system set log_archive_dest_state_2=enable scope=memory;
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/archivelog/book
RFS[1]: Assigned to RFS process 23537
RFS[1]: Selected log 4 for thread 1 sequence 282 dbid 1337401710 branch 896605872
Mon Feb 06 11:08:19 2017
Archived Log entry 117 added for thread 1 sequence 282 ID 0x4fb7d86e dest 1:
RFS[1]: Opened log for thread 1 sequence 283 dbid 1337401710 branch 896605872
Mon Feb 06 11:08:19 2017
Media Recovery Waiting for thread 1 sequence 283 (in transit)
Archived Log entry 118 added for thread 1 sequence 283 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[1]: Opened log for thread 1 sequence 284 dbid 1337401710 branch 896605872
Archived Log entry 119 added for thread 1 sequence 284 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[1]: Opened log for thread 1 sequence 285 dbid 1337401710 branch 896605872
Archived Log entry 120 added for thread 1 sequence 285 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[1]: Opened log for thread 1 sequence 286 dbid 1337401710 branch 896605872
Archived Log entry 121 added for thread 1 sequence 286 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[1]: Opened log for thread 1 sequence 287 dbid 1337401710 branch 896605872
Archived Log entry 122 added for thread 1 sequence 287 rlc 896605872 ID 0x4fb7d86e dest 2:
Media Recovery Log /u01/app/oracle/archivelog/book/1_283_896605872.dbf
Media Recovery Log /u01/app/oracle/archivelog/book/1_284_896605872.dbf
Media Recovery Log /u01/app/oracle/archivelog/book/1_285_896605872.dbf
RFS[1]: Selected log 4 for thread 1 sequence 288 dbid 1337401710 branch 896605872
Media Recovery Log /u01/app/oracle/archivelog/book/1_286_896605872.dbf
Archived Log entry 123 added for thread 1 sequence 288 ID 0x4fb7d86e dest 1:
Media Recovery Log /u01/app/oracle/archivelog/book/1_287_896605872.dbf
Mon Feb 06 11:08:22 2017
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Assigned to RFS process 23539
RFS[2]: Selected log 4 for thread 1 sequence 289 dbid 1337401710 branch 896605872
Media Recovery Log /u01/app/oracle/archivelog/book/1_288_896605872.dbf
Media Recovery Waiting for thread 1 sequence 289 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 289 Reading mem 0
Mem# 0: /mnt/ramdisk/book/redostb01.log
--//从测试可以看出不设置fal_client,fal_server,log_archive_config,db_unique_name.
SYS@bookdg> @ &r/dg/dg_mess
FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP MESSAGE
------------------------ ------------- ---------- ----------- ---------- --- ------------------- --------------------------------------------------------------------------------
Log Transport Services Informational 0 1 0 NO 2017-02-06 11:04:09 ARC0: Archival started
Log Transport Services Informational 0 2 0 NO 2017-02-06 11:04:09 ARC0: Becoming the 'no FAL' ARCH
Log Transport Services Informational 0 3 0 NO 2017-02-06 11:04:09 ARC0: Becoming the 'no SRL' ARCH
Log Transport Services Informational 0 4 0 NO 2017-02-06 11:04:09 ARC0: Becoming the heartbeat ARCH
Log Transport Services Informational 0 5 0 NO 2017-02-06 11:04:09 ARC0: Becoming the active heartbeat ARCH
Log Apply Services Control 0 6 0 YES 2017-02-06 11:06:25 Attempt to start background Managed Standby Recovery process
Log Apply Services Control 0 7 0 YES 2017-02-06 11:06:25 MRP0: Background Managed Standby Recovery process started
Log Apply Services Informational 0 8 0 NO 2017-02-06 11:06:31 Managed Standby Recovery starting Real Time Apply
Remote File Server Informational 0 9 0 NO 2017-02-06 11:08:19 RFS[1]: Assigned to RFS process 23537
Log Transport Services Control 0 10 0 YES 2017-02-06 11:08:19 ARC0: Beginning to archive thread 1 sequence 282 (13275727666-13275728924)
Log Transport Services Control 0 11 0 YES 2017-02-06 11:08:19 ARC0: Completed archiving thread 1 sequence 282 (0-0)
Log Apply Services Warning 0 12 0 NO 2017-02-06 11:08:19 Media Recovery Waiting for thread 1 sequence 283 (in transit)
Log Apply Services Informational 0 13 0 NO 2017-02-06 11:08:20 Media Recovery Log /u01/app/oracle/archivelog/book/1_283_896605872.dbf
Log Apply Services Informational 0 14 0 NO 2017-02-06 11:08:21 Media Recovery Log /u01/app/oracle/archivelog/book/1_284_896605872.dbf
Log Apply Services Informational 0 15 0 NO 2017-02-06 11:08:21 Media Recovery Log /u01/app/oracle/archivelog/book/1_285_896605872.dbf
Log Apply Services Informational 0 16 0 NO 2017-02-06 11:08:22 Media Recovery Log /u01/app/oracle/archivelog/book/1_286_896605872.dbf
Log Transport Services Control 0 17 0 YES 2017-02-06 11:08:22 ARC0: Beginning to archive thread 1 sequence 288 (13275728951-13275729283)
Log Transport Services Control 0 18 0 YES 2017-02-06 11:08:22 ARC0: Completed archiving thread 1 sequence 288 (0-0)
Log Apply Services Informational 0 19 0 NO 2017-02-06 11:08:22 Media Recovery Log /u01/app/oracle/archivelog/book/1_287_896605872.dbf
Remote File Server Informational 0 20 0 NO 2017-02-06 11:08:22 Primary database is in MAXIMUM PERFORMANCE mode
Remote File Server Informational 0 21 0 NO 2017-02-06 11:08:22 RFS[2]: Assigned to RFS process 23539
Log Apply Services Informational 0 22 0 NO 2017-02-06 11:08:22 Media Recovery Log /u01/app/oracle/archivelog/book/1_288_896605872.dbf
Log Apply Services Warning 0 23 0 NO 2017-02-06 11:08:23 Media Recovery Waiting for thread 1 sequence 289 (in transit)
23 rows selected.
--总结:
--通过测试说明不设置fal_client,fal_server,log_archive_config,db_unique_name.也可以解决archivelog gap问题.虽然我个人不喜欢这种设置,尤其是db_unique_name一样.
--补充采用fal参数,alert文件的记录:
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from book to bookdg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=> db_unique_name被修改回来了.
ARCH: STARTING ARCH PROCESSES
Mon Feb 06 11:28:48 2017
ARC0 started with pid=20, OS id=23826
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Becoming the heartbeat ARCH
ARC0: Thread not mounted
Mon Feb 06 11:28:49 2017
Successful mount of redo thread 1, with mount id 1376041259
Physical Standby Database mounted.
Lost write protection disabled
ARC0: Becoming the active heartbeat ARCH
Completed: alter database mount standby database
Mon Feb 06 11:29:18 2017
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (bookdg)
Mon Feb 06 11:29:19 2017
MRP0 started with pid=21, OS id=23828
MRP0: Background Managed Standby Recovery process started (bookdg)
started logmerger process
Mon Feb 06 11:29:25 2017
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Completed: alter database recover managed standby database using current logfile disconnect
Recovery of Online Redo Log: Thread 1 Group 4 Seq 289 Reading mem 0
Mem# 0: /mnt/ramdisk/book/redostb01.log
......等一会,或者在主库alter system set log_archive_dest_state_2=enable scope=memory;
Mon Feb 06 11:34:47 2017
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/archivelog/book
Mon Feb 06 11:34:48 2017
RFS[1]: Assigned to RFS process 23900
RFS[1]: Selected log 4 for thread 1 sequence 289 dbid 1337401710 branch 896605872
RFS[1]: Opened log for thread 1 sequence 290 dbid 1337401710 branch 896605872
Mon Feb 06 11:34:48 2017
Archived Log entry 124 added for thread 1 sequence 289 ID 0x4fb7d86e dest 1:
Archived Log entry 125 added for thread 1 sequence 290 rlc 896605872 ID 0x4fb7d86e dest 2:
Mon Feb 06 11:34:48 2017
Media Recovery Log /u01/app/oracle/archivelog/book/1_290_896605872.dbf
Media Recovery Waiting for thread 1 sequence 291
Fetching gap sequence in thread 1, gap sequence 291-291
Mon Feb 06 11:34:49 2017
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Assigned to RFS process 23902
RFS[2]: Selected log 4 for thread 1 sequence 299 dbid 1337401710 branch 896605872
Mon Feb 06 11:34:50 2017
RFS[3]: Assigned to RFS process 23904
RFS[3]: Opened log for thread 1 sequence 291 dbid 1337401710 branch 896605872
Archived Log entry 126 added for thread 1 sequence 291 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[3]: Opened log for thread 1 sequence 292 dbid 1337401710 branch 896605872
Archived Log entry 127 added for thread 1 sequence 292 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[3]: Opened log for thread 1 sequence 293 dbid 1337401710 branch 896605872
Archived Log entry 128 added for thread 1 sequence 293 rlc 896605872 ID 0x4fb7d86e dest 2:
Media Recovery Log /u01/app/oracle/archivelog/book/1_291_896605872.dbf
RFS[3]: Opened log for thread 1 sequence 294 dbid 1337401710 branch 896605872
Media Recovery Log /u01/app/oracle/archivelog/book/1_292_896605872.dbf
Archived Log entry 129 added for thread 1 sequence 294 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[3]: Opened log for thread 1 sequence 295 dbid 1337401710 branch 896605872
Media Recovery Log /u01/app/oracle/archivelog/book/1_293_896605872.dbf
Archived Log entry 130 added for thread 1 sequence 295 rlc 896605872 ID 0x4fb7d86e dest 2:
RFS[3]: Opened log for thread 1 sequence 296 dbid 1337401710 branch 896605872
Media Recovery Log /u01/app/oracle/archivelog/book/1_294_896605872.dbf
Archived Log entry 131 added for thread 1 sequence 296 rlc 896605872 ID 0x4fb7d86e dest 2:
Media Recovery Log /u01/app/oracle/archivelog/book/1_295_896605872.dbf
RFS[3]: Opened log for thread 1 sequence 297 dbid 1337401710 branch 896605872
Archived Log entry 132 added for thread 1 sequence 297 rlc 896605872 ID 0x4fb7d86e dest 2:
Media Recovery Log /u01/app/oracle/archivelog/book/1_296_896605872.dbf
RFS[3]: Opened log for thread 1 sequence 298 dbid 1337401710 branch 896605872
Archived Log entry 133 added for thread 1 sequence 298 rlc 896605872 ID 0x4fb7d86e dest 2:
Media Recovery Log /u01/app/oracle/archivelog/book/1_297_896605872.dbf
Media Recovery Log /u01/app/oracle/archivelog/book/1_298_896605872.dbf
Media Recovery Waiting for thread 1 sequence 299 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 299 Reading mem 0
Mem# 0: /mnt/ramdisk/book/redostb01.log
SYS@bookdg> @ &r/dg/dg
PROCESS PID STATUS CLIENT_P GROUP# THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------- ------------ -------- ------ ------- ---------- ---------- ---------- ----------
RFS 23904 IDLE UNKNOWN N/A 0 0 0 0 0
RFS 23902 IDLE LGWR 1 1 299 84 1 0
ARCH 23826 CLOSING ARCH 4 1 289 1 1573 0
MRP0 23828 APPLYING_LOG N/A N/A 1 299 84 102400 0
SYS@bookdg> @ &r/dg/dg_mess
FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAMP MESSAGE
------------------------ ------------- ---------- ----------- ---------- --- ------------------- --------------------------------------------------------------------------------
Log Transport Services Informational 0 1 0 NO 2017-02-06 11:28:49 ARC0: Archival started
Log Transport Services Informational 0 2 0 NO 2017-02-06 11:28:49 ARC0: Becoming the 'no FAL' ARCH
Log Transport Services Informational 0 3 0 NO 2017-02-06 11:28:49 ARC0: Becoming the 'no SRL' ARCH
Log Transport Services Informational 0 4 0 NO 2017-02-06 11:28:49 ARC0: Becoming the heartbeat ARCH
Log Transport Services Informational 0 5 0 NO 2017-02-06 11:28:49 ARC0: Becoming the active heartbeat ARCH
Log Apply Services Control 0 6 0 YES 2017-02-06 11:29:18 Attempt to start background Managed Standby Recovery process
Log Apply Services Control 0 7 0 YES 2017-02-06 11:29:19 MRP0: Background Managed Standby Recovery process started
Log Apply Services Informational 0 8 0 NO 2017-02-06 11:29:25 Managed Standby Recovery starting Real Time Apply
Remote File Server Informational 0 9 0 NO 2017-02-06 11:34:48 RFS[1]: Assigned to RFS process 23900
Log Transport Services Control 0 10 0 YES 2017-02-06 11:34:48 ARC0: Beginning to archive thread 1 sequence 289 (13275729283-13275730755)
Log Transport Services Control 0 11 0 YES 2017-02-06 11:34:48 ARC0: Completed archiving thread 1 sequence 289 (0-0)
Log Apply Services Informational 0 12 0 NO 2017-02-06 11:34:48 Media Recovery Log /u01/app/oracle/archivelog/book/1_290_896605872.dbf
Log Apply Services Warning 0 13 0 NO 2017-02-06 11:34:49 Media Recovery Waiting for thread 1 sequence 291
Log Apply Services Informational 0 14 0 NO 2017-02-06 11:34:49 Fetching gap sequence in thread 1, gap sequence 291-291
Remote File Server Informational 0 15 0 NO 2017-02-06 11:34:49 Primary database is in MAXIMUM PERFORMANCE mode
Remote File Server Informational 0 16 0 NO 2017-02-06 11:34:49 RFS[2]: Assigned to RFS process 23902
Remote File Server Informational 0 17 0 NO 2017-02-06 11:34:50 RFS[3]: Assigned to RFS process 23904
Log Apply Services Informational 0 18 0 NO 2017-02-06 11:34:50 Media Recovery Log /u01/app/oracle/archivelog/book/1_291_896605872.dbf
Log Apply Services Informational 0 19 0 NO 2017-02-06 11:34:50 Media Recovery Log /u01/app/oracle/archivelog/book/1_292_896605872.dbf
Log Apply Services Informational 0 20 0 NO 2017-02-06 11:34:51 Media Recovery Log /u01/app/oracle/archivelog/book/1_293_896605872.dbf
Log Apply Services Informational 0 21 0 NO 2017-02-06 11:34:51 Media Recovery Log /u01/app/oracle/archivelog/book/1_294_896605872.dbf
Log Apply Services Informational 0 22 0 NO 2017-02-06 11:34:51 Media Recovery Log /u01/app/oracle/archivelog/book/1_295_896605872.dbf
Log Apply Services Informational 0 23 0 NO 2017-02-06 11:34:52 Media Recovery Log /u01/app/oracle/archivelog/book/1_296_896605872.dbf
Log Apply Services Informational 0 24 0 NO 2017-02-06 11:34:52 Media Recovery Log /u01/app/oracle/archivelog/book/1_297_896605872.dbf
Log Apply Services Informational 0 25 0 NO 2017-02-06 11:34:52 Media Recovery Log /u01/app/oracle/archivelog/book/1_298_896605872.dbf
Log Apply Services Warning 0 26 0 NO 2017-02-06 11:34:53 Media Recovery Waiting for thread 1 sequence 299 (in transit)
26 rows selected.