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;