RE: Re: Logical StandBy question
I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didnt kwon that LSB are so bad. So do you think It is so bad that you dont put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thankyour previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de Carel-Jan EngelEnviado el: mircoles, 12 de noviembre de 2003 19:59Para: Multiple recipients of list ORACLE-LAsunto: RE: Re: Logical StandBy questionWalt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.regards, Carel-JanAt 09:19 12-11-03 -0800, you wrote: Stephane,What sort of problems can one expect from logical standby?I'm toying with the idea of using it as a replication database -- noadditional schema objects will be created, but users will have read-onlyaccess to it. It's one of the options I'm looking at.Seems to me like there was a thread on this a few months ago, but I'mnot sure...--WaltOn Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. --Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Walt Weaver INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C2743 BX WaddinxveenThe Netherlandstel. +31 (0) 182 640 428fax +31 (0) 182 640 429mobile+31 (0) 653 911 950e-mail [EMAIL PROTECTED]
RE: RE: Re: Logical StandBy question
I tried it on 9.2.0.3.0 running on two Linux machines. I doubt all bugs were fixed in 9.2.0.4. I currently consider LSB to be a prototype, an interesting foretaste of things to come, but hardly more. It of course depends on the size of the database, but couldn't you consider doing reporting on a Day - 1 database? Might be simpler to use your hot backups and recreate a backup database every night. Or perhaps use snaphots (sorry, materialized views) - traditional replication (you don't need the 'advanced' stuff). If the production database can bear the overhead. Anyway, if you are as lucky as I was, this is (rebuilding the database from your backups) what you may well end doing with LSB (plus the 26 step process each time - well, I wrote scripts to help). HTH, SF - --- Original Message --- - From: Juan Miranda [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 13 Nov 2003 00:34:25 I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didn?t kwon that LSB are so bad. So do you think It is so bad that you don?t put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thank your previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Carel-Jan Engel Enviado el: miercoles, 12 de noviembre de 2003 19:59 Para: Multiple recipients of list ORACLE-L Asunto: RE: Re: Logical StandBy question Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm. I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening. regards, Carel-Jan At 09:19 12-11-03 -0800, you wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Hi Juan, It is not the patch level that makes it unusable for standby. It's the complexity, limitations and elaborous management tasks that cause the problem. One single unsupported DML command can stop/suspend the SQL-Apply process at the standby, and you have to circumvent the problem manually before you can resume. That's something you definitely don't want in a standby environment. At the other end, when everything has been tested, tested, and tested, your users have no SQL*Plus/Toad/ODBC/whatever SQL-tool access to the primary database, you have reliable DBA's ;-), it can run pretty well, and it can be used for reporting purposes. Note that redolog forwarding doesn't mean SQL Apply. Let me clarify this. When running in Guaranteed protection mode, all (online) redolog information gets forwarded to the standby. This is done synchronously, so it is guaranteed that every transaction arrives at the standby when it's written in the redolog on the primary. The same applies to the other protegction modes, but some data divergence may be the result. But. After a logswitch and not earlier, logmining will start, and the SQL Apply process will start processing the transactions. This is called serialisation, and doesn't really scale! PSB remains in recovery mode, that uses less resources, and kan keep up pretty well on the sites I've installed it so far (right, Yong? ;-) ). What do you want to achieve with LSB? Off-line reporting facilities on actual data? How actual do you need them? When a daily refresh is enough consider this plan: Create a PSB, and keep it in Read-only mode. All redolog gets forwarded whatsoever, even in Read Only mode. Once, twice a day you switch the PSB to Recovery mode, wait until the waiting redologs have been applied, and switch back to Read Only mode. Has some limitations, not usable for all demands for offline reporting, but on the other hand, you know what your report is based on. Many DWH applications don't even want to have their data updated real-time, simply because succeeding reports will be uncomparable because variations in the daily workflow can affect the results. Another plan might be creating both an LSB and a PSB (can be done on a single machine when the size of your database allows you), and use the LSB for reporting, and the PSB for failover. I would strongly recommend not to use LSB for failover purposes. The techniques simply aren't mature enough. I hope 10g is better, can't wait to get a copy to investigate DG in 10g. I've developed some scripts, 900+ lines for (hot) instantiation, and twice as much for database control. Together with some (still undocumented) naming conventions, they make life pretty easy for the command-line oriented DBA. However, they're not finished yet (what script is?), and not completely bug-free. And, they're Korn-shll scripts, so not usable on Windoze. Regards, Carel-Jan -- There will allways be another last 10 bugs. -- At 00:34 13-11-03 -0800, you wrote: I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didn´t kwon that LSB are so bad. So do you think It is so bad that you don´t put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thank your previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Carel-Jan Engel Enviado el: miércoles, 12 de noviembre de 2003 19:59 Para: Multiple recipients of list ORACLE-L Asunto: RE: Re: Logical StandBy question Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm. I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening. regards, Carel-Jan At 09:19 12-11-03 -0800, you wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals
RE: Re: Logical StandBy question
Juan, I am using Physical Standby Database for Disaster Recovery situation andalso forREPORTS. I apply logs everyday in the morning and bring it up in READ ONLY mode. Developers can SELECT latest data from STANDBY database. I have created a DATABASE LINK for STANDBY database from X database. Now you can create REPORTSin X database by SELECTING data from STANDBY database. Less maintenance, reliable and good performance. The only disadvantage is STANDBY database is one day behind. Muqthar Ahmed DBA -Original Message-From: Juan Miranda [mailto:[EMAIL PROTECTED]Sent: Thursday, November 13, 2003 3:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: Logical StandBy question I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didn´t kwon that LSB are so bad. So do you think It is so bad that you don´t put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thankyour previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de Carel-Jan EngelEnviado el: miércoles, 12 de noviembre de 2003 19:59Para: Multiple recipients of list ORACLE-LAsunto: RE: Re: Logical StandBy questionWalt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.regards, Carel-JanAt 09:19 12-11-03 -0800, you wrote: Stephane,What sort of problems can one expect from logical standby?I'm toying with the idea of using it as a replication database -- noadditional schema objects will be created, but users will have read-onlyaccess to it. It's one of the options I'm looking at.Seems to me like there was a thread on this a few months ago, but I'mnot sure...--WaltOn Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. --Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Walt Weaver INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C2743 BX WaddinxveenThe Netherlandstel. +31 (0) 182 640 428fax +31 (0) 182 640 429mobile+31 (0) 653 911 950e-mail [EMAIL PROTECTED]
Logical StandBy question
Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
Short answer: look in the manuals. Longer answer: a LOGICAL standby database does not get updated in the same manner as a PHYSICAL standby database. Logical Standby is simply a database which is updated via SQL statements generated from the archived redo logs, not application of the archived redo logs themselves. so you can do anything in the logical standby (including creating additional indexes on the tables from the primary database) that you can do in a regular database with the exception (from memory so this may be wrong) that the tables that are in the primary database must be read-only in the standby --- Muqthar Ahmed [EMAIL PROTECTED] wrote: Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
The question was about LOGICAL standby database. From your point of view it is like a regular database and you can create schema in it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:14 PM Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
There are two kinds of standby database: physical and logical. The original post referred to logical standby. The normal state of a logical standby database is open, and it can contain schemas and objects that do not exist in the primary. Check the manuals again! ;-) --- Jose Luis Delgado [EMAIL PROTECTED] wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
I think you're confusing physical and logical standby databases. Logical standby databases aren't in recovery mode. --Walt Weaver Bozeman, Montana On Wed, 2003-11-12 at 09:09, Jose Luis Delgado wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
took me exactly two clicks to find the following: Oracle9i Release 2 (9.2) New Features in Data Guard The features and enhancements described in this section were added to Data Guard in Oracle9i release 2 (9.2). * Logical standby database Until now, there has been only the physical standby database implementation, in which the standby database can be in either recovery mode or in read-only mode. A physical standby database is physically equivalent to the primary database, and, while the database is applying logs it cannot be opened for reporting and vice versa. A logical standby database has the same logical schema as the primary database but may have different physical objects, such as additional indexes. With logical standby databases, you can have the database available for reporting and applying the logs to the standby log at the same time. --- Jose Luis Delgado [EMAIL PROTECTED] wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Hi all, As Stephane told, logical standby (LSB) has a lot of tiny little exceptions and special issues to cope with. I've done one implementation in production until now (did appr. 20 Physical Standby sites as well). But, even that site uses 2 LSB's as reporting systems, and has a PSB for the HA issue. Feel free to ask more. Regards, Carel-Jan At 08:49 12-11-03 -0800, you wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
RE: Re: Logical StandBy question
there was a thread -- Paul Baumgartel started it looking for information on logical standby. IIRC, he found that there were a few gotchas -- check the fatcity archives. I do know that since it's based on Logminer technology, it has the same limitations that Logminer does --- Walt Weaver [EMAIL PROTECTED] wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Walt, I'll step in here--my experiment with Logical Standby convinced me that it is not ready for prime time. 1. Major bugs caused apply process to crash repeatedly. 2. Difficulty filtering out DDL from apply stream. 3. Horrendous performance of apply process--frequently the elapsed time to apply changes on the standby was one or two orders of magnitude greater than that of the source operation. --- Walt Weaver [EMAIL PROTECTED] wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: Logical StandBy question
Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm. I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening. regards, Carel-Jan At 09:19 12-11-03 -0800, you wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
Re: Logical StandBy question
Walt Weaver wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt Walt, This is basically my feelings after the tests : o Properly monitoring is rather difficult. You must check at both ends to have more than a vague feeling that things could have gone awry. This is just one aspect of a general user-friendliness which first shows up in a 26 step installation procedure. o The automated check for incompatibilities (there is normally a view to tell you what will not work) is fairly deficient. I have (by mistake) tested on a schema with lots of (unsupported) LONGs, do you think I got any warning? o Although a surprisingly high number of DDL commands are successfully replicated (including CREATE USER, etc), others are understandably not replicated (when you extend a tablespace - well the directory lay-out may be different, so it makes sense. The workaround is to have AUTOEXTEND ON, which I am usually reluctant to have), something as mundane as RENAME is not - with all the ensuing consequences you may imagine. o I have found no way to ensure that the time gap between the two databases stayed below some predefined threshold. Not sure that issuing regular ALTER SYSTEM SWITCH LOGFILE on the master is enough. I wanted to test the performance impact of logical standby by running an import, first without it, then with it, and also to measure how fast the copy was catching up, but I've given up my tests after a few ORA-600 errors. The concept is great, and I am sure to have another look at it ... later. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Logical StandBy question
Thanks for the info on logical standbys everyone. The opinions on it seem rather unanimous.:) --Walt On Wed, 2003-11-12 at 12:14, Stephane Faroult wrote: Walt Weaver wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt Walt, This is basically my feelings after the tests : o Properly monitoring is rather difficult. You must check at both ends to have more than a vague feeling that things could have gone awry. This is just one aspect of a general user-friendliness which first shows up in a 26 step installation procedure. o The automated check for incompatibilities (there is normally a view to tell you what will not work) is fairly deficient. I have (by mistake) tested on a schema with lots of (unsupported) LONGs, do you think I got any warning? o Although a surprisingly high number of DDL commands are successfully replicated (including CREATE USER, etc), others are understandably not replicated (when you extend a tablespace - well the directory lay-out may be different, so it makes sense. The workaround is to have AUTOEXTEND ON, which I am usually reluctant to have), something as mundane as RENAME is not - with all the ensuing consequences you may imagine. o I have found no way to ensure that the time gap between the two databases stayed below some predefined threshold. Not sure that issuing regular ALTER SYSTEM SWITCH LOGFILE on the master is enough. I wanted to test the performance impact of logical standby by running an import, first without it, then with it, and also to measure how fast the copy was catching up, but I've given up my tests after a few ORA-600 errors. The concept is great, and I am sure to have another look at it ... later. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
