RE: getting rid of archivelog copies
Date: Wed, 17 Sep 2008 13:36:49 -0700
Message-ID: <B47109E95A4F8C4AB42CC4D4169D997B1460E85FAC@ecsrm01.ecwise.local>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher
Sent: Wednesday, September 17, 2008 5:29 AM
To: oracle-l_at_freelists.org
Subject: re: getting rid of archivelog copies
"From: Claudia Zeiler <czeiler_at_ecwise.com>
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 '/d123/backup/arch_%d_%u_%s';
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.
-Chris
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 17 2008 - 15:36:49 CDT