oracle-dataguard-How to restart the server

DG Principle: The host sends the log file to the standby machine, the standby machine executes the log file, this and the host data synchronizes.

According to this principle, it is not difficult to deduce the sequence of DG's switch machine

Shutdown sequence first the host and then the machine, so that the log will not be broken

The boot sequence is ready for the mainframe, so the goal is to keep the log

Specific steps

Shutdown

1. Perform on the main library

Shutdown immediate;

2. Perform on the standby

ALTER DATABASE recover managed standby Database cancel;--This sentence is very important, if not to execute this sentence, the repository basic shut down, finally can only shutdown abort

Shutdown immediate;

Analysis: ALTER DATABASE recover managed standby database cancel; is used to shut down the MRP process, which is used to restore the original library log to the repository operation, if not shut him, the instance will think that the log file is not processed, has been waiting for feedback from the MRP process.

Boot

1. Perform on the standby

--Open MRP

startup Mount;

ALTER DATABASE open;

ALTER DATABASE recover managed standby database disconnect from session;

2. Perform on the main library

startup Mount;

ALTER DATABASE open;

Note: If you are doing hardware maintenance and shutting down the server, you should be concerned about whether the listener on the primary standby server is started

Check listening status

Lsnrctl status

Start listening status

Lsnrctl start

enjoy; P

oracle-dataguard-How to restart the server