-
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;
- /
-
备库上
-
-
$ 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