Re: Archivelog Deletion Policy on Standby
From: Leng Burgess <lkaing_at_gmail.com>
Date: Tue, 18 Aug 2020 10:55:09 +1000
Message-Id: <3F214CFE-9B46-4A41-B2EE-358672190E47_at_gmail.com>
>> On 12 Aug 2020, at 2:46 am, Charlotte Hammond (Redacted sender "charlottejanehammond" for DMARC) <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org>> wrote:
>>
>> Hello All,
>>
>> I have the following set in the RMAN configuration on a **standby** database:
>>
>> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
>>
>> However even if I don't run a backup (either on primary or standby) the archivelogs are being deleted to reduce pressure on the FRA.
>>
>> Is this the expected behavior on the standby? (Oracle 11.2.0.4)
>>
>> Thank You!
>> Charlotte
>>
>>
>
Date: Tue, 18 Aug 2020 10:55:09 +1000
Message-Id: <3F214CFE-9B46-4A41-B2EE-358672190E47_at_gmail.com>
eg.
Bug 12611721 - Archivelog deletion policy backed up N times to 'sbt_tape' ignored (Doc ID 12611721.8)
The fix for 12611721 is first included in
12.2.0.1 (Base Release) <https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=12611721.8&id=245840.1#FIXED_12.2.0.1> 12.1.0.2 (Server Patch Set) <https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=12611721.8&id=245840.1#FIXED_12.1.0.2> 11.2.0.4.6 (Apr 2015) Database Patch Set Update (DB PSU) <https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=12611721.8&id=20299013.8> 11.2.0.4 Bundle Patch 16 for Exadata Database (Apr 2015) <https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=12611721.8&id=20589991.8> 11.2.0.4 Patch 15 on Windows Platforms <https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=12611721.8&id=1114533.1> > On 18 Aug 2020, at 10:21 am, Leng Burgess <lkaing_at_gmail.com> wrote: > > I believe I saw a bug with this just a few days ago. > > If I find it I’ll get back to you on it... >
>> On 12 Aug 2020, at 2:46 am, Charlotte Hammond (Redacted sender "charlottejanehammond" for DMARC) <dmarc-noreply_at_freelists.org <mailto:dmarc-noreply_at_freelists.org>> wrote:
>>
>> Hello All,
>>
>> I have the following set in the RMAN configuration on a **standby** database:
>>
>> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
>>
>> However even if I don't run a backup (either on primary or standby) the archivelogs are being deleted to reduce pressure on the FRA.
>>
>> Is this the expected behavior on the standby? (Oracle 11.2.0.4)
>>
>> Thank You!
>> Charlotte
>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 18 2020 - 02:55:09 CEST