RE: getting rid of copies of archivelogs
- From: Claudia Zeiler <czeiler@xxxxxxxxxx>
- To: Ray Stell <stellr@xxxxxxxxxx>, "David A. Barbour" <david.barbour1@xxxxxxxxx>
- Date: Tue, 16 Sep 2008 07:14:25 -0700
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@xxxxxxxxxx]
Sent: Tuesday, September 16, 2008 5:25 AM
To: David A. Barbour
Cc: Claudia Zeiler; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Claudia Zeiler
> Sent: Monday, September 15, 2008 9:03 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
>
>
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
