oracle恢复失败,RMAN数据库恢复失败解决一例

问题&＃xff1a;

这是一个从RAC环境的数据库的RAMN备份恢复到一个单机数据库的操作。当恢复数据文件和恢复正常&＃xff0c;但在open数据库时出报下面的错误。

--rman备份恢复操作

#创建参数文件

cd $Oracle_HOME/dbs

$cat initntracdb.ora

*.archive_lag_target&＃61;0

*.compatible&＃61;&＃39;11.2.0.4.0&＃39;

*.control_files&＃61;&＃39;/u01/oracle/oradata/ntracdb/controlfile1.dbf&＃39;,&＃39;/u01/oracle/oradata/ntracdb/controlfile2.dbf&＃39;

*.db_block_size&＃61;8192

*.db_create_file_dest&＃61;&＃39;/u01/oracle/oradata/ntracdb&＃39;

*.db_name&＃61;&＃39;ntracdb&＃39;

*.db_recovery_file_dest&＃61;&＃39;/u01/oracle/fast_recovery_area&＃39;

*.db_recovery_file_dest_size&＃61;299000M

*.db_unique_name&＃61;&＃39;ntracdb&＃39;

*.dg_broker_start&＃61;true

*.local_listener&＃61;&＃39;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;nticket3)(PORT&＃61;1521))&＃39;

*.log_archive_format&＃61;&＃39;%t_%s_%r.dbf&＃39;

*.log_archive_max_processes&＃61;4

*.log_archive_min_succeed_dest&＃61;1

*.log_archive_trace&＃61;0

*.log_file_name_convert&＃61;&＃39;null&＃39;,&＃39;null&＃39;

*.nls_language&＃61;&＃39;SIMPLIFIEDCHINESE&＃39;

*.nls_territory&＃61;&＃39;CHINA&＃39;

*.open_cursors&＃61;300

*.pga_aggregate_target&＃61;429496729

*.processes&＃61;600

*.remote_login_passwordfile&＃61;&＃39;exclusive&＃39;

*.sga_max_size&＃61;3435973836

*.sga_target&＃61;3221225472

*.standby_file_management&＃61;&＃39;auto&＃39;

*.undo_tablespace&＃61;&＃39;UNDOTBS1&＃39;

rman target /

startup nomount;

restore controlfile from&＃39;/home/oracle/rmanbak/ncnnf0_TAG20141110T011010_0.1205.863228449&＃39;;  --首先恢复控制文件

alter database mount;

catalog start with&＃39;/home/oracle/rmanbak/&＃39;;  --批量登记拷过来的rman备份&＃xff0c;假设拷过来的备份放到了/u01/rmanbak/目录

list backup;  --查看要恢复的是不是这个备份文件

run {

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/users.295.855410331&＃39; to&＃39;/u01/oracle/oradata/ntracdb/users.295.855410331&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/undotbs1.263.855410331&＃39; to&＃39;/u01/oracle/oradata/ntracdb/undotbs1.263.855410331&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/sysaux.264.855410331&＃39; to&＃39;/u01/oracle/oradata/ntracdb/sysaux.264.855410331&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/system.265.855410331&＃39; to&＃39;/u01/oracle/oradata/ntracdb/system.265.855410331&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/undotbs2.293.855410453&＃39; to&＃39;/u01/oracle/oradata/ntracdb/undotbs2.293.855410453&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/undotbs3.292.855410453&＃39; to&＃39;/u01/oracle/oradata/ntracdb/undotbs3.292.855410453&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/sysaux.257.857772301&＃39; to &＃39;/u01/oracle/oradata/ntracdb/sysaux.257.857772301&＃39;;

set newname for datafile&＃39;&＃43;DATA01/ntracdb/datafile/strategy.256.858008275&＃39; to&＃39;/u01/oracle/oradata/ntracdb/strategy.256.858008275&＃39;

restore database;

switch datafile all;

recover database;

}

--打开数据库时报错

$sqlplus / as sysdba

SQL> alter database open;

alter database open

*

第 1 行出现错误

ORA-03113&＃xff1a;通信通道的文件结尾

进程 ID &＃xff1a;6988

回话 ID&＃xff1a;191 序列号&＃xff1a;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&＃61;21, OSid&＃61;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&＃61;22, OSid&＃61;26953

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

Thu Nov 13 10:13:21 2014

System statedump requested by (instance&＃61;1, osid&＃61;26870 (LGWR)), summary&＃61;[abnormal instancetermination].

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

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

Instanceterminated by LGWR, pid &＃61; 26870

原因&＃xff1a;

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

解决办法&＃xff1a;

重建控制文件&＃xff0c;然后再打开数据库

STARTUP NOMOUNT

CREATE CONTROLFILE REUSEDATABASE "ntracdb" NORESETLOGS FORCE LOGGING ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 9344

LOGFILE

GROUP 1&＃39;/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_1_b682j5nk_.log&＃39;  SIZE 200M,

GROUP 2 &＃39;/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_2_b682j7gw_.log&＃39;  SIZE 200M,

GROUP 3&＃39;/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_3_b682j98k_.log&＃39;  SIZE 200M,

GROUP 4&＃39;/u01/oracle/oradata/ntracdb/NTRACDB/onlinelog/o1_mf_4_b682jc2t_.log&＃39;  SIZE 200M

-- STANDBY LOGFILE

DATAFILE

&＃39;/u01/oracle/oradata/ntracdb/users.295.855410331&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/undotbs1.263.855410331&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/sysaux.264.855410331&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/system.265.855410331&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/undotbs2.293.855410453&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/undotbs3.292.855410453&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/sysaux.257.857772301&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/strategy.256.858008275&＃39;,

&＃39;/u01/oracle/oradata/ntracdb/strategy.302.858008423&＃39;

CHARACTER SET ZHS16GBK;

SQL> RECOVER DATABASE;

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

ORA-00264: 不要求恢复

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

SQL> alter database open;

数据库已更改。

#创建临时表空间

CREATE TEMPORARY TABLESPACE temp TEMPFILE&＃39;/u01/oracle/oradata/ntracdb/temp01.dbf&＃39;

SIZE 20M REUSE

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;

--------------------------------------推荐阅读 --------------------------------------

--------------------------------------分割线 --------------------------------------