Shulou(Shulou.com)06/01 Report--

Problem: after the DG is built, the archive of the master database cannot be automatically synchronized to the standby database.

Troubleshooting: error is reported in the alarm log of the main database:

PING [ARC2]: Heartbeat failed to connect to standby 'cjcdb02'. Error is 16058.

Error reason: the standby database failed and the master database could not connect to the standby database. After the standby database was restored, the master database did not attempt to reconnect the database.

Solution: the main library reactivates log_archive_dest_state_2

The process is as follows:

Main library:

Toggle archiving

SQL > alter system switch logfile; System altered.SQL > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination / archOldest online log sequence 15Next log sequence to archive 17Current log sequence 17

Prepare the library:

No archive log was received

SQL > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination / archOldest online log sequence 0Next log sequence to archive 0Current log sequence 0

Check the slave alarm log. No error has been reported. The RFS process has been started.

RFS connections are allowed

Main library:

Main database alarm log:

Use the following SQL commands on the standby database to createstandby redo logfiles that match the primary database:ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800 + alter DATABASE ADD STANDBY LOGFILE' srl2.f' SIZE 52428800 * * alter DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800 * * srl4.f' SIZE 5242828800 * * 2020ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';Tue Aug 04 15:29:26 2020ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';Tue Aug 04 15:29:26 2020PING [ARC2]: Heartbeat failed to connect to standby 'cjcdb02'. Error is 16058.Tue Aug 04 15:29:28 2020

After the primary database failed to connect to the standby database once, there was no attempt to reconnect.

Main library:

Reactivate

SQL > alter system set log_archive_dest_state_2=defer;SQL > alter system set log_archive_dest_state_2=enable

Main database alarm log:

Tue Aug 04 15:33:58 2020ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;Tue Aug 04 15:34:22 2020ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH Tue Aug 04 15:34:22 2020Thread 1 cannot allocate new log, sequence 20Checkpoint not complete Current log# 1 seq# 19 mem# 0: / oracle/oradata/cjcdb01/redo01.logThread 1 cannot allocate new log Sequence 20Private strand flush not complete Current log# 1 seq# 19 mem# 0: / oracle/oradata/cjcdb01/redo01.logThread 1 advanced to log sequence 20 (LGWR switch) Current log# 2 seq# 20 mem# 0: / oracle/oradata/cjcdb01/redo02.logTue Aug 04 15:34:29 2020Archived Log entry 17 added for thread 1 sequence 19 ID 0x3995c964 dest 1:Tue Aug 04 15:34:29 2020ARC0: Standby redo logfile selected for thread 1 sequence 19 for destination LOG_ARCHIVE_DEST_2Tue Aug 04 15:34:29 20 * * LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2** * * LNS: Standby redo logfile selected for thread 1 sequence 20 for destination LOG_ARCHIVE_DEST_2

Prepare the database alarm log:

Tue Aug 04 15:34:21 2020RFS [1]: Assigned to RFS process 11502RFS [1]: Opened log for thread 1 sequence 14 dbid 966115684 branch 1047470758Tue Aug 04 15:34:21 2020RFS [2]: Assigned to RFS process 11504RFS [2]: Opened log for thread 1 sequence 16 dbid 966115684 branch 1047470758Tue Aug 04 15:34:21 2020RFS [3]: Assigned to RFS process 11506RFS [3]: Opened log for thread 1 sequence 15 dbid 966115684 branch 1047470758Archived Log entry 1 added for thread 1 sequence 14 rlc 1047470758 ID 0x3995c964 dest 2:RFS [1]: Opened log For thread 1 sequence 17 dbid 966115684 branch 1047470758Archived Log entry 2 added for thread 1 sequence 16 rlc 1047470758 ID 0x3995c964 dest 2:Archived Log entry 3 added for thread 1 sequence 17 rlc 1047470758 ID 0x3995c964 dest 2:Archived Log entry 4 added for thread 1 sequence 15 rlc 1047470758 ID 0x3995c964 dest 2:RFS [2]: Opened log for thread 1 sequence 18 dbid 966115684 branch 1047470758Archived Log entry 5 added for thread 1 sequence 18 rlc 1047470758 ID 0x3995c964 dest 2:RFS [2]: Selected log 4 for thread 1 sequence 19 dbid 966115684 branch 1047470758Tue Aug 04 15:34:28 2020Archived Log entry 6 added For thread 1 sequence 19 ID 0x3995c964 dest 1:Tue Aug 04 15:34:28 2020Primary database is in MAXIMUM PERFORMANCE modeRFS [4]: Assigned to RFS process 11514RFS [4]: Selected log 4 for thread 1 sequence 20 dbid 966115684 branch 1047470758

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together! !

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.