Re: Active DATA GUARD 11g
- From: Nassyam Basha <nassyambasha@xxxxxxxxx>
- To: Tiran Harutyunyan <mufc01666@xxxxxxxxx>
- Date: Tue, 14 May 2013 21:07:33 +0530
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@xxxxxxxxx>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@xxxxxxxxx
>
> 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@xxxxxxxxx>
> 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@xxxxxxxxx
> 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@xxxxxxxxx>
> 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@xxxxxxxxx
> >
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
>
>
>
>
>
> --
> Thanks & Regards,
> Nassyam Basha.
>
>
--
Thanks & Regards,
Nassyam Basha.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
