【RMAN】RMAN的动态视图-查看RMAN的备份情况

Published April 20, 2020, 8:06 a.m. by admin

RMAN的动态视图

V$RMAN_BACKUP_JOB_DETAILS

命令如下:

COL STATUS FORMAT a9
COL hrs    FORMAT 999.99
SELECT SESSION_KEY, INPUT_TYPE, STATUS,
       TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,
       TO_CHAR(END_TIME,'mm/dd/yy hh24:mi')   end_time,
       ELAPSED_SECONDS/3600                   hrs
FROM V$RMAN_BACKUP_JOB_DETAILS
ORDER BY SESSION_KEY;

日志如下:

       2473 DB FULL       COMPLETED 01/05/19 02:02 01/05/19 02:08     .10
       2485 ARCHIVELOG    COMPLETED 01/06/19 02:02 01/06/19 02:05     .06
       2496 ARCHIVELOG    COMPLETED 01/07/19 02:02 01/07/19 02:03     .02
       2514 ARCHIVELOG    COMPLETED 01/08/19 02:02 01/08/19 02:02     .01
       2525 ARCHIVELOG    COMPLETED 01/09/19 02:02 01/09/19 02:02     .01
       2536 ARCHIVELOG    COMPLETED 01/10/19 02:02 01/10/19 02:02     .01
       2547 ARCHIVELOG    COMPLETED 01/11/19 02:02 01/11/19 02:02     .01

SESSION_KEY INPUT_TYPE    STATUS    START_TIME     END_TIME           HRS
----------- ------------- --------- -------------- -------------- -------
       2558 DB FULL       COMPLETED 01/12/19 02:02 01/12/19 02:07     .08
       2570 ARCHIVELOG    COMPLETED 01/13/19 02:02 01/13/19 02:02     .00
       2581 ARCHIVELOG    COMPLETED 01/14/19 02:02 01/14/19 02:02     .00

上述可以看到,最近10天里面,1月12日为星期六,做全库备份。其余时间做归档备份.

参考文档

官方文档:

Oracle Database Backup and Recovery User's Guide

-->Reporting on RMAN Operations

---->[Using V$ Views to Query Backup Metadata]

同类文章

【RMAN】REPORT命令

【RMAN】RMAN验证validate命令

【RMAN】某数据库RMAN异机恢复演练,(RAC异地成单实例)

【RMAN】在Oracle11gR2下基于RMAN恢复schema的数据

0 次评论

没有任何评论

添加一条评论