oracle备份信息查询

最新推荐文章于 2025-01-10 11:42:11 发布

转载最新推荐文章于 2025-01-10 11:42:11 发布 · 427 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ss-33/p/8707003.html

文章标签：

#数据库

SELECT TRIM(START_TIME || '#'),
       TRIM(END_TIME || '#'),
       TRIM(CASE OUTPUT_DEVICE_TYPE
              WHEN 'DISK' THEN
               'DISK'
              WHEN 'SBT_TAPE' THEN
               'SBT_TAPE'
              ELSE
               'Others'
            END || '#') AS BACKUP_DEVICE,
       TRIM(STATUS || '#'),
       TRIM(CASE INPUT_TYPE
              WHEN 'DB FULL' THEN
               'DB_FULL'
              WHEN 'DB INCR' THEN
               'DB_INCR'
              WHEN 'ARCHIVELOG' THEN
               'DB_ARCH'
              ELSE
               'Others'
            END || '#') AS BACKUP_TYPE,
       TRIM(ROUND(ELAPSED_SECONDS / 60 / 60, 2) || '#') AS T,
       TRIM(OUTPUT_BYTES_DISPLAY || '#') AS DB_SIZE
FROM V$RMAN_BACKUP_JOB_DETAILS
WHERE START_TIME = (SELECT MAX(START_TIME) FROM V$RMAN_BACKUP_JOB_DETAILS);