Restart uard method and restart uard Method
-- DG restart procedure
-- 1. Shut down the master database
Shutdown immediate;
-- 2. Disable the standby Database
Alter database recover managed standby database cancel;
Shutdown immediate;
-- No listener. If the listener is disabled,
After the slave database is started, the slave Database Listener must be started and the master database must be started.
-- 3. Start the slave Database
Startup
-- 4. Start the master database
Startup
-- 5. The slave database starts the application.
Alter database recover managed standby database disconnect from session;
-- 6. Check the synchronization of archive logs in the slave database (the applied status is yes)
SQL> SELECT NAME, applied FROM v $ archived_log;
-- 7. check archive log
Master database:
SQL> archive log list;
Slave database:
SQL> archive log list;
Check whether the Current log sequence is the same, indicating that the synchronization is consistent. Restart.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.