版本11.2.0.1=>11.2.0.4
平台CentOS5.9=>redhat6.4
export ORACLE_SID=ORCL

rman
startup nomount

首先恢复pfile；
restore spfile from ‘/sadfasdf/asdfasdf’;
之后恢复control
restore controlfile from ‘/sadfasdf/asdfasdf’;
指定备份片位置
catalog start with ‘/asdfasdf/asdfasdf’
检查备份有效性
crosscheck backup;
删除无效的备份片
delete expired backup;

检查归档有效性
crosscheck archivelog all;
删除无效的归档
delete expired archivelog all;
恢复文件
run{
SET newname FOR DATAFILE 1 TO ‘/oradata2/ORCL/datafile/system.256.819216263’;
SET newname FOR DATAFILE 2 TO ‘/oradata2/ORCL/datafile/sysaux.257.819216265’;
SET newname FOR DATAFILE 3 TO ‘/oradata2/ORCL/datafile/undotbs1.258.819216265’;
SET newname FOR DATAFILE 4 TO ‘/oradata2/ORCL/datafile/users.259.819216265’;
SET newname FOR DATAFILE 5 TO ‘/oradata2/ORCL/datafile/undotbs2.267.819216517’;
SET newname FOR DATAFILE 6 TO ‘/oradata2/ORCL/datafile/data01.dbf’;
SET newname FOR DATAFILE 7 TO ‘/oradata2/ORCL/datafile/users01.dbf’;
SET newname FOR DATAFILE 8 TO ‘/oradata2/ORCL/datafile/index01.dbf’;
restore database ;
switch datafile all;
}

移动redo

SELECT  ‘ALTER DATABASE RENAME FILE ‘||chr(39)||MEMBER||CHR(39)||’ TO ‘||CHR(39)||REPLACE( MEMBER,’+DATA/zyhlj’,’/oradata2/ORCL’ )||CHR(39)||’;’ FROM  v$logfile;

还原archivelog

restore archivelog from sequence 8549 thread 1 until sequence 8568 thread 1;–sequence 从备份片中找到

restore archivelog from sequence 8549 thread 2 until sequence 8568 thread 2;–sequence 从备份片中找到

recover database using backup controlfile until cancel;

alter database open resetlogs;

shut immediate;

startup upgrade;

@?/rdbms/admin/catupgrd.sql