Shulou(Shulou.com)06/01 Report--

The log cannot be applied to the backup database after configuration, and the data is out of sync. Check the alarm log of the database master database and find the following error:

LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)

LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

Errors in file / u01/app/oracle/diag/rdbms/primary/orcl/trace/orcl_lgwr_32231.trc:

ORA-03113: end-of-file on communication channel

Error 3113 for archive log file 3 to 'standby'

LGWR: Error 1041 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'standby'

Mon Mar 11 16:16:03 2019

ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)

Error 1034 received logging on to the standby

ARC1: Error 1034 attaching to RFS for reconnect

PING [ARC1]: Error 3113 when pinging standby standby.

Check and find that the custom repository set for archive_dest_2 in the pfile.ora file is different from that in the tns file.

Archive_dest_2 in Dataguard is used to point to the slave database, which is responsible for transferring archive logs to the slave database.

Note that the service= in dest_2 should be the same as that defined in tnsnames.

Close the main library after the change is completed, specify the pfile file to start the database ok problem resolution

Startup pfile='pfile file path'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.