oracle 10g dataguard修改保护模式遭遇ORA-03113

来源：互联网发布：电子小报软件编辑：程序博客网时间：2024/06/05 19:32

环境：oracle 10g dataguard

在primary database上修改为最大保护模式

SQL> startup mount
ORACLE instance started.

Total System Global Area 306184192 bytes
Fixed Size                  1260540 bytes
Variable Size             109052932 bytes
Database Buffers          192937984 bytes
Redo Buffers                2932736 bytes
Database mounted.
SQL> alter database set standby database to maximize protection;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

alert_sid.log中相关错误信息如下：
Wed Dec 17 15:39:11 2014
LGWR: Primary database is in MAXIMUM PROTECTION mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 synchronous standby database required
Wed Dec 17 15:39:11 2014
Errors in file /u01/app/oracle/admin/stb/bdump/stb_lgwr_4070.trc:
ORA-16072: a minimum of one standby database destination is required

stb_lgwr_4070.trc中的主要信息如下：
Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
Standby database verification failed:16072
ORA-16072: a minimum of one standby database destination is required
error 16072 detected in background process
ORA-16072: a minimum of one standby database destination is required

原因：
log_archive_dest_2参数设置不对
SQL> show parameter log_archive_dest_2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=prod lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=prod

上面参数中少了关键字：affirm

SQL> alter system set log_archive_dest_2='service=prod lgwr sync affirm valid_for=(online_logfile,primary_role) db_unique_name=prod';

System altered.

SQL> show parameter log_archive_dest_2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=prod lgwr sync affirm valid_for=(online_logfile,primary_role) db_unique_name=prod

SQL> alter database set standby database to maximize protection;

Database altered.

SQL> alter database open;

Database altered.

SQL> select protection_mode from v$database;

PROTECTION_MODE
--------------------
MAXIMUM PROTECTION

0 0