RMAN从备份到已机恢复

这是原机和目标机的ORACLE安装版本一样，安装路径一样，实例名都是ORACL。下次尝试不同版本的恢复

1.备份

全库备份命令：

run {
    CONFIGURE RETENTION POLICY TO REDUNDANCY = 2;
	CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
	CONFIGURE DEFAULT DEVICE TYPE TO DISK;
	backup as compressed backupset database format 'F:\rman_backup\FULLBAK_%d_%T_%s_%p.DBFILE'; 
	backup current controlfile format 'F:\rman_backup\%d.%s.%p.%T.CTL';
	backup spfile format 'F:\rman_backup\%d.%s.%p.%T.SPFILE';
	crosscheck backup;
	crosscheck copy;
	sql "alter system archive log current";
	backup as COMPRESSED backupset archivelog all not backed up format 'F:\rman_backup\%d.%s.%p.%T.ARC';
	crosscheck archivelog all;
	delete noprompt archivelog all completed before 'sysdate-60';
	delete noprompt expired backup;
	delete noprompt obsolete;
}

2.恢复

shutdown immediate
startup nomount pfile="F:\app\Administrator\admin\orcl\pfile\init.ora.252019115455"
restore controlfile from "E:\oracle_install\rman_bk\ORCL.132.1.20190305.CTL";
alter database mount;
catalog start with "E:\oracle_install\rman_bk";
crosscheck backup;
restore database;
sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
recover database until time '2019-03-05 15:00:00';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: recover 命令 (在 03/05/2019 15:16:18 上) 失败
RMAN-06054: 介质恢复正在请求未知的线程 1 序列 186 的归档日志以及起始 SCN 14623085

执行这里执行报错了，解决方法如下：

run {
set until sequence 186;
recover database;
}

--执行成功，退出rman，启动数据库
exit
sqlplus / as sysdba
alter database open resetlogs;
exit

RMAN> run {
2> set until sequence 186;
3> recover database;
4> }

正在执行命令: SET until clause

启动 recover 于 05-3月 -19
使用通道 ORA_DISK_1
使用通道 ORA_DISK_2
使用通道 ORA_DISK_3
使用通道 ORA_DISK_4
使用通道 ORA_DISK_5
使用通道 ORA_DISK_6

正在开始介质的恢复
介质恢复完成, 用时: 00:00:01

完成 recover 于 05-3月 -19

RMAN> exit

SQL> alter database open resetlogs;

数据库已更改。