oracle ADG切换步骤

Oracle Active Data Guard (ADG) is a feature in Oracle Database that allows for real-time data protection and disaster recovery. The steps to switch over to ADG are as follows:

Prepare the standby database: Ensure that the standby database is synchronized with the primary database by applying all archived redo logs. This can be done by using Oracle Data Guard Broker or manual methods like RMAN or SQL*Plus commands.
Verify synchronization: Check the Data Guard status to ensure that the standby database is in a synchronized state with the primary database. You can use the "DGMGRL" command-line interface or Enterprise Manager (EM) to verify the synchronization.
Stop the redo apply: Before switching over to ADG, you need to stop applying redo logs on the standby database. This can be done by running the following command on the standby database: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Switch over: To perform the switch over, run the following command on the primary database: ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

This command ensures that all pending transactions are committed and the primary database is ready to be switched over.
Verify the switch over: Check the status of the databases to ensure that the switch over was successful. You can use the "DGMGRL" command-line interface or Enterprise Manager (EM) to verify the status.
Activate the standby database as the new primary database: Once the switch over is successful, you need to activate the standby database as the new primary database. This can be done by running the following command on the new primary database: ALTER DATABASE ACTIVATE STANDBY DATABASE;
Start the redo apply: After the new primary database is activated, start applying redo logs on the former primary database, which is now the new standby database. This can be done by running the following command on the new standby database: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Verify the synchronization: Check the Data Guard status to ensure that the new primary database is synchronized with the new standby database. You can use the "DGMGRL" command-line interface or Enterprise Manager (EM) to verify the synchronization.

By following these steps, you can successfully switch over to Oracle Active Data Guard and ensure high availability and data protection for your Oracle Database.