Re: Data Guard RMAN deletion policy

From: Outsider <mufc01666_at_gmail.com>
Date: Fri, 30 Aug 2013 12:41:39 +0200
Message-ID: <CAO6u0XbvanrgC3jc=dBB0eZk2RLTixYPxDo=1StsJmfwe20k=A_at_mail.gmail.com>

Hi Justin, Marcin
Thanks for help. We already opened SR but we didn't get good answer. We added second catalog for standby and also mandatory option in log_dest parameter.
In this scenario deletion policy works but when standby will be offline and after all redo log switching primary will hang. (If I am wrong correct please .....)
So we need best high avalable solution for this situation.

*-----------------*

*Tiran*
*Best Regards
Stay in touch...*

On 30 August 2013 12:02, Justin Mungal <justin_at_n0de.ws> wrote:

> Hi Marcin, I don't recall him saying he is stopping the primary. Where are
> you seeing that?
>
> Tiran, I'm wondering if RMAN is incorrectly marking the logs as obsolete
> when the FRA is under space pressure. Or, they could be getting marked
> obsolete once they've been backed up even if they haven't yet been shipped.
>
> You could test that theory by deferring the log destination, switching the
> redo log, running an archive log backup to tape, and then finally checking
> to see if the backed up archive log has been marked as obsolete.
>
> -How is the space pressure managed in the Flash Recovery Area - An
> Example. (Doc ID 315098.1)
>
> Also, there have been numerous bugs relating to similar issues.
>
> -RMAN Archived Redo Logs Are Deleted Before Being Applied at Standby
> Database (Doc ID 740322.1)
> -Bug 7433541 : ARCHIVED LOGS ARE DELETED BY RMAN (AT PRIMARY) EVEN THOUGH
> THEY ARE NOT APPLIED
> -Bug 6216036 : RMAN+DG ARCHIVELOG DELETION POLICY APPLIED ON STANDBY NOT
> RESPECTED
>
> It would be very interesting if you opened an SR with Oracle to see what
> they say; there could be a simple fix for this.
>
> -Justin
>
> On Fri, Aug 30, 2013 at 3:07 AM, Marcin Przepiorowski <pioro1_at_gmail.com>
> wrote:
>
>> Hi,
>> Easiest solution move archive logs from FRA to other directory and write
>> your own RMAN scripts to control when you will delete archive logs.
>>
>> Anyway idea of stopping primary when standby is down due to archive log
>> issue seems strange for me. Even if you will lost archive logs from
>> primary
>> you can always use RMAN incremental backup to synchronize your standby.
>>
>> regards,
>> --
>> Marcin Przepiorowski
>> http://oracleprof.blogspot.com
>>
>>
>>
>

*-----------------*

*Tiran*
*Best Regards
Stay in touch...*

On 30 August 2013 12:02, Justin Mungal <justin_at_n0de.ws> wrote:

> Hi Marcin, I don't recall him saying he is stopping the primary. Where are
> you seeing that?
>
> Tiran, I'm wondering if RMAN is incorrectly marking the logs as obsolete
> when the FRA is under space pressure. Or, they could be getting marked
> obsolete once they've been backed up even if they haven't yet been shipped.
>
> You could test that theory by deferring the log destination, switching the
> redo log, running an archive log backup to tape, and then finally checking
> to see if the backed up archive log has been marked as obsolete.
>
> -How is the space pressure managed in the Flash Recovery Area - An
> Example. (Doc ID 315098.1)
>
> Also, there have been numerous bugs relating to similar issues.
>
> -RMAN Archived Redo Logs Are Deleted Before Being Applied at Standby
> Database (Doc ID 740322.1)
> -Bug 7433541 : ARCHIVED LOGS ARE DELETED BY RMAN (AT PRIMARY) EVEN THOUGH
> THEY ARE NOT APPLIED
> -Bug 6216036 : RMAN+DG ARCHIVELOG DELETION POLICY APPLIED ON STANDBY NOT
> RESPECTED
>
> It would be very interesting if you opened an SR with Oracle to see what
> they say; there could be a simple fix for this.
>
> -Justin
>
> On Fri, Aug 30, 2013 at 3:07 AM, Marcin Przepiorowski <pioro1_at_gmail.com>wrote:
>
>> Hi,
>> Easiest solution move archive logs from FRA to other directory and write
>> your own RMAN scripts to control when you will delete archive logs.
>>
>> Anyway idea of stopping primary when standby is down due to archive log
>> issue seems strange for me. Even if you will lost archive logs from
>> primary
>> you can always use RMAN incremental backup to synchronize your standby.
>>
>> regards,
>> --
>> Marcin Przepiorowski
>> http://oracleprof.blogspot.com
>>
>>
>>
>

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

Received on Fri Aug 30 2013 - 12:41:39 CEST