Oracle8i (AIX433) Rman

Hi all,

I am getting confused about deleting old archivelog backed-up by RMAN ( with a TSM Server)
Any help will be greatly appreciated....

Thanks a lot
E.Cha

Here is the list of the archivelogs I want to delete !!! The command list backup gives me a result....
############################################################################
#############

RMAN> list backup of archivelog until time '20-MAR-03' ;
############################################################################
#############

RMAN-03022: compiling command: list

List of Backup Sets

Key Recid Stamp LV Set Stamp Set Count Completion Time

• ---------- ---------- -- ---------- ---------- --------------------- -

3197 2 489100083 0 489100081 2 19-MAR-03 List of Backup Pieces

Key Pc# Cp# Status Completion Time Piece Name

• --- --- ----------- ---------------------- ------------------------

3198 1 1 AVAILABLE 19-MAR-03
bisamdev_BISAMDEV_ARCHIVE_OF_200303192106_BS2_BP1

List of Archived Logs Included

Thrd Seq Low SCN Next SCN Low Time Next Time

• ------- ---------- ---------- --------------- ---------------

1 562 321325 321330 19-MAR-03 19-MAR-03 1 563 321330 321352 19-MAR-03 19-MAR-03 1 564 321352 321361 19-MAR-03 19-MAR-03 1 565 321361 321444 19-MAR-03 19-MAR-03 1 566 321444 321450 19-MAR-03 19-MAR-03 And here is the command I try to use to delete the archivelog...

############################################################################
#############

RMAN> change archivelog until time '21-MAR-03' delete ;

############################################################################
#############

RMAN-03022: compiling command: change

RMAN-03026: error recovery releasing channel resources

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure during compilation of command

RMAN-03013: command type: change

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archivelog in the recovery cat

alog

NB:

the command report obsolete doesn't show me anything about these backupsets or backuppieces of my archivelogs !!!

I can't do a crosscheck to make them unavailable , because they are on tape and still available !!! Received on Tue May 27 2003 - 02:58:33 CDT