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