DBA_BACKUP_ITEMS

📄字数 765

👁️阅读量 加载中...

功能描述

DBA_BACKUP_ITEMS系统视图用于记载当前数据库创建的备份计划执行的备份任务项信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	PLAN_NAME	VARCHAR	备份计划名称	√	√
2	ITEM_NO	INTEGER	项目编号	√	√
3	OBJ_NAME	VARCHAR	对象名	√	√
4	OBJ_TYPE	VARCHAR	对象类型	√	√
5	OP_TYPE	VARCHAR	操作类型	√	√
6	FILE_NAME	VARCHAR	备份文件名	√	√
7	FILE_OP	VARCHAR	备份文件处理方式	√	√
8	FILE_KEEP_CNT	INTEGER	文件保留数	√	√
9	FILE_MOVE_PATH	VARCHAR	MOVE类型的目标路径	√	√
10	TIME_OFF	INTERVAL_D2M	相对于计划开始时间的时间偏移	√	√
11	NEXT_RUN_T	DATETIME	下次运行时间	√	√
12	IPERIOD	INTERVAL_D2M	计划执行周期	√	√
13	ISTART_T	DATETIME	子项目开始时间	√	√

应用举例

• 查询备份任务项信息

-- 创建备份计划
EXEC DBMS_BACKUP.CREATE_PLAN('backup_info', 'BAK','/BACKUP',SYSDATE,'10');

-- 添加备份任务项
SQL> EXEC DBMS_BACKUP.ADD_BACKUP_ITEM('backup_info','sysbak.bak','00 00:00');

-- 查询备份任务信息
SQL>  SELECT * FROM DBA_BACKUP_ITEMS;
+-------+-------------+---------+----------+----------+---------+------------+---------+---------------+----------------+---------------+--------------------------+---------+----------+
| DB_ID |  PLAN_NAME  | ITEM_NO | OBJ_NAME | OBJ_TYPE | OP_TYPE | FILE_NAME  | FILE_OP | FILE_KEEP_CNT | FILE_MOVE_PATH |   TIME_OFF    |        NEXT_RUN_T        | IPERIOD | ISTART_T |
+-------+-------------+---------+----------+----------+---------+------------+---------+---------------+----------------+---------------+--------------------------+---------+----------+
| 1     | backup_info | 1       | SYSTEM   | SYSTEM   | BACKUP  | sysbak.bak | <NULL>  | 0             | <NULL>         |       0 00:00 | 2025-06-27 13:58:49.292  | <NULL>  | <NULL>   |
+-------+-------------+---------+----------+----------+---------+------------+---------+---------------+----------------+---------------+--------------------------+---------+----------+

相关系统表

• SYS_BACKUP_ITEMS
• SYS_BACKUP_PLANS