手机版
你好,游客 登录 注册 搜索
背景:
阅读新闻

Oracle Dataguard报错:ARC1: Becoming the 'no FAL' ARC

[日期:2018-03-08] 来源:Linux社区  作者:Linux [字体: ]

环境:RAC+单机 Dataguard
问题:启动DG备库到mount阶段,启动MRP进程后,发现后台日志不打印归档传输信息,另外备库日志打开ARC1: Becoming the 'no FAL' ARC

1、启动DG备库到mount阶段,启动MRP进程后,发现后台日志不打印归档传输信息,
,发现备库中的日志有报错现象,报:ARC1: Becoming the 'no FAL' ARC错误,告警中日志如下
MMON started with pid=15, OS id=10552
Oracle_BASE from environment = /oracle/app/oracle
Sun Mar 04 15:44:47 2018
MMNL started with pid=16, OS id=10554
Sun Mar 04 15:44:47 2018
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Sun Mar 04 15:44:52 2018
ARC0 started with pid=18, OS id=10561
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2557884335
Physical Standby Database mounted.
Lost write protection disabled
Sun Mar 04 15:44:53 2018
ARC1 started with pid=19, OS id=10564
Sun Mar 04 15:44:53 2018
ARC2 started with pid=20, OS id=10566
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Sun Mar 04 15:44:53 2018
ARC3 started with pid=21, OS id=10568
Completed: ALTER DATABASE MOUNT
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sun Mar 04 15:51:20 2018
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (strac)

2、在备库中查询查询状态如下,其中有后台日志报错信息

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

MESSAGE

ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
ARC3: Archival started

7 rows selected.

3、此时通过第2步是发现备库中有报归档日志错误信息,可以先到主库是查询是否报错
查询结果如下:
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

MESSAGE

Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby

MESSAGE

PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.

MESSAGE

Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby

MESSAGE

PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.

MESSAGE

Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'strac'. Error is 12154.
Error 12154 received logging on to the standby

4、通过第三步发现主库中无法连接备库,导致报12154错误,通过分析,由于我们在备库中采集的是静态监听方式来同步数据,在服务器启动时,并不会自动启动静态监听,从而导致RAC和备库不是属于连接状态,

5、解决方法先在备库中手动启动静态监听,观察备库是否报错

[oracle@racdg trace]$ lsnrctl status--查询当前监听状态

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-MAR-2018 15:52:15

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racdg)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@racdg trace]$ lsnrctl start --启动监听

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-MAR-2018 15:52:24

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /oracle/app/oracle/product/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /oracle/app/oracle/product/11.2.0/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/racdg/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdg)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racdg)(PORT=1521)))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 04-MAR-2018 15:52:26
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/racdg/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdg)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "strac" has 1 instance(s).
Instance "strac", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@racdg trace]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-MAR-2018 15:52:47

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racdg)(PORT=1521)))
STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 04-MAR-2018 15:52:26
Uptime 0 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/racdg/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racdg)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "strac" has 1 instance(s).
Instance "strac", status UNKNOWN, has 1 handler(s) for this service...--显示为静态监听
The command completed successfully

6、此时再次查询DG的状态,发现有归档日志传输过到DG库中

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

MESSAGE

ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
ARC3: Archival started
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequence 161

MESSAGE

Fetching gap sequence in thread 1, gap sequence 161-161
RFS[1]: Assigned to RFS process 10600
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_161f9q9gtp0.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_99f9kzzhq2.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_100f9l00mnz.ar
c

Media Recovery Waiting for thread 1 sequence 162
Fetching gap sequence in thread 1, gap sequence 162-162

MESSAGE

RFS[2]: Assigned to RFS process 10604
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_162f9q9h3vb.ar
c

Media Recovery Waiting for thread 1 sequence 163
Fetching gap sequence in thread 1, gap sequence 163-163
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_163f9q9hdxv.ar
c

Media Recovery Waiting for thread 1 sequence 164
Fetching gap sequence in thread 1, gap sequence 164-164

MESSAGE

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_164f9q9hr44.ar
c

Media Recovery Waiting for thread 1 sequence 165
Fetching gap sequence in thread 1, gap sequence 165-165
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_165f9q9j27p.ar
c

Media Recovery Waiting for thread 1 sequence 166
Fetching gap sequence in thread 1, gap sequence 166-166
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_166f9q9jdoq.ar

MESSAGE

c

Media Recovery Waiting for thread 1 sequence 167
Fetching gap sequence in thread 1, gap sequence 167-167
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_167f9q9jotm.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_101f9l02sv8.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_102f9l02wrc.ar

MESSAGE

c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_103f9l8x8b8.ar
c

Media Recovery Waiting for thread 1 sequence 168
Fetching gap sequence in thread 1, gap sequence 168-168
ARC0: Beginning to archive thread 1 sequence 168 (3679660-3724468)
ARC0: Completed archiving thread 1 sequence 168 (0-0)
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_168f9q9lxgy.ar
c

MESSAGE

Media Recovery Waiting for thread 1 sequence 169
Fetching gap sequence in thread 1, gap sequence 169-169
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_169f9q9n23p.ar
c

Media Recovery Waiting for thread 2 sequence 104
ARC1: Beginning to archive thread 2 sequence 104 (3724490-3744517)
ARC1: Completed archiving thread 2 sequence 104 (0-0)
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_104f9q9nc85.ar
c

MESSAGE

Media Recovery Waiting for thread 2 sequence 105
Fetching gap sequence in thread 2, gap sequence 105-105
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_105f9q9no3z.ar
c

Media Recovery Waiting for thread 2 sequence 106
Fetching gap sequence in thread 2, gap sequence 106-106
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_106f9q9o0j5.ar
c

MESSAGE

Media Recovery Waiting for thread 1 sequence 170
Fetching gap sequence in thread 1, gap sequence 170-170
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_170f9q9pcpl.ar
c

Media Recovery Waiting for thread 1 sequence 171
Fetching gap sequence in thread 1, gap sequence 171-171
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_171f9q9pqkc.ar
c

Media Recovery Waiting for thread 1 sequence 172

MESSAGE

Fetching gap sequence in thread 1, gap sequence 172-172
RFS[3]: Assigned to RFS process 10616
RFS[4]: Assigned to RFS process 10614
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Assigned to RFS process 10618
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_172f9q9q3pz.ar
c

Media Recovery Waiting for thread 2 sequence 107 (in transit)
RFS[6]: Assigned to RFS process 10620
RFS[7]: Assigned to RFS process 10622

MESSAGE

RFS[8]: Assigned to RFS process 10624
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_107f9q9q7lr.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_108f9q9q7lv.ar
c

Media Recovery Waiting for thread 1 sequence 173
Fetching gap sequence in thread 1, gap sequence 173-173
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_173f9q9sq3g.ar
c

MESSAGE

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_109f9q9q7z6.ar
c

Media Recovery Waiting for thread 1 sequence 174
Fetching gap sequence in thread 1, gap sequence 174-174
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_174f9q9tz7q.ar
c

Media Recovery Waiting for thread 1 sequence 175
Fetching gap sequence in thread 1, gap sequence 175-175

MESSAGE

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_175f9q9vwo0.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_110f9q9qlco.ar
c

Media Recovery Waiting for thread 1 sequence 176
Fetching gap sequence in thread 1, gap sequence 176-176
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_176f9q9w9h5.ar
c

MESSAGE

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_111f9q9qmng.ar
c

Media Recovery Waiting for thread 1 sequence 177
Fetching gap sequence in thread 1, gap sequence 177-177
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_177f9q9x92z.ar
c

Media Recovery Waiting for thread 1 sequence 178
Fetching gap sequence in thread 1, gap sequence 178-178
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_178f9q9xmc8.ar

MESSAGE

c

Media Recovery Waiting for thread 1 sequence 179
Fetching gap sequence in thread 1, gap sequence 179-179
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_179f9q9xxgx.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_112f9q9qmwy.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_113f9q9qmyd.ar

MESSAGE

c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_114f9q9qncn.ar
c

Media Recovery Waiting for thread 1 sequence 180
Fetching gap sequence in thread 1, gap sequence 180-180
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_180f9q9y7sn.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_115f9q9qncr.ar

MESSAGE

c

Media Recovery Waiting for thread 1 sequence 181
Fetching gap sequence in thread 1, gap sequence 181-181
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_181f9q9ykrr.ar
c

Media Recovery Waiting for thread 1 sequence 182
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_182f9q9ywg8.ar
c

MESSAGE

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_116f9q9qnl3.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_117f9q9qnl7.ar
c

Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_118f9q9qnt2.ar
c

Media Recovery Waiting for thread 1 sequence 183

115 rows selected.

SQL>

7、查看日志中发现有大量的归档日志传输过来,详细的内容如下:
alter database recover managed standby database disconnect from session
Attempt to start background Managed Standby Recovery process (strac)
Sun Mar 04 15:51:20 2018
MRP0 started with pid=22, OS id=10584
MRP0: Background Managed Standby Recovery process started (strac)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 1 sequence 161
Fetching gap sequence in thread 1, gap sequence 161-161
Completed: alter database recover managed standby database disconnect from session
Sun Mar 04 15:52:58 2018
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
RFS[1]: Assigned to RFS process 10600
RFS[1]: Opened log for thread 1 sequence 161 dbid -1759711868 branch 947273412
Archived Log entry 48 added for thread 1 sequence 161 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:06 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_161f9q9gtp0.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_99f9kzzhq2.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_100f9l00mnz.arc
Media Recovery Waiting for thread 1 sequence 162
Fetching gap sequence in thread 1, gap sequence 162-162
Sun Mar 04 15:53:07 2018
RFS[2]: Assigned to RFS process 10604
RFS[2]: Opened log for thread 1 sequence 162 dbid -1759711868 branch 947273412
Archived Log entry 49 added for thread 1 sequence 162 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:16 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_162f9q9h3vb.arc
Media Recovery Waiting for thread 1 sequence 163
Fetching gap sequence in thread 1, gap sequence 163-163
RFS[2]: Opened log for thread 1 sequence 163 dbid -1759711868 branch 947273412
Archived Log entry 50 added for thread 1 sequence 163 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:26 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_163f9q9hdxv.arc
Media Recovery Waiting for thread 1 sequence 164
Fetching gap sequence in thread 1, gap sequence 164-164
Sun Mar 04 15:53:28 2018
RFS[2]: Opened log for thread 1 sequence 164 dbid -1759711868 branch 947273412
Archived Log entry 51 added for thread 1 sequence 164 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:37 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_164f9q9hr44.arc
Media Recovery Waiting for thread 1 sequence 165
Fetching gap sequence in thread 1, gap sequence 165-165
Sun Mar 04 15:53:38 2018
RFS[2]: Opened log for thread 1 sequence 165 dbid -1759711868 branch 947273412
Archived Log entry 52 added for thread 1 sequence 165 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:47 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_165f9q9j27p.arc
Media Recovery Waiting for thread 1 sequence 166
Fetching gap sequence in thread 1, gap sequence 166-166
Sun Mar 04 15:53:48 2018
RFS[2]: Opened log for thread 1 sequence 166 dbid -1759711868 branch 947273412
Archived Log entry 53 added for thread 1 sequence 166 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:53:57 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_166f9q9jdoq.arc
Media Recovery Waiting for thread 1 sequence 167
Fetching gap sequence in thread 1, gap sequence 167-167
RFS[2]: Opened log for thread 1 sequence 167 dbid -1759711868 branch 947273412
Archived Log entry 54 added for thread 1 sequence 167 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:54:07 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_167f9q9jotm.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_101f9l02sv8.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_102f9l02wrc.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_02/o1_mf_2_103f9l8x8b8.arc
Media Recovery Waiting for thread 1 sequence 168
Fetching gap sequence in thread 1, gap sequence 168-168
Sun Mar 04 15:55:08 2018
RFS[2]: Selected log 7 for thread 1 sequence 168 dbid -1759711868 branch 947273412
Sun Mar 04 15:55:10 2018
Archived Log entry 55 added for thread 1 sequence 168 ID 0x971d6184 dest 1:
Sun Mar 04 15:55:17 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_168f9q9lxgy.arc
Sun Mar 04 15:55:43 2018
Media Recovery Waiting for thread 1 sequence 169
Fetching gap sequence in thread 1, gap sequence 169-169
Sun Mar 04 15:55:46 2018
RFS[2]: Opened log for thread 1 sequence 169 dbid -1759711868 branch 947273412
Archived Log entry 56 added for thread 1 sequence 169 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:55:54 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_169f9q9n23p.arc
Media Recovery Waiting for thread 2 sequence 104
Sun Mar 04 15:55:55 2018
RFS[1]: Selected log 12 for thread 2 sequence 104 dbid -1759711868 branch 947273412
Sun Mar 04 15:55:55 2018
Archived Log entry 57 added for thread 2 sequence 104 ID 0x971d6184 dest 1:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_104f9q9nc85.arc
Media Recovery Waiting for thread 2 sequence 105
Fetching gap sequence in thread 2, gap sequence 105-105
Sun Mar 04 15:56:05 2018
RFS[2]: Opened log for thread 2 sequence 105 dbid -1759711868 branch 947273412
Archived Log entry 58 added for thread 2 sequence 105 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:56:14 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_105f9q9no3z.arc
Media Recovery Waiting for thread 2 sequence 106
Fetching gap sequence in thread 2, gap sequence 106-106
Sun Mar 04 15:56:16 2018
RFS[2]: Opened log for thread 2 sequence 106 dbid -1759711868 branch 947273412
Archived Log entry 59 added for thread 2 sequence 106 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:56:24 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_106f9q9o0j5.arc
Sun Mar 04 15:56:49 2018
Media Recovery Waiting for thread 1 sequence 170
Fetching gap sequence in thread 1, gap sequence 170-170
Sun Mar 04 15:56:59 2018
RFS[2]: Opened log for thread 1 sequence 170 dbid -1759711868 branch 947273412
Archived Log entry 60 added for thread 1 sequence 170 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:09 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_170f9q9pcpl.arc
Media Recovery Waiting for thread 1 sequence 171
Fetching gap sequence in thread 1, gap sequence 171-171
Sun Mar 04 15:57:11 2018
RFS[2]: Opened log for thread 1 sequence 171 dbid -1759711868 branch 947273412
Archived Log entry 61 added for thread 1 sequence 171 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:20 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_171f9q9pqkc.arc
Media Recovery Waiting for thread 1 sequence 172
Fetching gap sequence in thread 1, gap sequence 172-172
Sun Mar 04 15:57:23 2018
RFS[2]: Opened log for thread 1 sequence 172 dbid -1759711868 branch 947273412
Archived Log entry 62 added for thread 1 sequence 172 rlc 947273412 ID 0x971d6184 dest 2:
RFS[2]: Opened log for thread 2 sequence 107 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:28 2018
RFS[3]: Assigned to RFS process 10616
RFS[3]: Opened log for thread 2 sequence 108 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:28 2018
RFS[4]: Assigned to RFS process 10614
RFS[4]: Opened log for thread 2 sequence 109 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:31 2018
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Assigned to RFS process 10618
RFS[5]: Selected log 11 for thread 2 sequence 119 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:34 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_172f9q9q3pz.arc
Media Recovery Waiting for thread 2 sequence 107 (in transit)
Sun Mar 04 15:57:36 2018
Archived Log entry 63 added for thread 2 sequence 107 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:38 2018
RFS[6]: Assigned to RFS process 10620
RFS[6]: Opened log for thread 2 sequence 110 dbid -1759711868 branch 947273412
Sun Mar 04 15:57:38 2018
Archived Log entry 64 added for thread 2 sequence 109 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
Archived Log entry 65 added for thread 2 sequence 108 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
RFS[7]: Assigned to RFS process 10622
RFS[7]: Opened log for thread 2 sequence 111 dbid -1759711868 branch 947273412
Archived Log entry 66 added for thread 2 sequence 111 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:57:39 2018
RFS[8]: Assigned to RFS process 10624
RFS[8]: Opened log for thread 2 sequence 112 dbid -1759711868 branch 947273412
RFS[7]: Opened log for thread 2 sequence 113 dbid -1759711868 branch 947273412
Archived Log entry 67 added for thread 2 sequence 113 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 68 added for thread 2 sequence 112 rlc 947273412 ID 0x971d6184 dest 2:
RFS[7]: Opened log for thread 2 sequence 114 dbid -1759711868 branch 947273412
RFS[8]: Opened log for thread 2 sequence 115 dbid -1759711868 branch 947273412
Archived Log entry 69 added for thread 2 sequence 114 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 70 added for thread 2 sequence 115 rlc 947273412 ID 0x971d6184 dest 2:
RFS[7]: Opened log for thread 2 sequence 116 dbid -1759711868 branch 947273412
RFS[8]: Opened log for thread 2 sequence 117 dbid -1759711868 branch 947273412
Archived Log entry 71 added for thread 2 sequence 116 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 72 added for thread 2 sequence 117 rlc 947273412 ID 0x971d6184 dest 2:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_107f9q9q7lr.arc
RFS[7]: Opened log for thread 2 sequence 118 dbid -1759711868 branch 947273412
Archived Log entry 73 added for thread 2 sequence 118 rlc 947273412 ID 0x971d6184 dest 2:
Archived Log entry 74 added for thread 2 sequence 110 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:58:38 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_108f9q9q7lv.arc
Media Recovery Waiting for thread 1 sequence 173
Fetching gap sequence in thread 1, gap sequence 173-173
Sun Mar 04 15:58:47 2018
RFS[6]: Opened log for thread 1 sequence 173 dbid -1759711868 branch 947273412
Archived Log entry 75 added for thread 1 sequence 173 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:58:59 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_173f9q9sq3g.arc
Sun Mar 04 15:59:22 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_109f9q9q7z6.arc
Media Recovery Waiting for thread 1 sequence 174
Fetching gap sequence in thread 1, gap sequence 174-174
Sun Mar 04 15:59:27 2018
RFS[6]: Opened log for thread 1 sequence 174 dbid -1759711868 branch 947273412
Archived Log entry 76 added for thread 1 sequence 174 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 15:59:36 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_174f9q9tz7q.arc
Sun Mar 04 15:59:52 2018
Media Recovery Waiting for thread 1 sequence 175
Fetching gap sequence in thread 1, gap sequence 175-175
Sun Mar 04 15:59:53 2018
db_recovery_file_dest_size of 10240 MB is 4.63% 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.
Sun Mar 04 15:59:56 2018
RFS[6]: Opened log for thread 1 sequence 175 dbid -1759711868 branch 947273412
Archived Log entry 77 added for thread 1 sequence 175 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:04 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_175f9q9vwo0.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_110f9q9qlco.arc
Media Recovery Waiting for thread 1 sequence 176
Fetching gap sequence in thread 1, gap sequence 176-176
Sun Mar 04 16:00:09 2018
RFS[6]: Opened log for thread 1 sequence 176 dbid -1759711868 branch 947273412
Archived Log entry 78 added for thread 1 sequence 176 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:21 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_176f9q9w9h5.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_111f9q9qmng.arc
Media Recovery Waiting for thread 1 sequence 177
Fetching gap sequence in thread 1, gap sequence 177-177
Sun Mar 04 16:00:41 2018
RFS[6]: Opened log for thread 1 sequence 177 dbid -1759711868 branch 947273412
Archived Log entry 79 added for thread 1 sequence 177 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:00:51 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_177f9q9x92z.arc
Media Recovery Waiting for thread 1 sequence 178
Fetching gap sequence in thread 1, gap sequence 178-178
Sun Mar 04 16:00:51 2018
RFS[6]: Opened log for thread 1 sequence 178 dbid -1759711868 branch 947273412
Archived Log entry 80 added for thread 1 sequence 178 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:01 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_178f9q9xmc8.arc
Media Recovery Waiting for thread 1 sequence 179
Fetching gap sequence in thread 1, gap sequence 179-179
Sun Mar 04 16:01:01 2018
RFS[6]: Opened log for thread 1 sequence 179 dbid -1759711868 branch 947273412
Archived Log entry 81 added for thread 1 sequence 179 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:11 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_179f9q9xxgx.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_112f9q9qmwy.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_113f9q9qmyd.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_114f9q9qncn.arc
Media Recovery Waiting for thread 1 sequence 180
Fetching gap sequence in thread 1, gap sequence 180-180
Sun Mar 04 16:01:11 2018
RFS[6]: Opened log for thread 1 sequence 180 dbid -1759711868 branch 947273412
Archived Log entry 82 added for thread 1 sequence 180 rlc 947273412 ID 0x971d6184 dest 2:
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_180f9q9y7sn.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_115f9q9qncr.arc
Media Recovery Waiting for thread 1 sequence 181
Fetching gap sequence in thread 1, gap sequence 181-181
RFS[6]: Opened log for thread 1 sequence 181 dbid -1759711868 branch 947273412
Archived Log entry 83 added for thread 1 sequence 181 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:31 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_181f9q9ykrr.arc
Media Recovery Waiting for thread 1 sequence 182
Sun Mar 04 16:01:32 2018
RFS[6]: Opened log for thread 1 sequence 182 dbid -1759711868 branch 947273412
Archived Log entry 84 added for thread 1 sequence 182 rlc 947273412 ID 0x971d6184 dest 2:
Sun Mar 04 16:01:42 2018
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_182f9q9ywg8.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_116f9q9qnl3.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_117f9q9qnl7.arc
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_2_118f9q9qnt2.arc
Media Recovery Waiting for thread 1 sequence 183

8、通过日志发现DG库中是正常的,可以通过在主库中做日志切换观察备库中的日志是否打印,若能正常打印则是正常的
在主库中做日志切换:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 115
Next log sequence to archive 117
Current log sequence 117

SQL> alter system switch logfile;
SQL> /

System altered.

SQL> /

System altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 119
Next log sequence to archive 121
Current log sequence 121
SQL>

9、在备库中日志打印信息,可以判断归档日志是可以正常传输

Sun Mar 04 16:16:04 2018
RFS[5]: Selected log 12 for thread 2 sequence 120 dbid -1759711868 branch 947273412
Sun Mar 04 16:16:05 2018
Archived Log entry 85 added for thread 2 sequence 119 ID 0x971d6184 dest 1:
Sun Mar 04 16:16:13 2018
Archived Log entry 86 added for thread 2 sequence 120 ID 0x971d6184 dest 1:
RFS[5]: Selected log 11 for thread 2 sequence 121 dbid -1759711868 branch 947273412

更多Oracle相关信息见Oracle 专题页面 https://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址https://www.linuxidc.com/Linux/2018-03/151255.htm

linux
相关资讯       Oracle dataguard 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款