Re: Active DATA GUARD 11g

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Tue, 14 May 2013 21:07:33 +0530
Message-ID: <CAABGLu+Nzq4T6iJJBRjXFGXmrbuH7vG55g7GjO36f+rOmHY4FQ_at_mail.gmail.com>

Tiran,
One way replication here in Data Guard is, redo/arch were transferred from primary to standby.
Of course *physical* standby database is an exact image copy of primary database, Because whatever the redo is generated and the same chanegs will be applied on standby database. Even if you configure redo transport from standby to primary it wont accept incoming redo either, it rejects because it is already an primary database.

BTW, You can say one to many(standby) :)

There is another option is Cascaded standby, You can configure transport/replication from standby to standby to avoid more work on Primary database. this should helps you
http://docs.oracle.com/cd/E11882_01/server.112/e25608/log_transport.htm#BEHBIGHF

Thanks & Regards,
Nassyam Basha.

On Tue, May 14, 2013 at 8:52 PM, Tiran Harutyunyan <mufc01666_at_gmail.com>wrote:

> Nassyam,
>
> Yes I got it , but here what I found in Oracle documentation
>
> "Oracle Data Guard is designed for simple, *one-way replication* of an
> entire database expressly for maintaining a synchronized copy that can
> assume the primary role in the event of a failure. "
>
> http://docs.oracle.com/cd/B28359_01/server.111/b28281/hafeatures.htm
>
>
> Stay in touch...
> -------------------
> Tiran Harutyunyan
> Senior Specialist of DB/System administration and Virtualization
> Belgium, Antwerp
> E-mail:
> mufc01666_at_gmail.com
>
> LinkedIn: http://www.linkedin.com/in/tiranh
>
>
> Tiran,
>
> LOG_ARCHIVE_CONFIG refers to the remote destinations, Where you have to
> mention DB_UNIQUE_NAME of all the database of Data Guard configuraiton.
>
> If you have more than one standby, you need to just add keep on.
> Example:
>
> LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM_DB_UNIQUE_NAME, STDBY1_DB_UNIQUE_NAME,
> STDBY2_DB_UNIQUE_NAME)';
>
> Above each value refers to the DB_UNIQUE_NAME of each database. Hope you
> got it ;)
>
> Thanks & Regards,
> Nassyam Basha.
> www.oracle-ckpt.com
>
>
> On Tue, May 14, 2013 at 8:37 PM, Tiran Harutyunyan <mufc01666_at_gmail.com>
> wrote:
> Nassyam,
>
> Thanks for answer. You are understand me right. What about
> log_archive_config ? Need I change this also , add second standby name ?
>
>
>
> Stay in touch...
> -------------------
> Tiran Harutyunyan
> Senior Specialist of DB/System administration and Virtualization
> Belgium, Antwerp
> E-mail: mufc01666_at_gmail.com
> LinkedIn: http://www.linkedin.com/in/tiranh
>
>
>
> Tiran,
>
> Question is bit confusing, Please let me know if my assumption is wrong.
> You have enabled ADG on first standby and you want to add extra standby to
> the Data Guard environment? Yes you can add.
>
> In LOG_ARCHIVE_DEST_n parameter, if the number is from 1 to 10, You can
> configure 1 to 10 standby database(s). But for every ADG you must have
> license to use of it.
>
> If am missing your question please describe more. :)
>
> Thanks & Regards,
> Nassyam Basha.
>
>
>
> On Tue, May 14, 2013 at 7:57 PM, Tiran Harutyunyan <mufc01666_at_gmail.com>
> wrote:
> Hi ADG experts,
> I have installed Oracle 11g data guard in our live environment , now I
> think about to add second standby DB, can I do that? I mean is Oracle 11g
> support 2 way replication with Data Guard physical standby ?
>
> >
> > Hardware: IBM Blade center , RAM 36G, CPU Intel Xeon 12 core.
> > OS RHEL 6.3
> > DB: Oracle 11gR2
> >
> > Thanks in advance.
> >
> > Stay in touch...
> > -------------------
> > Tiran Harutyunyan
> > Senior Specialist of System/DB administration and Virtualization
> > Yerevan, Armenia
> > E-mail: mufc01666_at_gmail.com
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
>
>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
>
>

-- 
Thanks & Regards,
Nassyam Basha.


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

Received on Tue May 14 2013 - 17:37:33 CEST