Recovery Manager (RMAN) Notes

Deleting Expired Backup of a Database in NOARCHIVELOG Mode This was raised in a TAR No. 4618448.993 which affects Oracle 8.1.7 databases in NOARCHIVELOG mode that are backed up by RMAN. Issuing a 'crosscheck backup' or a 'delete expired backup' results into a RMAN-20242 Error.


The work around is to use 'delete expired backup of database' as follows:

$ export ORACLE_SID=RAPST  /* SID of the target database */
$ rman target / catalog rman_userid/password@catalog_database
RMAN> allocate channel for maintenence type 'SBT_TAPE';
RMAN> crosscheck backup of database;
RMAN> delete expired backup of database;