RMAN备份动态性能视图 V$BACKUP_SET_DETAILS
来源:互联网 发布:爱情电影 知乎 编辑:程序博客网 时间:2024/06/15 22:22
V$BACKUP_SET_DETAILS
provides detailed information about the backup set. This view will contain an extra row for each backup session that invokes BACKUP BACKUPSET (that is, creates new copies for the same backup set or copies backup set information from disk to tape). However, the remaining values of other columns belong to the complete backup set.
SESSION_KEY
NUMBER
Session identifierSESSION_RECID
NUMBER
Identifies the job, together withSESSION_STAMP
.SESSION_STAMP
NUMBER
Identifies the job, together withSESSION_RECID
BS_KEY
NUMBER
Backup set identifierRECID
NUMBER
RECID from V$BACKUP_SET
recordSTAMP
NUMBER
Stamp from V$BACKUP_SET
recordSET_STAMP
NUMBER
Backup set stampSET_COUNT
NUMBER
Backup count numberBACKUP_TYPE
VARCHAR2(1)
Type of backup (same as inV$BACKUP_SET)
CONTROLFILE_INCLUDED
VARCHAR2(3)
Control file included in backup set (same as in V$BACKUP_SET
)INCREMENTAL_LEVEL
NUMBER
Incremental level (same as inV$BACKUP_SET
)PIECES
NUMBER
Number of pieces (same as inV$BACKUP_SET
)START_TIME
DATE
Start time of the backup set (same as in V$BACKUP_SET
)COMPLETION_TIME
DATE
Completion time of the backup set (same as in V$BACKUP_SET
)ELAPSED_SECONDS
NUMBER
Time taken for backup set creation (same as inV$BACKUP_SET
)BLOCK_SIZE
NUMBER
Block size (same as inV$BACKUP_SET
)KEEP
VARCHAR2(3)
Keep value (same as inV$BACKUP_SET
)KEEP_UNTIL
DATE
Keep Until time (same as inV$BACKUP_SET
)KEEP_OPTIONS
VARCHAR2(10)
Keep options (same as inV$BACKUP_SET
)DEVICE_TYPE
VARCHAR2(17)
Type of device. If the backup set exists on more than one device type, an * is indicated here.COMPRESSED
VARCHAR2(3)
YES
, if backup is compressedNUM_COPIES
NUMBER
Number of identical copiesOUTPUT_BYTES
NUMBER
Size of the backup set备份完成后备份集的大小
ORIGINAL_INPUT_BYTES
NUMBER
Amount of data backed up when the backup set was created当备份集创建时备份的大小
COMPRESSION_RATIO
NUMBER
The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the AS COMPRESSED BACKUPSET
clause of the BACKUP
command.字段ORIGINAL_INPUT_BYTES相对OUTPUT_BYTES的倍数
STATUS
CHAR(1)
The status of the backup set. It is always A
(all backup pieces available), because this view only reflects available backup sets.ORIGINAL_INPRATE_BYTES
NUMBER
Number of bytes read per second when backup set was initially created备份时每秒的数据读取(字节)
OUTPUT_RATE_BYTES
NUMBER
Number of bytes written per second when the backup set was initially created备份时每秒的数据写入(字节)
ORIGINAL_INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Input rate to display备份时每秒的数据读取(友好显示)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Size of backup set to display备份集大小(友好显示)
ORIGINAL_INPRATE_BYTES_DISPLAY
VARCHAR2(4000)
Input rate per second for display备份时每秒的数据读取(友好显示)
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
Output rate per second for display每秒数据写入(友好显示)
TIME_TAKEN_DISPLAY
VARCHAR2(4000)
Elapsed time in hh:mm:ss format花费时间显示
ENCRYPTED
VARCHAR2(3)
A value of YES
means an encrypted backup, otherwise not an encrypted backup.是否加密
BACKED_BY_OSB
VARCHAR2(3)
A value of YES
means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library. 0 0
- RMAN备份动态性能视图 V$BACKUP_SET_DETAILS
- RMAN备份动态性能视图 V$BACKUP_SET
- RMAN备份动态性能视图 V$BACKUP_PIECE
- RMAN备份动态性能视图 V$BACKUP_SET_SUMMARY
- RMAN备份动态性能视图 V$BACKUP_CORRUPTION
- RMAN备份动态性能视图 V$ARCHIVED_LOG
- RMAN 动态性能视图
- RMAN备份相关的动态性能视图及监控
- 与rman备份有关的几个动态性能视图
- 动态性能视图:V$FILESTAT
- oracle-动态性能(V$)视图
- oracle 动态性能(V$)视图
- 动态性能视图 V$SESSION_LONGOPS
- RMAN相关动态性能视图及监控
- 动态性能视图v$mystat,v$sesstat,v…
- 动态性能视图v$mystat,v$sesstat,v…
- RMAN备份相关的动态性能表
- 【转】oracle 动态性能(V$)视图
- 简单的java通信工具类
- iOS网络编程TCP/IP应用篇(五)-发送数据及其它(加密,重连)
- 缩放Fresco图片
- 图片压缩
- Windows下启动eclipse出现JRE or JDK must be available in order to run Eclipse.No Java virtual machine was
- RMAN备份动态性能视图 V$BACKUP_SET_DETAILS
- hive 基本操作
- windows 多版本JDK并存方案
- java 使用的json工具类
- LOG4J配置详解及样例一个
- Mockito
- 前端做好页面后后端拿到手配置的问题
- uva-531 Compromise
- mysql 数据表中查找重复记录