问题：
这是一个从rac环境的数据库的ramn备份恢复到一个单机数据库的操作。当恢复数据文件和恢复正常，，但在open数据库时出报下面的错误。
--rman备份恢复操作
#创建参数文件
cd $oracle_home/dbs
$cat initntracdb.ora
*.archive_lag_target=0
*.compatible='11.2.0.4.0'
*.control_files='/u01/oracle/oradata/ntracdb/controlfile1.dbf','/u01/oracle/oradata/ntracdb/controlfile2.dbf'
*.db_block_size=8192
*.db_create_file_dest='/u01/oracle/oradata/ntracdb'
*.db_name='ntracdb'
*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=299000m
*.db_unique_name='ntracdb'
*.dg_broker_start=true
*.local_listener='(address=(protocol=tcp)(host=nticket3)(port=1521))'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
*.log_file_name_convert='null','null'
*.nls_language='simplifiedchinese'
*.nls_territory='china'
*.open_cursors=300
*.pga_aggregate_target=429496729
*.processes=600
*.remote_login_passwordfile='exclusive'
*.sga_max_size=3435973836
*.sga_target=3221225472
*.standby_file_management='auto'
*.undo_tablespace='undotbs1'
rman target /
startup nomount;
restore controlfile from'/home/oracle/rmanbak/ncnnf0_tag20141110t011010_0.1205.863228449'; --首先恢复控制文件
alter database mount;
catalog start with'/home/oracle/rmanbak/'; --批量登记拷过来的rman备份，假设拷过来的备份放到了/u01/rmanbak/目录
list backup; --查看要恢复的是不是这个备份文件
run {
set newname for datafile'+data01/ntracdb/datafile/users.295.855410331' to'/u01/oracle/oradata/ntracdb/users.295.855410331';
set newname for datafile'+data01/ntracdb/datafile/undotbs1.263.855410331' to'/u01/oracle/oradata/ntracdb/undotbs1.263.855410331';
set newname for datafile'+data01/ntracdb/datafile/sysaux.264.855410331' to'/u01/oracle/oradata/ntracdb/sysaux.264.855410331';
set newname for datafile'+data01/ntracdb/datafile/system.265.855410331' to'/u01/oracle/oradata/ntracdb/system.265.855410331';
set newname for datafile'+data01/ntracdb/datafile/undotbs2.293.855410453' to'/u01/oracle/oradata/ntracdb/undotbs2.293.855410453';
set newname for datafile'+data01/ntracdb/datafile/undotbs3.292.855410453' to'/u01/oracle/oradata/ntracdb/undotbs3.292.855410453';
set newname for datafile'+data01/ntracdb/datafile/sysaux.257.857772301' to '/u01/oracle/oradata/ntracdb/sysaux.257.857772301';
set newname for datafile'+data01/ntracdb/datafile/strategy.256.858008275' to'/u01/oracle/oradata/ntracdb/strategy.256.858008275'
restore database;
switch datafile all;
recover database;
}
--打开数据库时报错
$sqlplus / as sysdba
sql> alter database open;
alter database open
*
第 1 行出现错误
ora-03113：通信通道的文件结尾
进程 id ：6988
回话 id：191 序列号：3
--查看日志
thu nov 13 10:13:20 2014
alter database open
data guard brokerinitializing...
data guard brokerinitialization complete
data guard: verifying databaseprimary role...
thu nov 13 10:13:20 2014
lgwr: starting arch processes
thu nov 13 10:13:20 2014
arc0 started with pid=21, osid=26949
arc0: archival started
lgwr: starting arch processescomplete
arc0: starting arch processes
lgwr: primary database is inmaximum availability mode
lgwr: destinationlog_archive_dest_1 is not serviced by lgwr
lgwr: minimum of 1 lgwr standbydatabase required
errors in file/u01/oracle/diag/rdbms/ntracdb/ntracdb/trace/ntracdb_lgwr_26870.trc:
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;
--------------------------------------推荐阅读 --------------------------------------
rman 配置归档日志删除策略
oracle基础教程之通过rman复制数据库
rman备份策略制定参考内容
rman备份学习笔记
oracle数据库备份加密 rman加密
--------------------------------------分割线 --------------------------------------
本文永久更新链接地址：