physical stand by monitoring

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.
sk0227Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
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
FaherCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.