Go up
Dataguard Role Transition Timestamp
| Subject: |
Dataguard Role Transition Timestamp |
| Author: |
Taoqir Hassan, Pakistan |
| Date: |
May 09, 2023, 19:35, 24 days ago |
| Message: |
Hello,
Is there any way to find exact time/date when role transition took place in DG other than alert log?
Regards,
Taoqir |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Dataguard Role Transition Timestamp |
| Author: |
Matej Pagac, Slovakia |
| Date: |
May 11, 2023, 09:40, 23 days ago |
| Score: |
  |
| Message: |
Hello,
the exact time can be calculated using the STANDBY_BECAME_PRIMARY_SCN from the V$DATABASE:
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-DATABASE.html#GUID-C62A7B96-2DD4-4E70-A0D9-26EE4BFBE256
select scn_to_timestamp(select to_char(standby_became_primary_scn) from v$database) as timestamp from dual;
or "less exact" timestamp can be checked in the dataguard broker log (assuming you are using broker):
https://docs.oracle.com/en/database/oracle/oracle-database/19/dgbkr/troubleshooting-oracle-data-guard-broker.html#GUID-A7D1301B-635F-46C6-9E33-FDA2093B8ABA
The broker log file is created in the same directory as the alert log and is named drc<$ORACLE_SID>.log.
Thanks,
mTj |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here