DBA_BACKUP_PLANS
功能描述
DBA_BACKUP_PLANS系统视图用于记载当前数据库创建的备份计划信息。
字段说明
| 字段名 | 类型 | 说明 |
|---|---|---|
| DB_ID | INTEGER | 库ID |
| PLAN_NAME | CHAR(128) | 备份计划名称 |
| PTYPE | CHAR(16) | 计划类型 |
| START_T | DATETIME | 开始时间 |
| PERIOD | INTERVAL_D2M | 执行周期 |
| ENABLE | BOOLEAN | 是否可用 |
| PATH | CHAR(-1) | 备份路径 |
| CURR_ITEM | INTEGER | 当前项目编号 |
示例
查询备份任务项信息
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