查看RMAN 完成情况，百分比
使用以下SQL 查看:
SELECT inst_id,
sid,
serial#,
opname,
ROUND(SOFAR / TOTALWORK * 100, 2) "%_COMPLETE"
FROM gV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
--AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;
INST_ID SID SERIAL# OPNAME %_COMPLETE
---------- ---------- --------------------------------- ----------
1 914 14251 RMAN: incremental datafile backup 73.82
1 3892 36411 RMAN: aggregate input 100
查看RMAN 备份目前开启了哪些进程
使用如下SQL：
SQL> SELECT sid, spid, client_info FROM v$process p, v$session s WHERE p.addr = s.paddr AND client_info LIKE '%rman%';
SID SPID CLIENT_INFO
---------- ------------------------ ----------------------------------------------------------------
2881 56696 rman channel=d8
4033 56654 rman channel=d1
914 56655 rman channel=d2
1682 56656 rman channel=d3
1778 56657 rman channel=d4
1827 56667 rman channel=d5
1875 56668 rman channel=d6
1923 56675 rman channel=d7
8 rows selected.
操作系统层面查看RMAN 备份的进程：
$ ps -ef | grep beq
oracle 16724 1 0 2021 ? 01:06:23 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56649 56576 0 2021 ? 00:00:01 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56653 56576 0 2021 ? 00:00:14 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56654 56576 12 2021 ? 03:25:33 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56655 56576 16 2021 ? 04:25:12 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56656 56576 3 2021 ? 00:50:27 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56657 56576 2 2021 ? 00:35:42 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56667 56576 0 2021 ? 00:08:02 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56668 56576 0 2021 ? 00:03:46 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56675 56576 0 2021 ? 00:02:01 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 56696 56576 0 2021 ? 00:02:48 xxxxx (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
KILL 相应的RMAN 进程即可释放正在进程的RMAN 进程
$kill -9 56655
如果数据量很大，需要等待一下RMAN 备份进程回退
