database role change date
edited Jun 12, 2013 12:24PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered
is there any database view suggesting exact time when role_changed occured for a database? For example, when exactly the primary became standby or stand became primary?
Getting similar data indirectly from v$dataguard_status but not sure how many scenarios will be captured there. Moreover, I think the last standby_to_primary conversion time stamp can be taken from (select scn_to_timestamp(standby_became_primary_scn) from v$database)
Regards
Manish
Getting similar data indirectly from v$dataguard_status but not sure how many scenarios will be captured there. Moreover, I think the last standby_to_primary conversion time stamp can be taken from (select scn_to_timestamp(standby_became_primary_scn) from v$database)
Regards
Manish
0