Change DG to the maximum protection mode, reporting ORA-03113: end-of-fileoncommunicationchanne

Source: Internet
Author: User
ORA-03113: end-of-fileoncommunicationc

When I adjusted Data Guard to maximum protection, I encountered the following problem: end-of-file on communication c

When you adjusted Data Guard to maximum protection, you encountered the following problem: end-of-file on communication channel.
The execution process is as follows:

SQL> alter database set standby database to maximize PROTECTION;
Alter database set standby database to maximize PROTECTION
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any instance
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 390070272 bytes
Fixed Size 2021024 bytes
Variable Size 142608736 bytes
Database Buffers 243269632 bytes
Redo Buffers 2170880 bytes
Database mounted.
SQL> alter database set standby database to maximize PROTECTION;
Database altered.
SQL> select PROTECTION_MODE, OPEN_MODE, DB_UNIQUE_NAME, DATABASE_ROLE, SWITCHOVER_STATUS from v $ database;
PROTECTION_MODE OPEN_MODE DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS
------------------------------------------------------------------------------------------------
MAXIMUM PROTECTION MOUNTED WENDING PRIMARY TO STANDBY
SQL> alter database open;
Alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Analysis log:
[Oracle @ dg1 bdump] $ tail-10f alert_WENDING.log
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 synchronous standby database required
Sat Jan 4 23:05:16 2014
Errors in file/u01/oracle/admin/ORCLDB/bdump/wending_lgwr_10086.trc:
ORA-16072: a minimum of one standby database destination is required
Sat Jan 4 23:05:16 2014
Errors in file/u01/oracle/admin/ORCLDB/bdump/wending_lgwr_10086.trc:
ORA-16072: a minimum of one standby database destination is required
LGWR: terminating instance due to error 16072.
Instance terminated by LGWR, pid = 10086


In fact, the first step is to query the log_archive_dest parameter, check whether the synchronization method and affrem are set, and then whether the standy log is added, after all this is done, check the logs.
The problem may be solved after the first check is completed.
By the way, another method is to enable FLASHBACK_ON;
Enable FLASHBACK_ON.
SQL> select FLASHBACK_ON from v $ database;
FLASHBACK_ON
------------------
NO
SQL> alter database flashback on;
Database altered.

Add standy redolog
[Oracle @ dg2 ~] $ Sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Sun Jan 5 01:00:35 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database add standby logfile group 4 ('/u01/oracle/oradata/ORCLDB/stdby_redo04.log') size 50 M;
Database altered.
SQL> alter database add standby logfile group 5 ('/u01/oracle/oradata/ORCLDB/stdby_redo05.log') size 50 M;
Database altered.
SQL> alter database add standby logfile group 6 ('/u01/oracle/oradata/ORCLDB/stdby_redo06.log') size 50 M;
Database altered.



[Oracle @ dg1 bdump] $ sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Sun Jan 5 01:10:32 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> alter database set standby database to maximize PROTECTION;
Alter database set standby database to maximize PROTECTION
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any instance
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 390070272 bytes
Fixed Size 2021024 bytes
Variable Size 142608736 bytes
Database Buffers 243269632 bytes
Redo Buffers 2170880 bytes
Database mounted.
SQL> alter database set standby database to maximize PROTECTION;
Database altered.
SQL> select PROTECTION_MODE, OPEN_MODE, DB_UNIQUE_NAME, DATABASE_ROLE, SWITCHOVER_STATUS from v $ database;
PROTECTION_MODE OPEN_MODE DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS
------------------------------------------------------------------------------------------------
MAXIMUM PROTECTION MOUNTED WENDING PRIMARY TO STANDBY

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.