检查数据库当前是否有备份操作在执行中

Question

如题所述

Answer 1

这个要分单实例还是rac 数据库这两种情况
sys@RAC> SELECT DECODE(os_backup.backup + rman_backup.backup, 0, 'FALSE', 'TRUE') backup
2 FROM (SELECT COUNT(*) backup FROM gv$backup WHERE status = 'ACTIVE') os_backup,
3 (SELECT COUNT(*) backup
4 FROM gv$session
5 WHERE status = 'ACTIVE'
6 AND client_info like '%rman%') rman_backup
7 /

BACKU
-----
TRUE