SOME USEFUL RMAN COMMANDS AND STATEMENTS

1. How to list backup of database done in particular time

RMAN>list backup of archivelog all completed after '30-SEP-11';

RMAN>list backup of database completed after '30-SEP-11';

Here in place of after you can also give 'before' or 'between startdate and enddate'

2.How to list archive logs generated in particular time interval
  Suppose i want to find out that on 5-nov-11 how many archive logs are generated between noon 12 to evening 6 o'clock

select name,completion_time,to_char(completion_time,'hh24:mi') as time from v$archived_log where to_char(completion_time)='05-NOV-11' and to_char(completion_time,'hh24:mi') between '12:00' and '18:00'

3.Check RMAN Backup Status
Run these queries on database not in catalog

Report on all backups – full, incremental and archivelog backups -
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;


Report all on full and incremental backups, not archivelog backups -
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
where input_type='DB INCR'
order by session_key;