环境: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