List RMAN backup

LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
LIST BACKUP SUMMARY;
LIST BACKUP;
LIST BACKUP BY FILE;
LIST COPY;
LIST INCARNATION;
LIST FAILURE ALL;
list copy of database archivelog all;
list backup of tablespace SYSTEM;

 rman target / catalog rman/rman@rcat log '/oracle/log/mlog.f'

To restrict by object, use list copy or list backup with the of listObjList condition. For example, enter:

list backup of database;     # lists backups of all files in database
list copy of datafile '/oracle/dbs/tbs_1.f'; # lists copy of specified datafile
list backup of tablespace SYSTEM; # lists all backups of SYSTEM tablespace
list copy of archivelog all;  # lists all archived redo logs and copies of logs
list backup of controlfile; # lists all control file backups


 You can also restrict your search by specifying a combination of tag, device type, filename pattern, or time options. For example, enter:

list backup tag 'weekly_full_db_backup';    # by tag
list copy of datafile '/oracle/dbs/tbs_1.f' type 'sbt_tape';   # by type
list backup like '/oracle/backup/tbs_4%';    # by filename pattern
list backup of archivelog until time 'SYSDATE-30';   # by time
list copy of datafile 2 completed between '10-DEC-1998' and '17-DEC-1998'; # by tim


# must allocate maintenance channel for crosscheck
allocate channel for maintenance type disk;
crosscheck backup;  # crosschecks all backups
change datafile copy 100,101,102,103,104,105,106,107 crosscheck; # specified by key
change archivelog copy 50,51,52,53,54 crosscheck;  # specified by key
release channel;
   


report need backup days = 7 database;  # needs at least 7 days of logs to recover
report need backup days = 30 tablespace system;
report need backup days = 14 datafile '/oracle/dbs/tbs_5.f';

report need backup incremental = 1 database;
report need backup incremental = 3 tablespace system;
report need backup incremental = 5 datafile '/oracle/dbs/tbs_5.f';


report schema at time 'SYSDATE-14';
report schema at scn 1000;
report schema at logseq 100;
   

list backup of tablespace tbs_1 completed before 'Nov 1 1998 00:00:00';

list backup of database device type 'sbt_tap
list copy of datafile 2 tag weekly_df2_copy like '/copy/%';

Recovery Archivelogs
=================================

SET ARCHIVELOG DESTINATION TO '/fs3/tmp';
RESTORE ARCHIVELOG FROM SEQUENCE 201 UNTIL SEQUENCE 300;
restore archivelog logseq 11645;
RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
restore archivelog from scn 2324906766 until scn 2324970620;