Re: 9i standby
I'm a little late to respond, but... RAC is most certainly a significant upgrade to and renaming of OPS. There is absolutely no doubt about it. At Oracle Open World 2000, all the Oracle OPS people doing presentations found out about the name change only a few weeks before the conference and scrambled madly to change all occurrences of "Oracle Parallel Server" to "Real Application Clusters" in their 9i (nee 8.2) presentations. The handouts still said OPS (and sometimes 8.2 ), but the otherwise identical overheads (usually) said RAC and 9i. The marketing denial of this is simply because OPS got such a bad reputation - which was, in my opinion, largely undeserved. The people who actually write the code for OPS/RAC suffer no such delusions. Granted OPS/RAC is/was more complex, but the bad rep was mostly due to people trying to use OPS inappropriately - for poorly-suited applications and systems (i.e. the majority). "RAC" is somewhat simpler to set up and administer than "OPS" and performs much better, but it is still OPS with a new name. While Oracle finally admitted that OPS was a specialty product, they seem now to be saying that RAC is for anything. I wouldn't swallow all of that particular Kool-Aid just yet! -Don Granaman [certifiable Orasaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 2:20 PM > No it is not the upgrade of OPS as I understand. They even put OPS down > themselves saying that it was sparsely used, and far to complicated to set > up. > > What RAC does, is essentially link every machine together in to a "cluster", > then each physical machine can touch the same database concurrently > (probably on a central storage unit). There is no actual "standby" when this > is in use, as all machines connected to the cluster work together - but if > one of the machines has a hardware failure, the load is simply spread > between the remaining machines.. > > It looks *really* cool stuff, and by *Oracles* stats, beats any other > clustered databases in real world situations. > > If only I could blag the boss for a ?1,000,000 budget for a bunch of compaq > servers >:-) > > Mark > > -Original Message- > Greenfield > Sent: Friday, July 13, 2001 03:51 > To: Multiple recipients of list ORACLE-L > > > Mark, isn't RAC just the upgrade for OPS? Then that would > make it a 'standby' for the instance, but not a standby for the > database, no? > > Am I misunderstanding something? > > y > > Mark Leith wrote: > > > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > > of the main points they discussed about 9i, was the use of Real > Application > > Clusters (RAC). Of course you have to be running on Compaq hardware at the > > moment, but it takes the need for a standby away, as you essentially just > > plug the standby in to the cluster, and make use of it's computing power, > > instead of having the standby just stood waiting for a failure.. > > > > Just a thought.. > > > > Mark > > > > -Original Message- > > Turner > > Sent: Thursday, July 12, 2001 08:26 > > To: Multiple recipients of list ORACLE-L > > > > Anyone know if the standby in 9i can be in readonly mode while the logs > are > > being applied? I've heard about this as being the case and also that this > > isn't > > the case. > > > > Thanks, Dave Turner > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL P
RE: 9i standby
Yes, you are right. OPS is no longer, long live RAC (Real Application Cluster). Rumor is that Oracle will produce software for HAL9000 later this year. Dave Bowman. > -Original Message- > From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 13, 2001 4:42 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 9i standby > > > > Mark Leith wrote: > > > No it is not the upgrade of OPS as I understand. They even > put OPS down > > themselves saying that it was sparsely used, and far to > complicated to set > > up. > > Th king is dead; long live the king! OPS was sparsely used, so they > renamed it. I'm reading a book about the Communist system and the > KGB in the USSR, and this sounds vaguely familiar. > > > > > What RAC does, is essentially link every machine together > in to a "cluster", > > then each physical machine can touch the same database concurrently > > (probably on a central storage unit). There is no actual > "standby" when this > > is in use, as all machines connected to the cluster work > together - but if > > one of the machines has a hardware failure, the load is > simply spread > > between the remaining machines.. > > Which is exactly what OPS did. You had several machines linked > to a centrally stored db. One wen't down, the others picked up the > slack. > > A fat lot I know, I never used it. But I'm pretty sure that's what OPS > was all about. I'm sure they've added some functionality. At least, > I *hope* they've added some functionality. > > When the central storage goes down, the RAC instances have nothing > to run against. That's where standby comes in. It duplicates the > central storage. > > As I said, I've never done either of these, AND I'm unemployed. So > I MUST be an expert! > > Have a great weekend. > > Yosi > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Mark Leith wrote: > No it is not the upgrade of OPS as I understand. They even put OPS down > themselves saying that it was sparsely used, and far to complicated to set > up. Th king is dead; long live the king! OPS was sparsely used, so they renamed it. I'm reading a book about the Communist system and the KGB in the USSR, and this sounds vaguely familiar. > > What RAC does, is essentially link every machine together in to a "cluster", > then each physical machine can touch the same database concurrently > (probably on a central storage unit). There is no actual "standby" when this > is in use, as all machines connected to the cluster work together - but if > one of the machines has a hardware failure, the load is simply spread > between the remaining machines.. Which is exactly what OPS did. You had several machines linked to a centrally stored db. One wen't down, the others picked up the slack. A fat lot I know, I never used it. But I'm pretty sure that's what OPS was all about. I'm sure they've added some functionality. At least, I *hope* they've added some functionality. When the central storage goes down, the RAC instances have nothing to run against. That's where standby comes in. It duplicates the central storage. As I said, I've never done either of these, AND I'm unemployed. So I MUST be an expert! Have a great weekend. Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
Brian, They didn't actually say what hardware they ran on other than "Compaq". There was a little discussion about this after the actual presentation with other attendees also, but I shouldn't get too worried about de-support of this solution at all. The actual day was an Oracle/Compaq release day (with Compaq sponsoring), and they both seem to be working really well together to get this done. Even if they do write the Alpha chip off - do you really think that they would not first bundle the software in to an intel chip? :) In my opinion that is the sole reason they bought Digital out huh? Still learning all this though, and have a fair bit of reading to do I guess.. :) Mark -Original Message- McGraw Sent: Friday, July 13, 2001 03:37 To: Multiple recipients of list ORACLE-L Mark - I saw the same presentation @ IOUG. Do you recall if they were running on the Compaq Alphas? A few days ago I recall someone saying that they would be wary of Oracle continuing support for Oracle on the Alpha chip, since Compaq has pretty much written it off. Brian Mark Leith wrote: > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > of the main points they discussed about 9i, was the use of Real Application > Clusters (RAC). Of course you have to be running on Compaq hardware at the > moment, but it takes the need for a standby away, as you essentially just > plug the standby in to the cluster, and make use of it's computing power, > instead of having the standby just stood waiting for a failure.. > > Just a thought.. > > Mark > > -Original Message- > Turner > Sent: Thursday, July 12, 2001 08:26 > To: Multiple recipients of list ORACLE-L > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this > isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
No it is not the upgrade of OPS as I understand. They even put OPS down themselves saying that it was sparsely used, and far to complicated to set up. What RAC does, is essentially link every machine together in to a "cluster", then each physical machine can touch the same database concurrently (probably on a central storage unit). There is no actual "standby" when this is in use, as all machines connected to the cluster work together - but if one of the machines has a hardware failure, the load is simply spread between the remaining machines.. It looks *really* cool stuff, and by *Oracles* stats, beats any other clustered databases in real world situations. If only I could blag the boss for a ?1,000,000 budget for a bunch of compaq servers >:-) Mark -Original Message- Greenfield Sent: Friday, July 13, 2001 03:51 To: Multiple recipients of list ORACLE-L Mark, isn't RAC just the upgrade for OPS? Then that would make it a 'standby' for the instance, but not a standby for the database, no? Am I misunderstanding something? y Mark Leith wrote: > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > of the main points they discussed about 9i, was the use of Real Application > Clusters (RAC). Of course you have to be running on Compaq hardware at the > moment, but it takes the need for a standby away, as you essentially just > plug the standby in to the cluster, and make use of it's computing power, > instead of having the standby just stood waiting for a failure.. > > Just a thought.. > > Mark > > -Original Message- > Turner > Sent: Thursday, July 12, 2001 08:26 > To: Multiple recipients of list ORACLE-L > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this > isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Mark, isn't RAC just the upgrade for OPS? Then that would make it a 'standby' for the instance, but not a standby for the database, no? Am I misunderstanding something? y Mark Leith wrote: > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > of the main points they discussed about 9i, was the use of Real Application > Clusters (RAC). Of course you have to be running on Compaq hardware at the > moment, but it takes the need for a standby away, as you essentially just > plug the standby in to the cluster, and make use of it's computing power, > instead of having the standby just stood waiting for a failure.. > > Just a thought.. > > Mark > > -Original Message- > Turner > Sent: Thursday, July 12, 2001 08:26 > To: Multiple recipients of list ORACLE-L > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this > isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Mark - I saw the same presentation @ IOUG. Do you recall if they were running on the Compaq Alphas? A few days ago I recall someone saying that they would be wary of Oracle continuing support for Oracle on the Alpha chip, since Compaq has pretty much written it off. Brian Mark Leith wrote: > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > of the main points they discussed about 9i, was the use of Real Application > Clusters (RAC). Of course you have to be running on Compaq hardware at the > moment, but it takes the need for a standby away, as you essentially just > plug the standby in to the cluster, and make use of it's computing power, > instead of having the standby just stood waiting for a failure.. > > Just a thought.. > > Mark > > -Original Message- > Turner > Sent: Thursday, July 12, 2001 08:26 > To: Multiple recipients of list ORACLE-L > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this > isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
Regardless of the degree of wilderness, no financial institiution whatsoever (HMOs included) can not afford to lose ANY data. The only way for making sure that everythin is replicated onto another machine all the time is OPS. > -Original Message- > From: Stephane Faroult [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 12, 2001 6:56 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 9i standby > > > "Gogala, Mladen" wrote: > > > > Replication happens in discrete chunks and there is a > distinct possibility > > of losing data if replication was used in banks. Banks and > other financial > > institutions are using OPS with EMC or DiskShark (IBM) based remote > > replication > > > Hmmm. Banks are two different worlds, the staid world of > retail banking > and the wild wild one of investment banking. > > -- > Regards, > > Stephane Faroult > Oriole Corporation > Voice: +44 (0) 7050-696-269 > Fax:+44 (0) 7050-696-449 > Performance Tools & Free Scripts > -- > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one of the main points they discussed about 9i, was the use of Real Application Clusters (RAC). Of course you have to be running on Compaq hardware at the moment, but it takes the need for a standby away, as you essentially just plug the standby in to the cluster, and make use of it's computing power, instead of having the standby just stood waiting for a failure.. Just a thought.. Mark -Original Message- Turner Sent: Thursday, July 12, 2001 08:26 To: Multiple recipients of list ORACLE-L Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
Can you tell us please what are specifics in configuring database for such load. Alex Hillman -Original Message- Sent: Thursday, July 12, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Properly designed and configured replication environments, especially on 8i+, can handle a phenomenal transaction level. I've worked with sites that replicate 20GB+ a day and db performance is excellent. On the other hand, I've also worked with sites that were such a mess that replicating 100MB a day was an effort. I think there's just less margin for error in designing and configuring a replication environment when you're dealing with that high a transaction load. My $.02 -- Anita --- Brian McGraw <[EMAIL PROTECTED]> wrote: > Most of the high-volume replicated sites that I have > heard of over the past few years use Quest's > Shareplex. I've had no experience with Clustra. > > Brian > -- > -- > | Brian McGraw -- Oracle DBA | > | Central Alabama Oracle Users Group | > || > | mailto:[EMAIL PROTECTED] | > | http://bmcgraw.home.mindspring.com | > -- > > David Turner wrote: > > > Thanks. If anyone else knows of anything out there > for really high volume replication over > > a WAN it would be appreciated. I was under the > impression that banks, credit card companies, and > > telephone companies were replicating there data > using Oracle but it doesn't look like it. > > Anyone know what they are using? It also seems > like for certain apps they would have to > > use synchronous replicatiion. Has anyone had any > experience with Clustra? > > > > Dave > > > > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE > TESTA wrote: > > > Page 61 of Oracle 9i, Data Guard concept.pdf > > > > > > says the standby can be in one of 2 states, open > for read-only or in managed recovery mode. if its > open in read only, it can't have logs applied. I've > not gotten around to testing that 9i concept yet. > although it looks like it will be kewl to flip > between primary and standby WITHOUT rebuilding :) > > > > > > hth, joe > > > > > > > > > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > > > > > Anyone know if the standby in 9i can be in > readonly mode while the logs are > > > being applied? I've heard about this as being > the case and also that this isn't > > > the case. > > > > > > Thanks, Dave Turner > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: David Turner > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L > > > (or the name of mailing list you want to be > removed from). You may > > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Brian McGraw > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: 9i standby
"Gogala, Mladen" wrote: > > Replication happens in discrete chunks and there is a distinct possibility > of losing data if replication was used in banks. Banks and other financial > institutions are using OPS with EMC or DiskShark (IBM) based remote > replication Hmmm. Banks are two different worlds, the staid world of retail banking and the wild wild one of investment banking. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
there are actually two kinds of "standby" that they are talking about in 9i.. if you use the logminer to generate the SQL for the standby db, then you are applying SQL statements to the standby and you can run read-only transactions about it. If you go to oracle online ed, there is a presentation on high availability there that you can sign up for (free registration) and it talks about this. Rachel >From: "JOE TESTA" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: 9i standby >Date: Thu, 12 Jul 2001 12:05:57 -0800 > >Page 61 of Oracle 9i, Data Guard concept.pdf > >says the standby can be in one of 2 states, open for read-only or in >managed recovery mode. if its open in read only, it can't have logs >applied. I've not gotten around to testing that 9i concept yet. although >it looks like it will be kewl to flip between primary and standby WITHOUT >rebuilding :) > >hth, joe > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > >Anyone know if the standby in 9i can be in readonly mode while the logs are >being applied? I've heard about this as being the case and also that this >isn't >the case. > >Thanks, Dave Turner >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: David Turner > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
Any papers/books you can recommend on getting it 'right'? -Original Message- Sent: Thursday, July 12, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Properly designed and configured replication environments, especially on 8i+, can handle a phenomenal transaction level. I've worked with sites that replicate 20GB+ a day and db performance is excellent. On the other hand, I've also worked with sites that were such a mess that replicating 100MB a day was an effort. I think there's just less margin for error in designing and configuring a replication environment when you're dealing with that high a transaction load. My $.02 -- Anita --- Brian McGraw <[EMAIL PROTECTED]> wrote: > Most of the high-volume replicated sites that I have > heard of over the past few years use Quest's > Shareplex. I've had no experience with Clustra. > > Brian > -- > -- > | Brian McGraw -- Oracle DBA | > | Central Alabama Oracle Users Group | > || > | mailto:[EMAIL PROTECTED] | > | http://bmcgraw.home.mindspring.com | > -- > > David Turner wrote: > > > Thanks. If anyone else knows of anything out there > for really high volume replication over > > a WAN it would be appreciated. I was under the > impression that banks, credit card companies, and > > telephone companies were replicating there data > using Oracle but it doesn't look like it. > > Anyone know what they are using? It also seems > like for certain apps they would have to > > use synchronous replicatiion. Has anyone had any > experience with Clustra? > > > > Dave > > > > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE > TESTA wrote: > > > Page 61 of Oracle 9i, Data Guard concept.pdf > > > > > > says the standby can be in one of 2 states, open > for read-only or in managed recovery mode. if its > open in read only, it can't have logs applied. I've > not gotten around to testing that 9i concept yet. > although it looks like it will be kewl to flip > between primary and standby WITHOUT rebuilding :) > > > > > > hth, joe > > > > > > > > > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > > > > > Anyone know if the standby in 9i can be in > readonly mode while the logs are > > > being applied? I've heard about this as being > the case and also that this isn't > > > the case. > > > > > > Thanks, Dave Turner > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: David Turner > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L > > > (or the name of mailing list you want to be > removed from). You may > > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Brian McGraw > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing List
Re: 9i standby
Properly designed and configured replication environments, especially on 8i+, can handle a phenomenal transaction level. I've worked with sites that replicate 20GB+ a day and db performance is excellent. On the other hand, I've also worked with sites that were such a mess that replicating 100MB a day was an effort. I think there's just less margin for error in designing and configuring a replication environment when you're dealing with that high a transaction load. My $.02 -- Anita --- Brian McGraw <[EMAIL PROTECTED]> wrote: > Most of the high-volume replicated sites that I have > heard of over the past few years use Quest's > Shareplex. I've had no experience with Clustra. > > Brian > -- > -- > | Brian McGraw -- Oracle DBA | > | Central Alabama Oracle Users Group | > || > | mailto:[EMAIL PROTECTED] | > | http://bmcgraw.home.mindspring.com | > -- > > David Turner wrote: > > > Thanks. If anyone else knows of anything out there > for really high volume replication over > > a WAN it would be appreciated. I was under the > impression that banks, credit card companies, and > > telephone companies were replicating there data > using Oracle but it doesn't look like it. > > Anyone know what they are using? It also seems > like for certain apps they would have to > > use synchronous replicatiion. Has anyone had any > experience with Clustra? > > > > Dave > > > > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE > TESTA wrote: > > > Page 61 of Oracle 9i, Data Guard concept.pdf > > > > > > says the standby can be in one of 2 states, open > for read-only or in managed recovery mode. if its > open in read only, it can't have logs applied. I've > not gotten around to testing that 9i concept yet. > although it looks like it will be kewl to flip > between primary and standby WITHOUT rebuilding :) > > > > > > hth, joe > > > > > > > > > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > > > > > Anyone know if the standby in 9i can be in > readonly mode while the logs are > > > being applied? I've heard about this as being > the case and also that this isn't > > > the case. > > > > > > Thanks, Dave Turner > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: David Turner > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L > > > (or the name of mailing list you want to be > removed from). You may > > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Brian McGraw > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EX
RE: 9i standby
Replication happens in discrete chunks and there is a distinct possibility of losing data if replication was used in banks. Banks and other financial institutions are using OPS with EMC or DiskShark (IBM) based remote replication facilities. I know that Oxford Health Plans uses 4-way parallel server for both data safety and performance reasons. -Original Message- Sent: Thursday, July 12, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Thanks. If anyone else knows of anything out there for really high volume replication over a WAN it would be appreciated. I was under the impression that banks, credit card companies, and telephone companies were replicating there data using Oracle but it doesn't look like it. Anyone know what they are using? It also seems like for certain apps they would have to use synchronous replicatiion. Has anyone had any experience with Clustra? Dave On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote: > Page 61 of Oracle 9i, Data Guard concept.pdf > > says the standby can be in one of 2 states, open for read-only or in managed recovery mode. if its open in read only, it can't have logs applied. I've not gotten around to testing that 9i concept yet. although it looks like it will be kewl to flip between primary and standby WITHOUT rebuilding :) > > hth, joe > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
How to restore the online logs in case of failover? Is there any mechanism available to restore to the point of failure? I believe standby database only applies archived logs (Assuming we can't archive the current logs in case of failure). Thanks. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 9i standby Page 61 of Oracle 9i, Data Guard concept.pdf says the standby can be in one of 2 states, open for read-only or in managed recovery mode. if its open in read only, it can't have logs applied. I've not gotten around to testing that 9i concept yet. although it looks like it will be kewl to flip between primary and standby WITHOUT rebuilding :) hth, joe >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>Anyone know if the standby in 9i can be in readonly mode while the logs arebeing applied? I've heard about this as being the case and also that this isn'tthe case. Thanks, Dave Turner-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: David Turner INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: 9i standby
Most of the high-volume replicated sites that I have heard of over the past few years use Quest's Shareplex. I've had no experience with Clustra. Brian -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- David Turner wrote: > Thanks. If anyone else knows of anything out there for really high volume >replication over > a WAN it would be appreciated. I was under the impression that banks, credit card >companies, and > telephone companies were replicating there data using Oracle but it doesn't look >like it. > Anyone know what they are using? It also seems like for certain apps they would have >to > use synchronous replicatiion. Has anyone had any experience with Clustra? > > Dave > > On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote: > > Page 61 of Oracle 9i, Data Guard concept.pdf > > > > says the standby can be in one of 2 states, open for read-only or in managed >recovery mode. if its open in read only, it can't have logs applied. I've not >gotten around to testing that 9i concept yet. although it looks like it will be kewl >to flip between primary and standby WITHOUT rebuilding :) > > > > hth, joe > > > > > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > > > Anyone know if the standby in 9i can be in readonly mode while the logs are > > being applied? I've heard about this as being the case and also that this isn't > > the case. > > > > Thanks, Dave Turner > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: David Turner > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Thanks. If anyone else knows of anything out there for really high volume replication over a WAN it would be appreciated. I was under the impression that banks, credit card companies, and telephone companies were replicating there data using Oracle but it doesn't look like it. Anyone know what they are using? It also seems like for certain apps they would have to use synchronous replicatiion. Has anyone had any experience with Clustra? Dave On Thu, Jul 12, 2001 at 03:04:30PM -0400, JOE TESTA wrote: > Page 61 of Oracle 9i, Data Guard concept.pdf > > says the standby can be in one of 2 states, open for read-only or in managed >recovery mode. if its open in read only, it can't have logs applied. I've not >gotten around to testing that 9i concept yet. although it looks like it will be kewl >to flip between primary and standby WITHOUT rebuilding :) > > hth, joe > > > > >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>> > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i standby
I don't think so. My understanding was that you may open the standby in read only mode, but I don't think that you can have the database open in the read only mode and apply logs at the same time. Not before oracle 12j, anyway. -Original Message- Sent: Thursday, July 12, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Page 61 of Oracle 9i, Data Guard concept.pdf says the standby can be in one of 2 states, open for read-only or in managed recovery mode. if its open in read only, it can't have logs applied. I've not gotten around to testing that 9i concept yet. although it looks like it will be kewl to flip between primary and standby WITHOUT rebuilding :) hth, joe >>> [EMAIL PROTECTED] 07/12/01 03:26PM >>>Anyone know if the standby in 9i can be in readonly mode while the logs arebeing applied? I've heard about this as being the case and also that this isn'tthe case. Thanks, Dave Turner-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: David Turner INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
9i standby
Anyone know if the standby in 9i can be in readonly mode while the logs are being applied? I've heard about this as being the case and also that this isn't the case. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).