<< Analyze Notes | Journals | How do you make a table read only? >>
Deleting Expired Backup 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;