DBA_BACKUP_PLANS

📄字数 516

👁️阅读量 加载中...

功能描述

DBA_BACKUP_PLANS系统视图用于记载当前数据库创建的备份计划信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	PLAN_NAME	VARCHAR	备份计划名称	√	√
2	PTYPE	VARCHAR	计划类型	√	√
3	START_T	DATETIME	开始时间	√	√
4	PERIOD	INTERVAL DAY TO MINUTE	执行周期	√	√
5	ENABLE	BOOLEAN	是否可用	√	√
6	PATH	VARCHAR	备份路径	√	√
7	CURR_ITEM	INTEGER	当前项目编号	√	√

注意

• 活动计划不可删除
• job删除不在备份系统包功能范围内

应用举例

• 查询备份计划信息

-- 创建备份计划
SQL> EXEC DBMS_BACKUP.CREATE_PLAN('backup_info','bak','/BACKUP',sysdate,'00 05:00'); 

SQL> SELECT * FROM DBA_BACKUP_PLANS WHERE plan_name='BACKUP_INFO';
+-------+-------------+-------+--------------------------+---------------+--------+---------+-----------+
| DB_ID |  PLAN_NAME  | PTYPE |         START_T          |    PERIOD     | ENABLE |  PATH   | CURR_ITEM |
+-------+-------------+-------+--------------------------+---------------+--------+---------+-----------+
| 1     | backup_info | BAK   | 2025-06-27 13:58:49.292  |      10 00:00 | F      | /BACKUP | 1         |
+-------+-------------+-------+--------------------------+---------------+--------+---------+-----------+

相关系统表

• SYS_BACKUP_ITEMS
• SYS_BACKUP_PLANS