--DG Restart Step
--1, closing the main library
SHUTDOWN IMMEDIATE;
--2, closing the standby library
ALTER database RECOVER MANAGED STANDBY database CANCEL;
SHUTDOWN IMMEDIATE;
--No listening, if you turn off the monitor,
When you start the repository, you start the standby monitor, and then the main library.
--3, starting and preparing the library
Startup
--4, starting the main library
Startup
--5, Standby Library launch application
ALTER database RECOVER MANAGED STANDBY database disconnect from session;
--6, check the standby archive log synchronization (applied status is YES)
Sql> SELECT name,applied from V$archived_log;
--7, check archive log
Main Library:
sql> archive log list;
Standby Library:
sql> archive log list;
See if the current log sequence is the same, indicating that synchronization is consistent. Reboot is OK.
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Dataguard Restart method
