RE: getting rid of copies of archivelogs
Date: Tue, 16 Sep 2008 11:24:59 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890B1EA80A@edmtpmail01.ad.umassmed.edu>
You could do a CROSSCHECK from rman to see if they are still listed in
rman catolog and then issue a DELETE EXPIRED statement to delete those
entries if any.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Claudia Zeiler
Sent: Tuesday, September 16, 2008 10:14 AM
To: Ray Stell; David A. Barbour
Cc: oracle-l_at_freelists.org
Subject: RE: getting rid of copies of archivelogs
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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 16 2008 - 10:24:59 CDT