ORA-16072: a minimum of one standby ...

查看日志文件相关内容如下：
Errors in file /u01/app/oracle/db10g/rdbms/log/prod_lgwr_26003.trc:
ORA-16072: a minimum of one standby database destination is required
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 26003

原因是虽然在主库初始化文件里删除了DG备库相关的初始化参数，但是忘了修改原来的maximize availability模式，因此主库不让启动。
具体解决办法如下：

[oracle@dbserv1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 1 12:53:48 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  536870912 bytes
Fixed Size                  1220408 bytes
Variable Size             188743880 bytes
Database Buffers          339738624 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> alter database set standby to maximize performance;

Database altered.

SQL> alter database open;

Database altered.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18841027/viewspace-1061780/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18841027/viewspace-1061780/