DR issue

[Former Member]

Hi,

We are having issue after link down issue..logs were not automatically getting applied

We manually registered with below for copied archive log files

SQL> ALTER DATABASE REGISTER LOGFILE 'K:\oracle\PR1\oraarch\PR1ARCHARC0028816_0747680046.001';

But it is not getting applied.. Status it is showing status NO

Pls suggest

[Former Member]

Hi,

If it is just a link/NW related issue, system never behaves like that.

Check the status of secondary archive destination, Check the DG listener status, Check the connectivity using TNSPING between Primary and Secondary, Check the log shipping process between Primary and Secondary, Switch log files manually on pirmary then see.

If everything is fine, then paste the error logs from alertSID.log.

Regards,

Nick Loy

[Former Member]

Hi,

Every thing was working fine - Listner, archive dest, tnsping.  No alert/warning in alert file

We rebooted our Standby Windows server and issue resolved.

regards

[former_member182657]

Kindly check for log 28814 first.Is the same log applied as the status showing NO for this also.

Regards,

Gaurav

[former_member182657]

Also share alert_<SID>.log file for analysis.

[former_member182657]

Hi,

Kindly share result for query select * from v$archive_gap;

Regards,

Gaurav

[Reagan]

What does the alert log say when you do this ?

[former_member188883]

Hi Praveen,

Execute the below commands and check

At Primary

alter system set log_archive_dest_state_2= defer;

Wait for 5 - 10 mins and then on DR execute the following

alter system set log_archive_dest_state_2=enable;

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi

we already did Defered and Enabled but same issue

We first Defered with above command on Primary, then on standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

then registered the missing log file file on standby then Enabled on Primary  with above then

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE;   on standby

[Reagan]

Ignore the suggestion to defer and enable log_archive_dest_state_2. It is misleading.

Check the alert log of the standby database to know what happens.