log shipping in 12c - log_archive_dest_state_2

From: Abhinav Gupta <iamabhinav.akg_at_gmail.com>
Date: Mon, 11 Jul 2016 11:37:37 +0530
Message-ID: <CAFVbUGf7zbpe9ScH0=PJSEqrnOXz=aQrq61fzrFzn_z08nUBGA_at_mail.gmail.com>

Hi All,

I have couple of primary database (all 2 node RAC on same CRS) along with physical standby counterparts(all single instance on same server). The RDBMS versions are 12.1.0.2 and are on RHEL5.

Quite frequently one or more standby goes out of sync due to "WAIT_FOR_LOG" on mrp. This is resolved by altering log_archive_dest_state_2 on primary to DEFER and then back to ENABLE. This immediately starts the stopped log shipping and standby is back sync soon.

Mostly, one of the database is erratic, however, at times, two or more throws the same issue at same point of time. Hence, it could be something outside database as well. Never seen this issue in any of our pre-12c database, so far with similar set of configurations.

Anyone?

Regards,
Abhinav

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 11 2016 - 08:07:37 CEST

This message: [ Message body ]
Next message: Dominic Brooks: "RE: dbms_spm.load_plans_from_sqlset is loading wrong xplan into the baseline"
Previous message: Zwettler Markus (OIZ): "Network based schema impdp"
Next in thread: Ram Cheruvattath: "Re: log shipping in 12c - log_archive_dest_state_2"
Reply: Ram Cheruvattath: "Re: log shipping in 12c - log_archive_dest_state_2"
Maybe reply: Neil Chandler: "RE: log shipping in 12c - log_archive_dest_state_2"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message