RE: Active DATA GUARD 11g
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <mufc01666@xxxxxxxxx>, "'Nassyam Basha'" <nassyambasha@xxxxxxxxx>
- Date: Tue, 14 May 2013 12:21:57 -0400
The flow is one-way from a primary to one or more synchronized copies.
The bit "a synchronized copy" implying a single destination is misleading
and the focus that it is one direction at a time was the intention of that
document fragment.
You can indeed set up multiple destinations and they can vary in whether
they are "Active" (open for read) or not and whether or not there is an
intentional lag inserted between the transmission of changes and the
application of changes to various destinations (which can be local, near
local [on campus], somewhat remote [ as in dark fiber ], or regionally
separate [as in business continuation sites that are quite distant].)
Apart from the "one-way"-ness of having a primary site where changes are
made, the downstream from primary configuration possibilities are manifold.
Keep it simple unless the business requirements demand something else.
Good luck.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Tiran Harutyunyan
Sent: Tuesday, May 14, 2013 11:23 AM
To: Nassyam Basha
Cc: Oracle L
Subject: Re: Active DATA GUARD 11g
Re: Active DATA GUARD 11g
Nassyam,
Yes I got it , but here what I found in Oracle documentation
"Or= acle Data Guard is designed for simple, one-way replication&nbs= p;of
anentire 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[1]&n=
bsp;
Stay in touch..= .
-------------------
Tiran Harutyunyan
Senior Specialist of DB/System administration and Virtualization Belgium,
Antwerp
E-mail: mufc01666@xxxxxxxxx[2]=
LinkedIn: = http://www.linkedin.com/in/tiranh[3]
Tiran,
LOG_ARCHIVE_CONFIG refers to the remote destinations, Where you have to men=
tion DB_UNIQUE_NAME of all the database of Data Guard configuraiton.&=
nbsp;
If you have more than one standby, you need to just add keep on.
Example:
LOG_ARCHIVE_CONFIG=3D'DG_CONFIG=3D(PRIM_DB_UNIQUE_NAME, STDBY1_DB_UNIQUE_NA=
ME, STDBY2_DB_UNIQUE_NAME)';
Above each value refers to the DB_UNIQUE_NAME of each database. Hope you go=
t it ;)
Thanks &Regards,
Nassyam Basha.
www.oracle-ckpt.com[4]
On Tue, May 14, 2013 at 8:37 PM, Tiran Harutyunyan <mufc01666@xxxxxxxxx[5]>
wrote:
Nassyam,
Thanks for answer. You are understand me right. What about log_archive_conf=
ig ? 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[6]
LinkedIn: = http://www.linkedin.com/in/tiranh[7]
Tiran,
Question is bit confusing, Please let me know if my assumption is wrong.&nb=
sp; 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 con=
figure 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[8]>
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[9]
>
>
--
//www.freelists.org/webpage/or= acle-l[10]
--
Thanks &Regards,
Nassyam Basha.
--
Thanks &Regards,
Nassyam Basha.
--- Links ---
1 3D"http://docs.oracle.com/cd/B28359_01/server.111/b28281/hafea=
2 3D"mailto:mufc01666@xxxxxxxxx";
3 3D"htt=
4 3D"htt=
5 3D"mailto:mufc01666@gmail.=
6 3D"mailto:mufc01666@xxxxxxxxx";
7 3D"htt=
8 3D"mailto:mufc01666@gmail.=
9 3D"mailto:mufc01666@xxxxxxxxx";
10 3D"htt=
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
