RE: getting rid of copies of archivelogs

From: Claudia Zeiler <czeiler_at_ecwise.com>
Date: Tue, 16 Sep 2008 07:14:25 -0700
Message-ID: <B47109E95A4F8C4AB42CC4D4169D997B1460CBDC47@ecsrm01.ecwise.local>

I need to clarify.

Since I delete the input when I backup the archive logs

 backup archivelog all not backed up delete all input format '/d123/backup/arch_%d_%u_%s';

the problem files are not archive logs, but copies of them. The archive logs have been deleted. These copies are copied off to tape each night, so I don't want them on disk the next day. I especially don't need them on disk a week or two later! All of my rman commands seem to address the original archive logs, not these copies of archive logs. That is why I am coming to wonder if the COPIES of the archivelogs on /d123 may not be rman files at all, and can be cleared out with a simple 'rm'? Of course, I have removed them with an 'rm', but I am worried that they still may be listed somehow in rman.

Thank you in advance to any clarification that you can give.

Claudia Zeiler
ECWise Database Administrator

---

From: Ray Stell [stellr_at_cns.vt.edu]
Sent: Tuesday, September 16, 2008 5:25 AM To: David A. Barbour
Cc: Claudia Zeiler; oracle-l_at_freelists.org Subject: Re: getting rid of copies of archivelogs

check CONFIGURE ARCHIVELOG DELETION POLICY. I don't think the commands will bypass the policy.

On Mon, Sep 15, 2008 at 10:44:33PM -0400, David A. Barbour wrote:
> Not having my handy manual, I think you might need to specify something like
> "not backed up 1 times" to get the logs to delete. Or you could just have
> "archivelog all" without the not backed up clause and they'd delete. I back
> up "not backed up 1 times" every 15 minutes and delete when the filesystem
> is 50% full.
>
>
>
>
>
>
>
> _____
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Claudia Zeiler
> Sent: Monday, September 15, 2008 9:03 PM
> To: oracle-l_at_freelists.org
> Subject: getting rid of copies of archivelogs
>
>
>
> I have set up a database in archivelog mode with
>
> backup as COMPRESSED BACKUPSET archivelog all not backed up delete all
> input format '/d123/backup/arch_%d_%u_%s';
>
> among my rman script commands.
>
>
>
> Now /d123/ is filling up. I have tried all sorts of rman> delete obsolete
> etc without result. Finally, I wonder, are these copied logs no longer
> part of rman? Is it sufficient to just delete them from the file system?
> Or is there an RMAN command that I haven't tried.
>
>
>
> Thanks in advance for your assistance,
>
>
>
> Claudia Zeiler
>
> Database Administrator
>
> EC|Wise
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 16 2008 - 09:14:25 CDT