RMAN> list backup of database completed between 'sysdate -7' and 'sysdate' RMAN> list backup completed between 'sysdate -14' and 'sysdate -7' Time-related List backup command RMAN> list backup completed between 'sysdate -1' and 'sysdate' The below command can be to list the backupset taken RMAN> LIST BACKUPSET SUMMARY LIST BACKUP OF ARCHIVELOG ALL COMPLETED RMAN> LIST BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-2' This command can be used to list archive log backup from a given time RMAN> LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-1' This command can be used to list archive log backup from a given sequence RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE This command can be used to list archive log backup of the database RMAN> LIST BACKUP OF ARCHIVELOG ALL īS Key Size Device Type Elapsed Time Completion TimeīP Key: 8801 Status: AVAILABLE Compressed: NO Tag: TAG01 This command can be used to list backup summary of the control file RMAN> LIST BACKUP OF CONTROLFILE SUMMARY This command can be used to list backup of the control file RMAN> LIST BACKUP OF CONTROLFILE This command can be used to list backup summary of individual datafile RMAN> LIST BACKUP OF DATAFILE SUMMARY This command can be used to list backup of individual datafile RMAN> LIST BACKUP OF DATAFILE This command can be used to list backup summary of individual tablespace RMAN> LIST BACKUP OF TABLESPACE SUMMARY This command can be used to list backup of individual tablespace RMAN> LIST BACKUP OF TABLESPACE SYSTEM To list all existing database backups by backup which can be used RMAN> LIST BACKUP OF DATABASE BY BACKUP To list all existing oracle database backups which can be used RMAN> LIST BACKUP OF DATABASE This command prints the backup by file RMAN> LIST BACKUP BY FILE List backup summary provides the summary of the backup taken of the database using RMAN RMAN> LIST BACKUP SUMMARY List all the backup taken in the system RMAN> LIST BACKUP īS Key Type LV Size Device Type Elapsed Time Completion Timeġ2499 Incr 0 256.00K SBT_TAPE 00:00:13 28-FEB-18īP Key: 12499 Status: AVAILABLE Compressed: NO Tag: TEST_WH_18-02-28_01 If you have lost your Target database, then these listings can be obtained by connecting to the catalog and then setting the DBID It shows all the details about the backup taken, what time it was taken, location of the backup.įirst, you need to connect with the Target database with or without a catalog and then these commands can be run. RMAN List backup is a useful command to list the backup taken in the system.
0 Comments
Leave a Reply. |