RE: getting rid of archivelog copies

  • From: Claudia Zeiler <czeiler@xxxxxxxxxx>
  • To: "cjnewman@xxxxxxxxxxxxx" <cjnewman@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 17 Sep 2008 13:36:49 -0700

I have finally beaten it!
I physically deleted the unneeded files on /d123
Then  crosscheck backup;   which finally recognized that I had expired files
And then, of course,

delete expired backup;  which finally removed them from rman.

I obviously have something configured incorrectly that these things are never 
registering as obsolete.  But I am really sick of this project for now.  I'll 
expire the old stuff for now, and return later to figure out how to have rman 
register it as obsolete on its own.

Thank you all for all the suggestions.

-Claudia Zeiler

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Newman, Christopher
Sent: Wednesday, September 17, 2008 5:29 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: re: getting rid of archivelog copies

"From: Claudia Zeiler <czeiler@xxxxxxxxxx>
Date: Tue, 16 Sep 2008 10:24:01 -0700
Subject: RE: getting rid of copies of archivelogs

I have retention configuredd to redundancy 1

What I am trying to get rid of is the 1 backup of the archivelog file.
This one copy is on /d123, not in the original archive log destination.
The original archive logs are delete by the command

 backup  archivelog all not backed up delete all  input format

It is the output of the above command (the files now on  /d123) that I
am now trying to get rid of before they devour my entire system, since
they are no longer needed.  They are not archivelog files, they are
obsolete backups of archivelog files.

What I haven't found is something to the effect of

delete expired backup of archivelog all;
that actually lists the files on /d123.

When I do it it tells me that channels were allocated, and then returns
me to the rman prompt.  Is that because I have the wrong command, or are
these files outside of rman?"
Make sure your channels are pointing to the correct source.  Ie,
allocate channel tape1 type 'sbt_tape' or 'disk' ....  Then you can
execute your delete obsolete; delete expired commands over that channel.

**Also, if you don't specify channels in your run blocks, you might have
a default channel configured that points either to disk or tape (the
opposite of the location you are attempting to delete from).  Do RMAN>
show all; and see if that is your case.



Other related posts: