2011年9月29日

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

mac

Author

1 min

Read Time

Views

以下脚本可以用于检测数据库当前是否有备份操作在执行中:

SELECT DECODE(os_backup.backup + rman_backup.backup, 0, 'FALSE', 'TRUE') backup
  FROM (SELECT COUNT(*) backup FROM gv$backup WHERE status = 'ACTIVE') os_backup,
       (SELECT COUNT(*) backup
          FROM gv$session
         WHERE status = 'ACTIVE'
           AND client_info like '%rman%') rman_backup
/

北

北在南方 2011-09-30

我测试了一下：一个窗口执行rman 备份，另一个窗口查看 sys@RAC> SELECT DECODE(os_backup.backup + rman_backup.backup, 0, 'FALSE', 'TRUE') backup 2 FROM (SELECT COUNT(*) backup FROM v$backup WHERE status = 'ACTIVE') os_backup, 3 (SELECT COUNT(*) backup 4 FROM v$session 5 WHERE status = 'ACTIVE' 6 AND client_info like '%id=rman%') rman_backup 7 / BACKU ----- FALSE

admin 2011-09-30

你好脚本已经修改过了.

北

北在南方 2011-09-30

看来是要分单实例还是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

Oracle数据恢复专题 – ORACLE数据库数据恢复、性能优化、故障诊断来问问MACLEAN 2013-12-14

[…] Script:检查数据库当前是否有备份操作在执行中 […]

Oracleデータリカバリ – Oracle数据库数据恢复、性能优化来问问AskMaclean – 诗檀软件旗下网站 2016-01-15

[…] Script:データベースにバックアップしているかを確認してください […]

评论 (4)