Reinstating the failed primary database

Once the failed primary server has been repaired, you can reinstate it as the primary database.

To reinstate the failed primary database

After the primary database has been repaired, to restart the database, as the oracle user on Solaris or the AgfaService user on Windows, type
sqlplus / as sysdba
startup mount;
quit
To launch the Data Guard manager, on the primary server as the oracle user on Solaris or the AgfaService user on Windows, type
dgmgrl sys/stayout@mvf2
To perform the switchover type
show configuration
reinstate database 'MVF1'
show configuration
exit
To launch the Data Guard manager on the repaired primary, as the Oracle user, type
dgmgrl sys/stayout@mvf2
To make MVF1 the primary server type
switchover to 'MVF1'
exit
Stop the public listener on the new standby server.
On Solaris, as the oracle user, typelsnrctl stop listener_public. On Windows, stop the public_listener service.
To stop IMPAX on the new standby server, type
stop_impax (Solaris) or stopall (Windows)
To query for the ae_ref and the ae_title, in CLUI, type
ae query
To determine the signal translator service refs, in CLUI, type
select map_service.service_ref from map_service inner join map_ae on map_ae.ae_ref = map_service.ae_ref inner join map_implements on map_service.service_ref = map_implements.service_ref inner join map_process on map_implements.process_ref = map_process.process_ref where map_process.process_title='MVF_SIGNAL_TRANSLATOR' and map_ae.ae_title='AE_Title_of_ failed_primary_server'
Two service refs are returned.
For each service ref, in CLUI, type
service delete <service ref>
To set the new primary Task Scheduler, in CLUI, type
update map_ini set ini_value='AE_title_of_new_primary_server' where ini_section='MVF_TASK_SCHEDULER' and ini_key='PRIMARY_SERVER'
update mvf_ts_config set ae_ref='AE_reference_of_new_primary_server' where ae_ref='AE_reference_of_old_primary_server'
Start the public listener on the new primary server.
On Solaris, as the oracle user, type lsnrctl start listener_public. On Windows, start the public_listener service.
To start IMPAX on the new primary server, as the root user, type
start_impax (Solaris) or startall (Windows)