ORACLE / RMAN - Status

set pages 120
set lines 120
column MEDIA format a10
column STATUS format a10
column OPERACAO format a10

select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;



OPERACAO   TIPO          STATUS     MEDIA DATA                TAMANHO(MB)
---------- ------------- ---------- ----- ------------------- -----------
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 09:17:55       19.87
APE
RMAN                     COMPLETED        04-02-2013 09:17:56       19.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 12:05:11        6.48
APE
RMAN                     COMPLETED        04-02-2013 12:05:11        6.48
LIST       DB FULL       COMPLETED        04-02-2013 18:15:50           0
RMAN                     COMPLETED        04-02-2013 18:22:16           0
LIST       DB FULL       COMPLETED        04-02-2013 18:22:48           0
RMAN                     COMPLETED        04-02-2013 18:27:21           0

---------------------------------------------------////---------------------------------------------------------------


[oracle@Linux ~]$ export NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS"
[oracle@Linux ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 5 07:47:28 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: RM (DBID=2664802127)

RMAN> list backup ;