Re: Standby db Real Time Apply (10gR2)
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 28 Oct 2008 13:24:03 -0700 (PDT)
Message-ID: <931047f6-dbeb-4fa4-acfe-1aa53a450112@v22g2000pro.googlegroups.com>
Date: Tue, 28 Oct 2008 13:24:03 -0700 (PDT)
Message-ID: <931047f6-dbeb-4fa4-acfe-1aa53a450112@v22g2000pro.googlegroups.com>
Hi,
Have you actually created the standby logs with the same size as the primary's online redo logs? Oracle won't return an error if you haven't, but it will silently throw the exception you noted.
If you have created them, I would make sure the standby is actually caught up. One view (among others like v$dataguard_stats) you can use is v$standby_apply_snapshot. Assuming you are using maximum performance mode on the primary, then if that view is not yet populated (or the time is not relatively current, less than a minute behind or so), you may not yet have the transaction on the standby. Wait until you see it "caught up" and you should see the transaction.
HTH, Steve Received on Tue Oct 28 2008 - 15:24:03 CDT