个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2023-10-27 19:05:34
先来个清日志脚本镇场
db version 12.1.0.1 to 21.6
参考：2850185.1
-
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
给主人留下些什么吧！~~