A note on tracing when you have dataguard environment,
Use the following useful SQL
SELECT group#, member FROM v$logfile WHERE type = ‘STANDBY’; SELECT group#, dbid, archived, status FROM v$standby_log; SELECT dest_id,valid_type,valid_role,valid_now FROM v$archive_dest; SELECT process, status, group#, thread#, sequence# FROM v$managed_standby order by process, group#, thread#, sequence#; SELECT name, value, time_computed FROM v$dataguard_stats; SELECT […]
Follow Me!!!