Oracle Data Guard

2003-12-08 Thread Nalla Ravi
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. ___

Oracle Data Guard

2001-11-01 Thread Jeff Wiegard
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,

Oracle Data Guard

2001-03-06 Thread Rocky Welch
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

Re: Oracle Data Guard

2003-12-08 Thread Tanel Poder
> 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

Re: Oracle Data Guard

2003-12-08 Thread Nalla Ravi
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

RE: Oracle Data Guard

2003-12-08 Thread Josh Collier
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

Re: Oracle Data Guard

2003-12-08 Thread Carel-Jan Engel
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

Re: Oracle Data Guard

2003-12-08 Thread Carel-Jan Engel
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

Re: Oracle Data Guard

2003-12-08 Thread Tanel Poder
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

Re: Oracle Data Guard

2003-12-08 Thread Nalla Ravi
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

Re: Oracle Data Guard

2003-12-08 Thread Carel-Jan Engel
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.

Re: Oracle Data Guard

2003-12-08 Thread Nalla Ravi
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

Re: Oracle Data Guard

2003-12-09 Thread Yong Huang
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

RE: Oracle Data Guard

2003-12-09 Thread Kitty Luo
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

RE: Oracle Data Guard

2003-12-09 Thread Guang Mei
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

Re: Oracle Data Guard

2003-12-09 Thread Carel-Jan Engel
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

RE: Oracle Data Guard

2003-12-09 Thread Carel-Jan Engel
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

RE: Oracle Data Guard

2003-12-10 Thread Yong Huang
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

Re: Oracle Data Guard

2003-12-11 Thread Jonathan Lewis
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

Re: Oracle Data Guard

2003-12-11 Thread Jonathan Lewis
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

Re: Oracle Data Guard

2003-12-11 Thread Yong Huang
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

Re: Oracle Data Guard

2003-12-12 Thread Carel-Jan Engel
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 --

Re: Oracle Data Guard

2001-11-01 Thread ARUN K C
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

RE: Oracle Data Guard

2001-11-01 Thread DENNIS WILLIAMS
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