recover from service 修复备库gap

先来个清日志脚本镇场

SQL> begin
for log_cur in ( select group# group_no from v$log )
loop
execute immediate 'alter database clear logfile group '||log_cur.group_no;
end loop;
end;
/

SQL> begin
for log_cur in ( select group# group_no from v$standby_log )
loop
execute immediate 'alter database clear logfile group '||log_cur.group_no;
end loop;
end;
/

DB Version 12.1.0.1 to 21.6 

备库上

$ rman target /

RMAN > run {
allocate channel c1 type disk connect '/@';
allocate channel c2 type disk connect '/@';
allocate channel c3 type disk connect '/@';
allocate channel c4 type disk connect '/@';
allocate channel c5 type disk connect '/@';
allocate channel c6 type disk connect '/@';
allocate channel c7 type disk connect '/@';
allocate channel c8 type disk connect '/@';
recover database from service 'TS_PRI' section size 32G;
}

观察进度
select INST_ID,SID,SERIAL#,OPNAME, round((sofar/totalwork)*100,2) as "%complete",
 ELAPSED_SECONDS, TIME_REMAINING
from gv$session_longops
where sofar<>totalwork and totalwork<>0
and SID||SERIAL# in (select SID||SERIAL# from v$session);

参考：2850185.1