Reports commands for RMAN

on Monday 21 May 2012

Reports commands for RMAN 

Use the report commands to answer for the following question
  1. which files need a backup?
  2. which files or backups are obsolete and can be deleted
  3. which files have not been backed up recently and etc….
  •  if you have retention policy configured, then you can just run report need backup to determine which files need backups
            RMAN> report need backup
  • To report the database structure at a specified point in time
             RMAN> report schema
  •  Which backup can be delete (obsolete)
                RMAN> report obsolete
  •  Which files are not recoverable
              RMAN> report unrecoverable
  •  To delete obsolete backup
              RMAN> delete obsolete

0 comments:

Post a Comment