如果本地没有备份集：1、查找归档信息
select r.sequence#, p.handle from v$backup_piece p, v$backup_redolog r where r.set_stamp = p.set_stamp and r.set_count = p.set_count and r.sequence# = 115908; #自己指定想要查找归档sequence
2、注册备份集
CATALOG backuppiece '/u02/rmanbackup/181113_0215_L1_xxx_1pti31lf_1_1.rbf';
3、从备份片恢复出归档文件
restore archivelog from logseq 31128 until logseq 31129 thread 1; --不加thread默认为1
4、注册归档文件得位置
CATALOG ARCHIVELOG '+FRA/archivelog/arc_ecdbpr_2_xxx.arc';
如果本地有备份集：
-
--1.检查备份归档是否存在
- rman target /
- RMAN > list backup of archivelog sequence between 76437 and 76501 ;
- --2.恢复归档
- RMAN > restore archivelog from sequence 76437 ;
- --3.确认归档恢复到了默认归档位置 --4.重新启动抽取进程
- ./ ggsci
- start ex_xxxx3
- info all
- stats ex_xxxx3
- stats dp_xxxx3
