在恢复一套RAC数据库到异机单实例，在RESETLOGS模式打开数据库时，遇到ORA-03113错误：

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 5691
Session ID: 3970 Serial number: 167

检查告警日志发现，是由于DG设置最大可用模式导致的。

ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Wed Jul 15 23:57:14 2015
ARC0 started with pid=23, OS id=5777 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 LGWR standby database required
Errors in file /u01/app/oracle/diag/rdbms/ivldb/uatdb/trace/uatdb_lgwr_5751.trc:
ORA-16072: a minimum of one standby database destination is required
Wed Jul 15 23:57:15 2015
ARC1 started with pid=22, OS id=5779 
LGWR (ospid: 5751): terminating the instance due to error 16072
System state dump requested by (instance=1, osid=5751 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/ivldb/uatdb/trace/uatdb_diag_5737_20150715235715.trc
Dumping diagnostic data in directory=[cdmp_20150715235715], requested by (instance=1, osid=5751 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 5751

最大可用和最大保护模式对备库的依赖性较高，我这是在使用生产数据库恢复UAT测试环境，根本没有DG，也不需要DG，那么只需要将保护模式修改为最大性能即可。

SQL> startup mount
ORACLE instance started.
Total System Global Area 1.2727E+10 bytes
Fixed Size                  2265096 bytes
Variable Size            7885295608 bytes
Database Buffers         4831838208 bytes
Redo Buffers                7757824 bytes
Database mounted.
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE    PROTECTION_MODE      PROTECTION_LEVEL
PRIMARY          MAXIMUM AVAILABILITY UNPROTECTED
SQL> alter database set standby to maximize performance;
Database altered.
SQL> alter database open;
Database altered.

本文固定链接: http://www.dbdream.com.cn/2015/07/ora-03113%e5%8f%8aora-16072-a-minimum-of-one-standby-database-destination-is-required%e5%af%bc%e8%87%b4%e6%95%b0%e6%8d%ae%e5%ba%93%e6%97%a0%e6%b3%95open/ | 信春哥，系统稳，闭眼上线不回滚！