RMAN List commands

on Monday, 21 May 2012

RMAN List commands

The primary purpose of list command is to determine which backups or copies are available
  • To list backup sets, backup pieces and proxy copies
             RMAN> list backup
  •  To list backups by file
             RMAN> list backup by file
  •  To list backups in summary mode
             RMAN> list backup summary
  •  To list backups of all files in database
             RMAN> list backup of database;
  •  To list copy of specified datafile
              RMAN> list copy of datafile ‘/disk1/oradata/tbs_1.f ’;
  •  To list specified backup set
               RMAN> list backupset 213
  •  To list a backup by tag
               RMAN> list backup TAG ‘weekly _full_db_bk’
  •  To list archivelog files
              RMAN> list archivelog all;

0 comments:

Post a Comment