switching to standby in dataguard config

From: <chris.brown_at_coveainsurance.co.uk>
Date: Wed, 21 Dec 2016 07:28:18 -0800 (PST)
Message-ID: <d69429e9-eb78-45b0-8b18-b7e692a2fc7a_at_googlegroups.com>

[Quoted] I have a primary and standby database ( oracle enterprise 12.1.0.1.0 0 on windows 2012 r2

I want to know the easiest procedure to follow if and when

1. we lost the primary
2. we need to make the standby the primary

This is an active\passive config & we don't use any other products eg databroker etc

regards
Chris B

PS My current doc is as follows but is old and hasn't been tested

1. select switchover_status from v$database if <> ‘sessions active ‘ then alter database commit to switchover to primary else alter database commit to switchover to primary with session shutdown;
2. shutdown immediate; Startup;

Received on Wed Dec 21 2016 - 16:28:18 CET