RMAN Commands

List of the backup controlfile
#################################

list backup of controlfile;


list backup of controlfile completed between "to_date('04/17/2015','mm/dd/yyyy')" and "to_date('04/20/2015','mm/dd/yyyy')";

List of the backup
######################

list backup;

list archivelog all;


list backup of archivelog time between "to_date('02-JAN-2009 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('03-JAN-2009 00:00:00','DD-MON-YYYY HH24:MI:SS')"

list backup of database completed between "to_date('04/17/2015','mm/dd/yyyy')" and "to_date('04/18/2015','mm/dd/yyyy')";



snapshot controlfile
############################

show snapshot controlfile name;

This will delete all the archive log before SYSDATE-2
######################################################

delete noprompt force archivelog until time 'SYSDATE-2';

Rman config
#############

show all;