ORA-16072: a minimum of onestandby database destination is required

Thu Nov 13 10:13:21 2014

ARC1 started with pid=22, OSid=26953

LGWR (ospid: 26870):terminating the instance due to error 16072

Thu Nov 13 10:13:21 2014

System statedump requested by (instance=1, osid=26870 (LGWR)), summary=[abnormal instancetermination].

System Statedumped to trace file/u01/oracle/diag/rdbms/ntracdb/ntracdb/trace/ntracdb_diag_26846_20141113101321.trc

Dumpingdiagnostic data in directory=[cdmp_20141113101321], requested by (instance=1,osid=26870 (LGWR)), summary=[abnormal instance termination].

Instanceterminated by LGWR, pid = 26870

原因：

可能是控制文件备份时失败所致

解决办法：

重建控制文件，然后再打开数据库

STARTUP NOMOUNT

CREATE CONTROLFILE REUSEDATABASE "ntracdb" NORESETLOGS FORCE LOGGING ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 9344

LOGFILE

GROUP 1'/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_1_b682j5nk_.log' SIZE 200M,

GROUP 2 '/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_2_b682j7gw_.log' SIZE 200M,

GROUP 3'/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_3_b682j98k_.log' SIZE 200M,

GROUP 4'/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_4_b682jc2t_.log' SIZE 200M

-- STANDBY LOGFILE

DATAFILE

'/u01/oracle/oradata/ntracdb/users.295.855410331',

'/u01/oracle/oradata/ntracdb/undotbs1.263.855410331',

'/u01/oracle/oradata/ntracdb/sysaux.264.855410331',

'/u01/oracle/oradata/ntracdb/system.265.855410331',

'/u01/oracle/oradata/ntracdb/undotbs2.293.855410453',

'/u01/oracle/oradata/ntracdb/undotbs3.292.855410453',

'/u01/oracle/oradata/ntracdb/sysaux.257.857772301',

'/u01/oracle/oradata/ntracdb/strategy.256.858008275',

'/u01/oracle/oradata/ntracdb/strategy.302.858008423'

CHARACTER SET ZHS16GBK;

SQL> RECOVER DATABASE;

ORA-00283: 恢复会话因错误而取消

ORA-00264: 不要求恢复

--此时可以正常打开数据库

SQL> alter database open;

数据库已更改。

#创建临时表空间

CREATE TEMPORARY TABLESPACE temp TEMPFILE'/u01/oracle/oradata/ntracdb/temp01.dbf'

SIZE 20M REUSE

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;