RE: GENERATE REPORT FOR SWITCH OVER/FAIL OVER FOR DATA GUARD

You can look at V$DATABASE_INCARNATION, but it doesn't track all history and there of course are things as human you can do that would appear here too.

Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba_at_comcast.net
View Matthew Parker's profile on LinkedIn www.dimensionaldba.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rusnak, George A CTR (US) DeCA HQ LEITC Sent: Thursday, December 7, 2017 4:48 AM To: Oracle-L (E-mail) <Oracle-L_at_freelists.org> Subject: GENERATE REPORT FOR SWITCH OVER/FAIL OVER FOR DATA GUARD

Gurus,
We have Oracle 12.1.0.2 Active Data Guard. Upper level management recently requested a report that will show switch overs and failovers, date and time, from primary to secondary instance name, etc.

If the document exists that explains/shows how to accomplish this I have not been able to locate it. The only thing I have come up with is getting information from the dataguard log which is very cumbersome.

Does anyone have a more elegant solution?

Thank you,
Al

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 07 2017 - 16:14:01 CET