advertisements
_____________________________________________________________________________________________________________________
Command to find out backup piece for an archive log thread and sequence
RMAN>LIST BACKUP OF ARCHIVELOG ALL;
RMAN>LIST BACKUP OF ARCHIVELOG sequence 196;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 196;
Command to see the list/summary of backups available with RMAN catalog
RMAN>LIST BACKUP;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST BACKUP OF DATABASE;
Command to find out the backup piece details for a datafile
RMAN>LIST BACKUP OF DATAFILE 2;
RMAN>list backup of datafile '+DATA/prod/datafile/system.277.76879881';
RMAN >LIST BACKUP OF DATAFILE 2 SUMMARY;
Command to find out the Incarnation details
RMAN> LIST INCARNATION;
RMAN> LIST INCARNATION OF DATABASE PROD;
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment