RE: redo log file setup with mirrored drives

2002-11-30 Thread Stephen Lee
> -Original Message- > We hope by > eliminating redo log multiplex, but with OS mirroring we > can speed up this loading process. -- We deal with this by: 1. Hardware mirroring of archives. 2. Archives go to device on which no other I/O is present a

Re: redo log file setup with mirrored drives

2002-11-29 Thread Yechiel Adar
Hello Guang >From your note about weekly one day long import I think that you are dealing with DW. 1) Am I correct? 2) Are there other updates to the database while the import is in progress? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT

RE: redo log file setup with mirrored drives

2002-11-27 Thread Rachel Carmichael
I script and test as well. But sometimes you can't think of every possible problem. My point wasn't to have a contest of who had worse problems or who had a problem that the other didn't. merely that sometimes hardware mirroring is not the be-all/end-all solution. We all could swap war stories

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
> -Original Message- > Sorry if you took offense at some attempted humor. -- No offense taken here. I've always worked in large environments where there were multiple DBA's, sys admins, developers, and testers. One cannot be easily offended and surv

RE: redo log file setup with mirrored drives

2002-11-27 Thread Jesse, Rich
e Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 27, 2002 9:54 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: redo log f

RE: redo log file setup with mirrored drives

2002-11-27 Thread Rachel Carmichael
> I was amazed at the non-security that seems to be rampant out there, > with mischievous people running around deleting files. I kept reading > about it and thinking you've got to be kidding. Steven, have you NEVER accidentally, at 3AM, after having been woken from a sound sleep to a crisis tha

Re: redo log file setup with mirrored drives

2002-11-27 Thread Guang Mei
Hi: I am the original poster and thanks for all your inputs on this topic. Now I know more about what "might" happen if something goes wrong. The main purpose of we thinking doing this was to gain some performance. We have a weekly schema imp process which takes about a day to finish. We hope b

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
> -Original Message- > have you NEVER accidentally, at 3AM, after having been woken from a > sound sleep to a crisis that needs to be fixed RIGHT NOW, > made a typo? > Actually no. But we usually script our actions and test the scripts prior to doing anything in production. As a sys a

RE: redo log file setup with mirrored drives

2002-11-27 Thread Jesse, Rich
em/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Stephen Lee [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 26, 2002 5:26 PM > To: Multiple recipients of list ORACLE-L > Subject: RE:

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
> -Original Message- > We do redo log file multiplexing to protect against fat > fingers and other odd-ball stuff that have caused problems > for an entire file system. Call it an unreliable OS, poor SA > (ok, maybe even DBA) practices I do it because it's a CYA thing of doing it by th

Re: redo log file setup with mirrored drives

2002-11-27 Thread Igor Neyman
Amen to that! Stephen, It seems like you keep this discussion on just for the sake of discussion. And also, it seems like you live in some kind of "ideal" world, where hardware and software is 100% error-free and is 100% "bullet-proof" and "fool-proof", and SAs, DBAs, developers, etc... never make

RE: redo log file setup with mirrored drives

2002-11-27 Thread Jay Hostetter
>Now for those who are into this "worst scenario" thing let me ask you: What >if I put your storage array between a 30HP air conditioning blower moter and >a spot welder, and run a couple of paint shakers on top of the array to >boot. What will your vaunted Oracle multiplexing do for you then? Hu

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
I suppose I should come clean on this deal and admit that we do indeed have Oracle duplex the redo files. The only time we would not do this is if some user with sufficient bureaucratic power has some suckwad app and was demanding that everything be done to bump up performance. If it comes to th

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
-Original Message I believe the forgone conclusion you are talking about is that "mirroring outside of Oracle MAY result in data loss" MAY is a very important word. The multiplexing of redo logs across multiple disks and controllers is a simple way protect your dat

RE: redo log file setup with mirrored drives

2002-11-26 Thread Khedr, Waleed
I agree. And this is why Oracle has the capability to manage many redo log members in the same group and many copies of the control file. It does not offer the same for regular data files. Regards, Waleed -Original Message- Sent: Tuesday, November 26, 2002 6:05 PM To: Multiple recipients

RE: redo log file setup with mirrored drives

2002-11-26 Thread Steve McClure
"While all this is true, this is all based on the forgone conclusion that mirroring outside Oracle will result in file loss. It is that conclusion with which I disagree." I believe the forgone conclusion you are talking about is that "mirroring outside of Oracle MAY result in data loss" MAY is a

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
> -Original Message- > Of course, you'll need Tom Kyte's binary conversion program > here to execute this very weak proof: Yeah, well this didn't come from Stephen Hawking. And let's not forget the part about "in the natural integers". Homey didn't take a bunch of 5000 and 6000 level

RE: redo log file setup with mirrored drives

2002-11-26 Thread Jesse, Rich
ink, Dan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 26, 2002 2:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: redo log file setup with mirrored drives > > > Stephen, > Nothing is gained by personal attacks in this forum. > This forum is &g

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
> -Original Message- > Stephen, > Nothing is gained by personal attacks in this forum. Please enlighten me. Exactly what personal attack was made? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network S

RE: redo log file setup with mirrored drives

2002-11-26 Thread Brian Haas
On Tue, 2002-11-26 at 10:50, Stephen Lee wrote: And from another post ... > > Because my OS/hardware IS reliable a corrupted > > log file that is mirrored outside of Oracle will be corrupt - > > the original is corrupt, so is the mirror. > > In one sentence you have claimed that your "OS/hard

RE: redo log file setup with mirrored drives

2002-11-26 Thread Jesse, Rich
, WI USA > -Original Message- > From: Fink, Dan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 26, 2002 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: redo log file setup with mirrored drives > [snip] > not protect against the accidental d

RE: redo log file setup with mirrored drives

2002-11-26 Thread Fink, Dan
Stephen, Nothing is gained by personal attacks in this forum. This forum is intended to be a learning experience for all (myself included). I suggest that you review the archived list and examine the quality of posts by Kirti, Jared, et.al. They speak for themselves. BTW, 2 + 2 doe

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
I was going to let the differences of opinion stand, but I suppose this requires an answer. > -Original Message- > > Redo and archived redo logs are the most important files in > the database. > Lose a datafile? You can still recover the database. > Lose all controlfiles? They can be r

RE: redo log file setup with mirrored drives

2002-11-26 Thread Jared . Still
2002 08:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: redo log file setup with mirrored drives "Pending further evidence to the contrary, I'll take mirroring external to Or

RE: redo log file setup with mirrored drives

2002-11-26 Thread VIVEK_SHARMA
Also stand by that "corrupted write will be restricted to just the affected member" Hence one can simply overwrite the BAD (Corrupted) member with the Good one -Original Message- Sent: Tuesday, November 26, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Sure... What I posted c

RE: redo log file setup with mirrored drives

2002-11-26 Thread Deshpande, Kirti
Sure... What I posted came from my discussions with others and from various resources on Metalink and from Oracle Training Classes. Note #45042.1 titled Archiver Best Practices summarizes it all. Agreed, that RAID and disk technologies have improved over the years, however, I would still con

RE: redo log file setup with mirrored drives

2002-11-26 Thread Jay Hostetter
Addressing the corruption issue, Kirti's statement is not speculation. Because my OS/hardware IS reliable a corrupted log file that is mirrored outside of Oracle will be corrupt - the original is corrupt, so is the mirror. If I mirror my log files using Oracle, logfile A may be corrupt, but

RE: redo log file setup with mirrored drives

2002-11-26 Thread Fink, Dan
"Pending further evidence to the contrary, I'll take mirroring external to Oracle as the better choice." Redo and archived redo logs are the most important files in the database. Lose a datafile? You can still recover the database. Lose all controlfiles? They can be recreated. Lose a single redo

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
If I may offer another view > -Original Message- > Having multiple redo log members has its advantages. The > archiver process 'knows' these multiple members and it will > optimize the archiving process, Is there any supporting documentation about this "optimizing"? Are you sayin

RE: redo log file setup with mirrored drives

2002-11-25 Thread Deshpande, Kirti
Having multiple redo log members has its advantages. The archiver process 'knows' these multiple members and it will optimize the archiving process, but it does not know about the mirrored copies of these logs. The other important thing to know is that Oracle issues a separate write for these lo

redo log file setup with mirrored drives

2002-11-25 Thread Guang Mei
Hi: We have oracle 8173 running on Sun Solaris box. The current redo files are: /oracle/oradata/RPT1/redo101.log /oracle/oradata/RPT1/redo201.log /oracle/oradata/RPT1/redo301.log /oracle/u01/oradata/RPT1/redo102.log /oracle/u01/oradata/RPT1/redo202.log /oracle/u01/oradata/RPT1/redo302.log The me