Essential RMAN Commands.

CHANGE

Options:

1) AVAILABLE - Changes the status of backup or copy to "available" in the repository.
2) UNAVAILABLE - Changes the status of backup or copy in the repository.
3) KeepOption - Overrides the retention policy.

 3.1) KEEP FOREVER - Specifies that backup or copy never expires.
                    Requires Recovery Catalog.
3.2) KEEP UNTIL TIME = 'SYSDATE + n' - Specifies the date until which the
                        backup or copy must be kept.
3.3) LOGS - Specifies that all of the archived logs required to recover this
            backup or copy must remain available as long as this backup or 
            copy is available.
3.4) NOKEEP - Specifies that the backup or copy expires accordingg to the
              user's retention policy.

4) UNCATALOG - Removes refrences to a datafile copy, backup piece, or archived
               log from the recovery catalog, and updates records in the
               target control file to status "deleted".




RESYNC CATALOG - Use the command to perform manual full resynchronisation when:
                    
a) The recovery catalog is unavailable when you issue any of the commands
   that automatically perform a resynchronisation.
                  
b) You are running in archivelog mode, because the catalog is not updated automatically
   when a log switch occurs or when a online redo log is archived.

c) You have made changes to the physical structure of the target database,
   and the recovery catalog is not updated.


TAG - A tag is a symbolic name for a backup set or copy.

RMAN> backup database tag=Daily keep forever;

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
31      B  F  A DISK        17-FEB-12       1       1       NO         DAILY
32      B  F  A DISK        17-FEB-12       1       1       NO         DAILY






REPORT OBSOLETE - List backups that are obsolete.

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           31     17-FEB-12         
  Backup Piece       34     17-FEB-12          /u01/app/oracle/flash_recovery_area/ORCL/
                                               backupset/2012_02_17/
                                               o1_mf_nnndf_DAILY_7mx43o38_.bkp
Backup Set           32     17-FEB-12         
  Backup Piece       35     17-FEB-12          /u01/app/oracle/flash_recovery_area/ORCL/
                                               backupset/
                                               2012_02_17/o1_mf_ncsnf_DAILY_7mx4bj7y_.bkp


DELETE OBSOLETE - Delete all obsolete backups.

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           31     17-FEB-12         
  Backup Piece       34     17-FEB-12          /u01/app/oracle/flash_recovery_area/ORCL/
                                               backupset/2012_02_17/
                                               o1_mf_nnndf_DAILY_7mx43o38_.bkp
Backup Set           32     17-FEB-12         
  Backup Piece       35     17-FEB-12          /u01/app/oracle/flash_recovery_area/ORCL/
                                               backupset/2012_02_17/
                                               o1_mf_ncsnf_DAILY_7mx4bj7y_.bkp

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_nnndf_DAILY_7mx43o38_.bkp RECID=1 STAMP=775523277

deleted backup piece

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_ncsnf_DAILY_7mx4bj7y_.bkp RECID=2 STAMP=775523496

Deleted 2 objects



CROSSCHECK

It is used to check the status of backups and copies recorded in the
RMAN repository against media such as disk or tape.

RMAN>crosscheck backup;

using channel ORA_DISK_1

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_nnndf_DAILY_7mx43o38_.bkp RECID=1 STAMP=775523277

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_ncsnf_DAILY_7mx4bj7y_.bkp RECID=2 STAMP=775523496

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_nnndf_TAG20120217T231425_7mx4htbb_.bkp RECID=3 STAMP=775523666

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_02_17/
o1_mf_ncsnf_TAG20120217T231425_7mx4mnfc_.bkp RECID=4 STAMP=775523788

Crosschecked 4 objects