Skip to content

DBA_BACKUP_PLANS

功能描述

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

字段说明

字段名类型说明
DB_IDINTEGER库ID
PLAN_NAMECHAR(128)备份计划名称
PTYPECHAR(16)计划类型
START_TDATETIME开始时间
PERIODINTERVAL_D2M执行周期
ENABLEBOOLEAN是否可用
PATHCHAR(-1)备份路径
CURR_ITEMINTEGER当前项目编号

示例

查询备份任务项信息

sql
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 | 2022-05-11 14:55:03.404 AD | <NULL>| <NULL>|

相关系统视图

  • dba_users
  • dba_databases
  • dba_backup_plans