查询rman备份状态主要是通过视图V$RMAN_STATUS来进行，这个视图可以让你看见你在RMAN里面执行的操作。在V$RMAN_STATUS中，最主要的列是OPERATION和status。

Operation的值有rman、backup、list、report。

Status的值有running、running with warnings、running with errors、completed、completed with warnings、completed with errors、failed等几种状态。

如果要查看RMAN的输出，可以查看V$RMAN_OUTPUT。V$RMAN_OUTPUT视图记录了RMAN生成的信息，这是在内存中的视图，不会记录到控制文件上。最多有37278条记录。

还可以从V$RMAN_BACKUP_JOB_DETAILS中查看RMAN备份更详细的信息。

查看备份失败的记录：

SELECT *

FROM V$RMAN_STATUS

WHERE

START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')

AND END_TIME

<= TO_DATE(&END_TIME

,'YYYY-MM-DD HH24:MI:SS')

AND OPERATION ='BACKUP'

AND STATUS !='COMPLETED'

AND STATUS NOT LIKE 'RUNNING%';

查看备份成功的记录：

SELECT *

FROM V$RMAN_STATUS

WHERE

START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')

AND END_TIME

<= TO_DATE(&END_TIME

,'YYYY-MM-DD HH24:MI:SS')

AND OPERATION ='BACKUP'

AND STATUS ='COMPLETED';

查看所有备份集详细信息：

SELECT

A.RECID "BACKUP SET",

A.SET_STAMP,

DECODE (B.INCREMENTAL_LEVEL,

'', DECODE (BACKUP_TYPE, 'L',

'Archivelog', 'Full'),

1, 'Incr-1级',

0, 'Incr-0级',

B.INCREMENTAL_LEVEL)

"Type LV",

B.CONTROLFILE_INCLUDED "包含CTL",

DECODE (A.STATUS,

'A', 'AVAILABLE',

'D', 'DELETED',

'X', 'EXPIRED',

'ERROR')

"STATUS",

A.DEVICE_TYPE "Device Type",

A.START_TIME "Start Time",

A.COMPLETION_TIME "Completion Time",

A.ELAPSED_SECONDS "Elapsed

Seconds",

A.BYTES/1024/1024/1024

"Size(G)",

A.COMPRESSED,

A.TAG "Tag",

A.HANDLE "Path"

FROM GV$BACKUP_PIECE A, GV$BACKUP_SET B

WHERE A.SET_STAMP = B.SET_STAMP AND A.DELETED

= 'NO'

ORDER BY

A.COMPLETION_TIME DESC;

查找某个备份集中包含数据文件

SELECT

DISTINCT c.file#,A.SET_STAMP, D.NAME, C.CHECKPOINT_CHANGE#, C.CHECKPOINT_TIME

FROM

V$BACKUP_DATAFILE C, V$BACKUP_PIECE A, V$DATAFILE D

WHERE

A.SET_STAMP = C.SET_STAMP

AND D.FILE# = C.FILE#

AND A.DELETED='NO'

AND c.set_stamp=&set_stamp

ORDER BY C.FILE#;

查询某个备份集中控制文件

SELECT

DISTINCT A.SET_STAMP,

D.NAME,

C.CHECKPOINT_CHANGE#,

C.CHECKPOINT_TIME

FROM V$BACKUP_DATAFILE C, V$BACKUP_PIECE A,

V$CONTROLFILE D

WHERE A.SET_STAMP = C.SET_STAMP

AND C.FILE# = 0

AND A.DELETED = 'NO'

AND C.SET_STAMP = &SET_STAMP;

查看某个备份集中归档日志:

SELECT

DISTINCT B.SET_STAMP,

B.THREAD#,

B.SEQUENCE#,

B.FIRST_TIME,

B.FIRST_CHANGE#,

B.NEXT_TIME,

B.NEXT_CHANGE#

FROM V$BACKUP_REDOLOG B, V$BACKUP_PIECE A

WHERE A.SET_STAMP = B.SET_STAMP

AND A.DELETED = 'NO'

AND B.SET_STAMP = &SET_STAMP

ORDER BY THREAD#, SEQUENCE#;

查看某个备份集SPFILE

SELECT

DISTINCT A.SET_STAMP, B.COMPLETION_TIME, HANDLE

FROM

V$BACKUP_SPFILE B, V$BACKUP_PIECE A

WHERE A.SET_STAMP = B.SET_STAMP

AND A.DELETED = 'NO'

AND B.SET_STAMP = &SET_STAMP;

查看RMAN的配置信息

SELECT

NAME,VALUE FROM V$RMAN_CONFIGURATION;