Re: Standby Database Archivelogs Backup/Removal?

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 28 May 2010 11:53:44 -0300
Message-ID: <AANLkTindryPp4kp9GfeammHWxL8Oac5OD4oFBaGn63zT_at_mail.gmail.com>

you are correct... this is one of the groses flaws of standby/dataguard in Oracle... it's even worse when you are using RAC on ASM, since the job NEEDS to be an RMAN job and it cannot be a regular shell script to delete the files and crosscheck.

hth
Alan.-

On Fri, May 28, 2010 at 11:29 AM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> Nevermind. I think I figured it out. You have to setup an RMAN job on
> the standby site and backup the archivelogs, right? I tried connecting the
> standby to a RMAN catalog, but that doesn’t work, so you have to use RMAN
> without a catalog.
>
>
>
> Thanks,
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
>
>
>
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Taylor, Chris David
> *Sent:* Friday, May 28, 2010 9:21 AM
> *To:* 'oracle-l_at_freelists.org'
> *Subject:* Standby Database Archivelogs Backup/Removal?
>
>
>
> Ok, so I have a physical standby database that I’m transferring logs to via
> LGWR. How do I remove the logs *at *the standby site after they’ve been
> applied?
>
>
>
> I was under the impression that when I backed up the files on the primary,
> the archivelogs would be removed from the standby – THINKING that through, I
> realized that didn’t make any sense after my remote archivelog destination
> filled up. Doh.
>
>
>
> Thanks!
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
>
>
>
> *CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential
> and may also be privileged. If you are not the named recipient, please
> notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>

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

Received on Fri May 28 2010 - 09:53:44 CDT