Hi All,
can any one let me know kindly the following info.
1) Has any one used the Oracle 9i Data Guard?
2) If yes then, is there any performance impact on
Target/Source server database.
3) any drawbacks using Data Guard.
with many thanks,
Vijay.
___
Hi. I'm looking into implementing a read-only stand-by database. I'd
like to have it read-only for periodic reporting during the day. Is
this possible under 8.1.7, or 9i?
Are there any drawbacks to having the stand-by database opened for
read-only? I would have two goals in mind: 1. A stand-by,
Hi Gang,
Can anyonepoint me to some documentation for this product? Technet seems
pretty limited.
TIA,
-Rocky
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FA
> Hi All,
>
> can any one let me know kindly the following info.
>
> 1) Has any one used the Oracle 9i Data Guard?
Yes, physical standby and successfully.
> 2) If yes then, is there any performance impact on
> Target/Source server database.
Your database has to be in archivelog mode, but when y
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rather than physical.
Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.
Now We didn't go to Snapshot because It is on
multiple tables
Hi,
Tanel,
"enabling jumbo frames and SDU size if using
Gbit ethernet,"
can you elaborate on this?
-Original Message-
Sent: Monday, December 08, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rath
Hi Vijay,
I've done around 20 DG installations at different sites, using Linux,
Solaris, AIX and W2K.
High speed network isn't always what you need, low latency might be more
important. I've set up a DG environment between Kuala Lumpur and Rotterdam,
using a 128KB line. This wasn't for standby
Comments inline
At 13:34 8-12-03 -0800, you wrote:
Hi Tanel,
Much appreciated, The fact is I am interested in
Logical standby rather than physical.
Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.
It all depends
With TCP over standard ethernet the maximum transfer unit (MTU) is about
1500 bytes, this means if you want to send 2000 bytes over network, you have
to fragment it in 2 packets and send them separately. This means double
packet headers, double latency etc. Jumbo frames is a capability of some
Gbit
Hi Carel,
That is good help, can you please send me the pdf that
you implemented there then.
Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so we
should be smooth. Can you tell me is there any
releation between LSB and Primary keys, I read
Comments inline
At 14:54 8-12-03 -0800, you wrote:
Hi Carel,
That is good help, can you please send me the pdf that
you implemented there then.
Was on its way already
Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so we
should be smooth.
Hi Carel,
What if 50% of tables doesn't have Primary/Unique
keys, how it is going be with LSB then? Can you please
explain more.
with thanks,
Vi
--- Carel-Jan Engel <[EMAIL PROTECTED]>
wrote: > Comments inline
>
> At 14:54 8-12-03 -0800, you wrote:
> >Hi Carel,
> >
> >That is good help, can
Jumbo frames are new to me. The Ethernet Definitive Guide book says it was
proposed by one vendor and adopted by several, so may not have good
interoperability. But I wonder how much performance improvement there is by
going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the
OS
Hi All,
I am working on a similar project here. I am wondering if anyone in the list ever
compared Oracle Data Guard with iReflect from Data Mirror. Please share your
experience with us.
Thanks,
Kitty
-Original Message-
Sent: Monday, December 08, 2003 6:54 PM
To: Multiple
I have never worked on Network stuff. But is there any easy parameters we
could set in sqlnet.ora so that we could increase the DB performance by
increase the network transfer rate (without doing anything else)? BTW my
sqlnet.ora (on a Sun Box) has only two lines:
--
bash-2.03$ more sqlne
thing as a free lunch.
For detailed information read chapter 4.1.5 & 4.1.6 in the Oracle
Data Guard Concepts and Administration manual, part no.
A96653-02.
regards, Carel-Jan
At 15:54 8-12-03 -0800, you wrote:
Hi Carel,
What if 50% of tables doesn't have Primary/Unique
keys, how it is going b
9-12-03 -0800, you wrote:
Hi All,
I am working on a similar project here. I am wondering if anyone in the
list ever compared Oracle Data Guard with iReflect from Data Mirror.
Please share your experience with us.
Thanks,
Kitty
-Original Message-
Sent: Monday, December 08, 2003 6:54
Hi, Guang,
Look up SDU and TDU in Oracle documentation Network configuration. You set them
in tnsnames.ora and listener.ora, not sqlnet.ora. protocol.ora allows you to
modify some procotol-specific parameters. In addition, in your client
application, you can choose a sensible array fetch size, suc
Can you clarify a couple of points for me.
The SDU (session data unit) is presumably the
packet size that the Oracle client and server
want to pass back and forth - which is presumably
the maximum size the one synchronous dialogue unit
will be.
The TDU (transport data unit) is presumably the
pre
free lunch. For detailed information read chapter 4.1.5
& 4.1.6 in the Oracle Data Guard Concepts and Administration manual, part
no. A96653-02.
regards, Carel-Jan
At 15:54 8-12-03 -0800, you wrote:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
Hi, Jonathan,
I think your question is why I mentioned TDU, not just SDU, in my response to
Guang's message. I admit I didn't give much thought and threw that in.
Note:44694.1 says it's set to 32k by default and its adjustable range is 0 to
32k. Then the question is why Oracle chose the magical 32
here ain't
no such thing as a free lunch. For detailed information read chapter 4.1.5
& 4.1.6 in the Oracle Data Guard Concepts and Administration manual, part
no. A96653-02.
regards, Carel-Jan
At 15:54 8-12-03 -0800, you wrote:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
It is possible in 8.1.7
>From: "Jeff Wiegard" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle Data Guard
>Date: Thu, 01 Nov 2001 11:20:22 -0800
>
>Hi. I'm looking into
Jeff - With 8.1.7, I believe that you are limited to read-only or standby,
but you can't have both simultaneously. It is either in recovery mode
accepting redo logs from production or open and allowing read-only.
I believe that with 9i the options are much more flexible. Read up
on the Or
24 matches
Mail list logo