Oracle 10g 11g RMAN Useful Commands

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;
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google