Solved

physical stand by monitoring

Posted on 2012-04-06
2
283 Views
Last Modified: 2012-08-02
hello experts,

i have a 4 node cluster, we configured physical standy on one node. now i need to verify following things.

1. i need to find most recent archived log file was generated on production cluster (each instance)?
2. the same file is transfered on standy by or not?
3. need to check the archive log file is applied on standby?

could you please send me queries if any one have. i am planning to setup some monitoring for data guard setup.
0
Comment
Question by:sk0227
2 Comments
 
LVL 23

Expert Comment

by:David
ID: 37817000
I regret I don't have easy answers with which you may "simply" confirm this, but you're thinking in the right direction.  It's up to you, not us, to tell your boss that your changes will not crash the production system.

However, once you have made more diligent effort to follow the documented installation steps, you may find your own answer by searching E-E with your tag words.

HTH
0
 
LVL 1

Accepted Solution

by:
Faher earned 500 total points
ID: 37819160
1. Connect to the standby and get the sequence number of the last
   applied archive log. Call it laseq:

         select max(sequence#) from v$archived_log where applied='YES';

2. Get the sequence number of the last complete archive log on the
   standby. This is the last log the standby can apply without receiving
   additional archive logs from the primary. Call it lrseq:

      SELECT min(sequence#) FROM v$archived_log WHERE ( (sequence#+1) NOT IN
      (SELECT sequence# FROM v$archived_log) ) AND (sequence# > laseq)

3. (lrseq - laseq) is the number of archived logs that have not been
   applied on the standby, but could be applied if the primary host becomes
   unavailable. If a failover occurs, this number indicates the number of
   archive logs that need to be applied before activating the standby.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question