Re: getting rid of copies of archivelogs

So you've got two archive log destinations defined for your instance?  The
"standard" backup you're running deletes the logs from only one of the two
locations?

"Copies" can have more than one meaning when you're dealing with RMAN.

Presuming you have two destinations defined, If you restore an archivelog
file, where does it end up?

On Tue, Sep 16, 2008 at 10:14 AM, Claudia Zeiler <czeiler@xxxxxxxxxx> wrote:

> 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
> >
> >
> >
> >
> >
> >
> >
>

Other related posts: