溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
這篇文章主要為大家展示了“Oracle Dataguard報錯怎么辦”，內容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領大家一起研究并學習一下“Oracle Dataguard報錯怎么辦”這篇文章吧。
環境：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;
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;
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
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.
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
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.
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)))
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.
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;
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
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
RFS[2]: Assigned to RFS process 10604
Media Recovery Log /archlog/STRAC/archivelog/2018_03_04/o1_mf_1_162f9q9h4vb.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
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
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
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
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
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
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
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
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
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
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_176f9q9w9h6.ar
c
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
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
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
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
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_162f9q9h4vb.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_176f9q9w9h6.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 Dataguard報錯怎么辦”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注億速云行業資訊頻道！
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
