Re: Data Guard RMAN deletion policy

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Fri, 30 Aug 2013 09:07:32 +0100
Message-ID: <CAGdek=xxX+ha6nXuy7_q4q5aBc=HHc+a3KMZwGME7RBnOjup1A_at_mail.gmail.com>

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


On Tue, Aug 27, 2013 at 5:37 PM, Outsider <mufc01666_at_gmail.com> wrote:



> Dear,

>

> I have a Data Guard in place. The PRIMARY is on Data Center 1 (DC1). The

> STANDBY is on Data Center 2 (DC2). In both Data Centers we have a tape

> device. I want to backup the archives from the PRIMARY to the tape device

> in DC1 and the archives from the STANDBY to the tape device in DC2.

> Archives are stored in the Flash_recovery_area for both db's. We use

> saperate RMAN catalogs.

>

> The problem is that when STENDBY is off and FRA in PRIMARY is full Oracle

> starting to delete not yet shipped logs from primary , and standby will

> have gap !!!

> We prefer Oracle DB hanged but not having gaps between our databases.

>

> Deletion policy is set to delete logs after backup + shipped to standby.

>

> *CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE'

> SHIPPED TO ALL STANDBY;*

>

> It seems like deletion policy is not working correctly ?

> Please share with me your experience.

> Thanks in advance.

>

> *-----------------*

> *Tiran*

> *Best Regards

> Stay in touch...*

>

>

> --

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

>

>

>



-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com


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

Received on Fri Aug 30 2013 - 10:07:32 CEST