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.