MANAGED STANDBY PROBLEM
From: Howard Latham <howard.latham_at_gmail.com>
Date: Wed, 1 Aug 2018 14:06:01 +0100
Message-ID: <CAPCNhx0-V0ncKAq1nvAWNgLQ4KgKa42ZjcVzg+AxA77MFffOmA_at_mail.gmail.com>
All view and suggestions on this problem welcome!
Date: Wed, 1 Aug 2018 14:06:01 +0100
Message-ID: <CAPCNhx0-V0ncKAq1nvAWNgLQ4KgKa42ZjcVzg+AxA77MFffOmA_at_mail.gmail.com>
All view and suggestions on this problem welcome!
Oracle 11.2.04 RH ENT 5
Using physical standbys, Not using dataguard broker.
we have 1 primary and 2 standbys - both are are up to date and applying logs happily but
v$archive_dest_status is giving a crazy - very low wrong applied log number
and the following error appears in the nsa trace file.
LOG_ARCHIVE_DEST_6 depends upon me, but my destination index 4 does not match its destination index 5
A clue is we get the wrong number even when the standby giving the wrong number is down.
Have tried bouncing both standbys.
Howard A. Latham
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 01 2018 - 15:06:01 CEST