The oracle dg slave database does not synchronize the data of the master database.

The oracle dg slave database does not synchronize the data of the master database.

Today, a database synchronization problem occurs. The master database is shut down. After the master database is restarted, the slave database cannot synchronize the data of the master database normally. The backup database can be consistent with the master database only when you manually switch to the archive log.

Solution to this problem:

Restart the slave database and apply the archived logs again.

The procedure is as follows:

// Close the standby listener

Lsnrctl stop

// Close the standby Database

Sqlplus/as sysdba

Alter database recover managed standby database cancel;

Shutdown immediate;

// Start the slave Database

Startup nomount;

Alter database mount standby database;

Alter database open read only;

Alter database recover managed standby database using current logfile disconnect from session;

// Start the standby listener

Quit;

Lsnrctl start