RE: Remove backups taken with a different channel type
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "'cicciuxdba@xxxxxxxxx'" <cicciuxdba@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Jan 2011 10:48:13 -0500
Hi Alan,
You should be able to do something like:
allocate channel for maintenance type 'sbt_tape' parms
'SBT_LIBRARY=oracle.disksbt,
ENV=(BACKUP_DIR=/u01/app/oracle)';
delete noprompt force obsolete device type 'sbt_tape';
obviously change BACKUP_DIR to a directory that exists on the machine...
_____________________________________________________________________________
Stephan Uzzell | MICROS Systems, Inc.
Database Administrator - OPERA Global Technical Services
7031 Columbia Gateway Dr, Columbia, MD 21046 | * 443.285.8000x2760 | 7
443.285.6505
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Guillermo Alan Bort
Sent: Tuesday, 04 January, 2011 10:42
To: oracle-l-freelists
Subject: Remove backups taken with a different channel type
Dear DBAs
This scenario is somewhat strange and I've hit a roadblock... perhaps someone
has some experience with this and can give me hand.
The situation is the following: A certain DB (DB1) was being backed up to tape,
and using a recovery catalog (REC1). At some point the decision was made to
backup this database to disk instead of tape, so the backup was sent to disk
and the tape backups were never removed from the recovery catalog. This poses a
problem now, since delete obsolete; says it needs a channel of the proper type
(we assume it's the tape channel). The libobk was removed from the system and
we no longer have access to the tape infrastructure from Oracle.
Error looks like this:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 01/04/2011 15:41:08
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
Test cases:
delete using "force" and "noprompt" options, delete until time (last tape
backup). Delete obsolete (with several options). Nothing seems to work. I know
there should be a way to force the catalog to "forget" these old backups, but
am at a loss right now.
Question, is there a way to forcibly remove the entries in the Recovery catalog
so that delete obsolete will work again?
I will keep researching anyway, thanks.
Alan.-
Other related posts:
