RE: One way replication in multimaster environment

2002-05-03 Thread James A
ers (or from "central" database). I looked at the "advanced multimaster replication" (offered by Oracle) and didn't find a way to use it as a solution to my problem. I ended up designing my "own" replication process and writing code (triggers and queue for replicated dat

Re: One way replication in multimaster environment

2002-05-03 Thread Igor Neyman
on the "source" database, and at the same time "source" databases should not be getting data from their piers (or from "central" database). I looked at the "advanced multimaster replication" (offered by Oracle) and didn't find a way to use it as a sol

Re: One way replication in multimaster environment

2002-05-03 Thread Igor Neyman
Not, if you want "real-time" row-level replication. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 11:33 AM > Looks like snapshots make the mos

Re: One way replication in multimaster environment

2002-05-03 Thread Peter Barnett
ultimaster to push transaction from site > Y and Z to site X. > How can i set - off the replication in site X , > cause i dont want site X to > push the changes to other sites or to disable > row-level replication. > > any idea ? > > Thanks > > > > &

One way replication in multimaster environment

2002-05-02 Thread Softhome - Fico
hi experts, In my replicated environment, i have one site (example: site X) that consolidate data from other sites (example : site Y and Z). I'm using multimaster to push transaction from site Y and Z to site X. How can i set - off the replication in site X , cause i dont want site X to

Re: REPLICATION/FAIL OVER

2002-04-20 Thread Nikunj Gupta
Hi, You can go with Materilaized Views (Snapshots) with Fast / Complete Refresh depending on the network traffic / bandwidth, amount of data you want to transfer... in these tables.. You can setup different type of refresh for each of the table.. Since it is once a day.. Trigger / Replication

RE: REPLICATION/FAIL OVER

2002-04-20 Thread Seema Singh
TED]> >Subject: RE: REPLICATION/FAIL OVER >Date: Fri, 19 Apr 2002 14:43:25 -0800 > >Seema - > I have only done just a little testing of replication, so I'm hardly >the expert. I believe the answer to your question is yes. You can make db1 >the master site for

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
Seema - I have only done just a little testing of replication, so I'm hardly the expert. I believe the answer to your question is yes. You can make db1 the master site for the 4 tables and db2 the master site for the 3 tables. The bigger question is whether changes can be ma

RE: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
OTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: REPLICATION/FAIL OVER >Date: Fri, 19 Apr 2002 13:09:19 -0800 > >Seema - Advanced replication is a feature of Oracle Enterprise Edition, so >if you have that, you should be set. Based on your d

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
Seema - Advanced replication is a feature of Oracle Enterprise Edition, so if you have that, you should be set. Based on your description, updatable snapshots may meet your needs, and be simpler to configure and maintain. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Gene Sais
Seema, Excuse me for spitting out ideas. You mentioned replication as one method and were unsure of this method. You also expressed interest in alternative methods besides replication of which I mentioned a few. Good luck in your search. Gene PS. BTW, replication is not a good tool for HA

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
Seema - Another alternative you may want to check out is transportable tablespaces, since you just want to sync the databases up once/day. I think this will require less maintenance than replication. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday

RE: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
Is there any additional software required if i go to advanced replication? -seema >From: DENNIS WILLIAMS <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: REPLICATION/FAIL OVER >Date: Fri,

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -seema >From: "Gene Sais" <[EMAIL PROTE

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -Dinesh >From: "Gene Sais" <[EMAIL PROTE

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Gene Sais
Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. >>> [EMAIL PROTECTED]

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, I

REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other

REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other

Replication errors

2002-04-15 Thread Nguyen, David M
I have problem with our database replication between Master and Slaves. Looked at alert.log, I found following errors. Can someone please explain to me what following errors mean and how do I fix them? ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386 ORA

Re: Replication Question

2002-04-10 Thread Yechiel Adar
Hello John We are doing master to master replication. Both are 8.1.6 on NT. When we need to rebuild we delete and create both databases and import the data into both. Then we run a script that dynamically generate the proper procedure calls for all the tables in the schema and run them. I

Replication Question

2002-04-10 Thread John Weatherman
Hi All, I have recently been handed the task of setting up master-master replication on our existing production environment (yes, I am in test to start!). Because this is an established site with a lot of historical data, we would like to use Offline Instantiation as detailed in Note 68657.1

Re: Oracle Replication - is it "on" by default?

2002-04-09 Thread Yechiel Adar
Hello Paul Open the replication manager and check there if you have replication working. I concur with Rachel. If you have replication you WILL remember activating it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent:

RE: Oracle Replication - is it "on" by default?

2002-04-08 Thread Freeman, Robert
Simple snapshot replication (provided by materialized views or mviews) is enabled when you use the Enterprise Edition of the database at any time as long as job_queue_processes is > 0, and, of course, you have defined some mviews. This is one way replication. If you want 2 way (advanced, mu

RE: Oracle Replication - is it "on" by default?

2002-04-08 Thread DENNIS WILLIAMS
Paul - The only book I've found specific to Oracle replication is: Oracle Distributed Systems by Charles Dye. It is pretty good. Replication isn't the easiest thing to learn. The fundamental questions to ask are: is your application designed to work with replication? Are you j

Re: Oracle Replication - is it "on" by default?

2002-04-08 Thread Rachel Carmichael
I believe the scripts to create the various stored procedures come with the Enterprise Edition but Replication is not something that Oracle does on its own. At best, the packages are automatically created when you create the database. There is a LOT of work you have to do on your own to set up

Oracle Replication - is it "on" by default?

2002-04-08 Thread Paul Vincent
Hi folks, we've never identified any requirement here for using any kind of replication. Consequently I know nothing whatsoever about Oracle Replication. Now I've been asked whether or not we use Oracle Replication and, if so, whether it can be disabled. So can anyone tell me whether R

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-26 Thread Sakthi , Raj
Well, being in health care industry myself I know too well what do you mean. Apart from 100s of tousands of $ lost every hour we are down, we have to take some safety also into account. As to the question of advanced replication, having implemented multi-master replication myself I know what a

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-26 Thread Freeman, Robert
considerations associated with it. Amazon outage might represent lost sales, outage of this system could represent lost lives. Needless to say, I'm being very careful about the architecture we use. I've implemented replication solutions before as well as stand-by database solutions. But

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-26 Thread Sakthi , Raj
the data in real time or near real time…? Example , like said before quest software’s shareplex. This can give you master-master replication capabilities. Just my 2 cents. Cheers, RS --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Log application services can run in f

RE: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]

2002-03-25 Thread Rachel Carmichael
; -Original Message- > > Sent: Monday, March 25, 2002 11:48 AM > > To: Multiple recipients of list ORACLE-L > > > > > > What type of requirement or SLA do you have in regards to keeping > the > > instances in sync? > > > > -Joe > > > &

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it's

RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
s each region continues to function. It sounds complicated and requires fast inter-connectivity between each region and the SAN. Sound reasonable? ROR mª¿ªm >>> [EMAIL PROTECTED] 03/25/02 02:38PM >>> Robert, Given what you've said it would appear that your only choice

RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread DENNIS WILLIAMS
your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites, but it'

Re:RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Ron Rogers
our only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent on the archive log switch points and that does not address the differe

Re:RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread dgoulet
___Reply Separator Author: "Freeman; Robert " <[EMAIL PROTECTED]> Date: 3/25/2002 2:52 PM Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really c

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Sakthi , Raj
Monday, March 25, 2002 11:48 AM > To: Multiple recipients of list ORACLE-L > > > What type of requirement or SLA do you have in > regards to keeping the > instances in sync? > > -Joe > > --- "Freeman, Robert " <[EMAIL PROTECTED]> > wrote: >

RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
Thanks for your thoughts Dick! Actually, look into Data Guard in 9i and you will find that you are no longer constrained by archive log switches!! I'm really concerned with the conflict resolution issues with MM Replication. I've done something like this once before, with only 2 sites

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
data. Data loss is tolerable. That being said, they want to replicate between the four sites, and they want to use replication conflict resolution rules to deal with outages and resync of the databases. They claim it will work great, I'm thinking, yea right sounds like a bear to manage. I'd

Re:RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread dgoulet
Robert, Given what you've said it would appear that your only choice is going to be symetric/advanced replication, multi-master. The conflict resolution rules may be a bear to set up with 5 sites though. Using a standby db would not be very effective since data updates are dependent o

RE: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]

2002-03-25 Thread Freeman, Robert
his freedom away from him. > > > > -Original Message- > Sent: Monday, March 25, 2002 11:48 AM > To: Multiple recipients of list ORACLE-L > > > What type of requirement or SLA do you have in regards to keeping the > instances in sync? > > -Jo

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Brian_P_MacLean
(from the mouth of a replication non-quru) I think you answered your own question. If no network and they want to be up, then synchronous replication is not an option. You're only option is asynchronous replication. One answer that I'm sure EMC would luv to sell you is networked ra

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Deshpande, Kirti
f list ORACLE-L What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Stand-by (Oracle9i Data Guard) vs. Replication > > Folks, > > I have a mission critical system we are archi

Re: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]

2002-03-25 Thread Yigal Ran
ping the > instances in sync? > > -Joe > > --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > > Stand-by (Oracle9i Data Guard) vs. Replication > > > > Folks, > > > > I have a mission critical system we are architectonic right now. >

Re: [RE: Stand-by (Oracle9i Data Guard) vs. Replication]

2002-03-25 Thread Yigal Ran
ping the > instances in sync? > > -Joe > > --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > > Stand-by (Oracle9i Data Guard) vs. Replication > > > > Folks, > > > > I have a mission critical system we are architectonic right now. >

RE: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
" <[EMAIL PROTECTED]> wrote: > Stand-by (Oracle9i Data Guard) vs. Replication > > Folks, > > I have a mission critical system we are architectonic right now. > There is some argument of the merits of replication vs. using > Standby database going on. > > Cur

Re: Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Joe Raube
What type of requirement or SLA do you have in regards to keeping the instances in sync? -Joe --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Stand-by (Oracle9i Data Guard) vs. Replication > > Folks, > > I have a mission critical system we are architect

Stand-by (Oracle9i Data Guard) vs. Replication

2002-03-25 Thread Freeman, Robert
Stand-by (Oracle9i Data Guard) vs. Replication Folks, I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on. Current we have 4 sites that we will be replicating data back and forth between. There

Oracle replication

2002-03-20 Thread Farnsworth, Dave
I am beginning to read on Oracle replication. I will need to eventually replicate from Oracle to a DB2 database. Has anyone done this and if so, was it a total pain to set up? Also, besides TFM and some docs on metalink, does anyone have any good links to any papers or articles on Oracle

Replication trouble

2002-03-05 Thread Henrik Ekenberg <[EMAIL PROTECTED]>
Hi, We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc) We are using read-only snaphots with multiple groups (one/schema), replication every minute.  Simple 'select *' replication. One of the snapshot process seems to stall and all access to one of the tables in the actua

RE: replication question

2002-03-04 Thread James A
: replication question I have used both.     Replication, like archive log movement , happens whenever you set it up to happen.   That can be anywhere from every minute to once a day to beyond.  It just depends on your needs.  In the case of my old job, we had replication happening at

Re: replication question

2002-03-04 Thread Rahul Dandekar
Well, you could open standby DB only for read only access (8i) whereas in replication, both or all (more than 2) databases could be up and open to users all the times.   Each DML causes substantial overhead as each transaction needs to be propogated and applied at all the master sites

Re: replication question

2002-03-04 Thread Rahul Dandekar
Why not just Updateable Snapshots?   Updateable Snapshots allow users to query and update a local replicated data set even when disconnected from the master site. More relevant is the fact that... Updateable Snapshots require fewer resources than multimaster replication, while still

RE: replication question

2002-03-04 Thread Kevin Lange
I have used both.     Replication, like archive log movement , happens whenever you set it up to happen.   That can be anywhere from every minute to once a day to beyond.  It just depends on your needs.  In the case of my old job, we had replication happening at different times for

RE: replication question

2002-03-04 Thread James Ambursley
Is replication faster than a standby database. As I understand it, the standby database will be receive arch logs at preset intervals.  Does replication have the same functionality and about how much data is sent to the replicated site.     -Original Message-From: [EMAIL

Multimaster Replication Doubt...

2002-03-04 Thread Rahul Dandekar
1. It is my understanding that Oracle 7.x has continuous purge of the propogated deftrans. There is no option of scheduling periodic purge at specific time. Am I correct? 2. How to schedule continuous purge of propogated deftrans in Oracle 8i from command line? prompt SCHEDULE P

RE: replication question

2002-03-04 Thread Kevin Lange
The way I see it .  the question comes down to whether or not you need two way replication or just one way.   If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route.   If all you need are data changes from 1

RE: Replication - Oracle 9i - problem

2002-03-04 Thread Jesse, Rich
Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 04, 2002 8:48 AM To: Multiple recipients of list ORACLE-L I think what Vladimir is referring is the DBCA screen (atleast in 8i) which asks if Replication option is to be used or not. And if checked, it ca

Re: Replication - Oracle 9i - problem

2002-03-04 Thread Rahul Dandekar
I think what Vladimir is referring is the DBCA screen (atleast in 8i) which asks if Replication option is to be used or not. And if checked, it calls catrep.sql after "dbcreate - catalog - catproc" +Rahul - Original Message - To: "Multiple recipients of list ORACLE-L&quo

Re: replication question

2002-03-04 Thread Bunyamin K. Karadeniz
Thank you Rahul , Do you accept visa or bank check ? :)   Bunyamin - Original Message - From: Rahul Dandekar To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 2:43 PM Subject: Re: replication question Depends on your need. You can have

RE: Replication - Oracle 9i - problem

2002-03-04 Thread אדר יחיאל
Replication is not part of database configuration. After you build the database and create objects inside you use the replication manager to create the replication on the objects you want to replicate. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- >

Re: replication question

2002-03-04 Thread Rahul Dandekar
Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async   I donot have any expereince of snapshot replication. But, if

Re: Replication - Oracle 9i - problem

2002-03-04 Thread Rahul Dandekar
Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 5:08 AM > During install of Oracle9i EE software, I have c

Replication - Oracle 9i - problem

2002-03-04 Thread Vladimir Barac - posao
During install of Oracle9i EE software, I have checked "replication" option. Afterwards, when I run "Database Configuration Assistant" there is no check box related to replication??? When I run "Oracle Installer" after the install, it confirms that replicatio

replication question

2002-03-04 Thread Bunyamin K. Karadeniz
Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time.   Do I need Advanced replication  or basic replication . ? How can I understand that replication is

RE: replication gui

2002-03-01 Thread אדר יחיאל
In Oracle 9i it is in start>Programs>Oracle replication manager. The program in 9i is repmgr.exe. In Oracle 8i it is in start>programs>oracle home>extended administration>replication manager. The program is 8i is 'oemapp.bat repmgr'. Yechiel Adar, Mehish Comput

Re: replication gui

2002-02-28 Thread Suzy Vordos
On Unix it's part of DBAStudio, maybe the same on NT. > "Bunyamin K. Karadeniz" wrote: > > I have oracle ent. edition on my machine (NT) but do not have the link > of adv. replication manager in start panel . > What is the name of exe starting the Replication ma

replication gui

2002-02-28 Thread Bunyamin K. Karadeniz
I have oracle ent. edition on my machine (NT) but do not have the link of adv. replication manager in start panel . What is the name of exe starting the Replication manager ? thank you bunyamin

RE: Need some white papers on replication

2002-02-27 Thread Michael Cupp
Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's "Replication DOs and DON'Ts" is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standb

RE: Need some white papers on replication

2002-02-27 Thread Babich , Sergey
ent: Tuesday, February 26, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's "Replication DOs and DON'Ts" is excellent. All of Lawrence To's White Papers are good Graceful Sw

RE: Need some white papers on replication

2002-02-27 Thread Michael Cupp
| Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 26, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's "Replication DOs and DON'

RE: Need some white papers on replication

2002-02-27 Thread Farnsworth, Dave
:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's "Replication DOs and DON'Ts" is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standby

RE: Need some white papers on replication

2002-02-27 Thread Boivin, Patrice J
es Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 26, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's "Replication

Re:RE: Need some white papers on replication

2002-02-26 Thread dgoulet
ACLE-L Hi All, i really need some papers on replication and any book recommendations. TiA!! -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 5

RE: Need some white papers on replication

2002-02-26 Thread Baker, Barbara
; To: Multiple recipients of list ORACLE-L > Subject: RE: Need some white papers on replication > > Erm, Barb, I think your left pinky finger isn't quite on the homerow of > your > keyboard. Did you mean: www.orafaq.com/faqrepl.htm? > > :) > > Rich Jesse

RE: Need some white papers on replication

2002-02-26 Thread Jesse, Rich
ssage- Sent: Tuesday, February 26, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Bill: Anita Bardeen's "Replication DOs and DON'Ts" is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standby Database

RE: Need some white papers on replication

2002-02-26 Thread DENNIS WILLIAMS
Bill - The two books I have been able to locate are: Oracle Distributed Systems by Charles Dye, an O'Reilly book Data Replication - Tools and Techniques for Managing Distributed Information by Marie Buretta, a Wiley book -Original Message- Sent: Tuesday, Februa

RE: Need some white papers on replication

2002-02-26 Thread Nick Wagner
Title: RE: Need some white papers on replication Here are a couple http://www.quest.com/whitepapers/shareplex/ Not OAR... but a better solution. Nick -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 12:55 PM To: Multiple

RE: Need some white papers on replication

2002-02-26 Thread Baker, Barbara
Bill: Anita Bardeen's "Replication DOs and DON'Ts" is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standby Database Oracle8i Standby Database Mission Critical Recovery Within 30 Minutes I

RE: Need some white papers on replication

2002-02-26 Thread Khedr, Waleed
Bill, I'm starting on this also and it seems to me that Oracle Doc is not bad. Waleed -Original Message- Sent: Tuesday, February 26, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Hi All, i really need some papers on replication and any book recommendations.

Need some white papers on replication

2002-02-26 Thread Bill Conner
Hi All, i really need some papers on replication and any book recommendations. TiA!! -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: 8i Replication: administrator privs

2002-02-24 Thread אדר יחיאל
Hello Suzy We work with replication and repadmin is doing all the administration for replication. I would not allow non dba to mess around with it. Wrong parameters can kill your performance and or cause the application to stop working. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED

RE: 8i Replication: administrator privs

2002-02-22 Thread Bellows, Bambi
Somehow this seems like a bad idea. I've always restricted administration to REPADMIN, but maybe I lack outside-of-the-box thinking I'm kinda an outside-the-box-kind-of-gal. But, yeah, that looks like a recipe for failure to me too. Bambi. -- Please see the official ORACLE-L FAQ: http

8i Replication: administrator privs

2002-02-22 Thread Suzy Vordos
Would you consider this to be an open opportunity for disaster? Granting each application schema 'dbms_repcat_admin.grant_admin_any_schema' in a replicated environment. Here's the example: REPADMIN = replication administrator/propagator/receiver ACCT_APP = application s

Re: replication setup questions

2002-02-22 Thread Peter Barnett
f implementing replication for remote > sites. What I have not > been able to gather from documentation to date is > what are the pre steps required to setup a > replicated site(master > destination) > what are the steps to bring the replicated site > online aft

RE: replication setup questions

2002-02-22 Thread DENNIS WILLIAMS
James - Given the breadth of your questions, you may want to purchase "Oracle Distributed Systems" by Charles Dye, an O'Reilly book. It is the only book I have found on Oracle replication. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Frid

replication setup questions

2002-02-22 Thread James Ambursley
I am thinking of implementing replication for remote sites. What I have not been able to gather from documentation to date is what are the pre steps required to setup a replicated site(master destination) what are the steps to bring the replicated site online after the master

RE: Oracle Advanced Replication

2002-02-19 Thread אדר יחיאל
I will write my comments in your response. Scroll down. One point I would like to stress: We are planing to drop replication and work with the live DB in case one DB goes down. In this case we will work for some days without replication until we rebuild the dba machine and then do an export

RE: RE: Oracle Advanced Replication

2002-02-18 Thread Jim Hawkins
t: Friday, February 15, 2002 2:09 PM >To: Multiple recipients of list ORACLE-L > > > >All this talk of replication is really nice. > >SharePlex for Oracle, can handle master to master replication. Conflicts are >handled via pl/sql procedures inside the database, where you

RE: Oracle Advanced Replication

2002-02-18 Thread Nick Wagner
Title: RE: Oracle Advanced Replication Not yet, support for those objects are scheduled for this winter.   Nick -Original Message-From: Ji, Richard [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 12:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle

Re: Oracle Advanced Replication

2002-02-18 Thread Rahul Dandekar
Adar, How do you take care of backups? I mean, what kind of backups do you take? How are you addressing the scenario of incomplete recovery? Following are some of my doubts. 1. What kind of Backup should be taken? Online or Offline? Does replication would generate substantially higher

RE: Oracle Advanced Replication

2002-02-17 Thread אדר יחיאל
Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file was

RE: Oracle Advanced Replication

2002-02-15 Thread Ji, Richard
Title: RE: Oracle Advanced Replication Nick,   Does SharePlex support user defined object types?   Richard -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle

RE: Oracle Advanced Replication

2002-02-15 Thread Dejam, Ruth
-L > Subject: RE: Oracle Advanced Replication > > All this talk of replication is really nice. > > SharePlex for Oracle, can handle master to master replication. Conflicts > are handled via pl/sql procedures inside the database, where you can > determine exactly what

RE: Oracle Advanced Replication

2002-02-15 Thread Nick Wagner
Title: RE: Oracle Advanced Replication All this talk of replication is really nice.   SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict

RE: Oracle Advanced Replication

2002-02-15 Thread Gary Weber
Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions -

RE: Oracle Advanced Replication

2002-02-15 Thread Baker, Barbara
---u possible down time of a standby? one out-of-synch condition with Advanced Replication can cause you hours of down time. I'd suggest you continue to question the consultants about the choice of AR as a failover solution. If you're running at least 8.1.7, standby is normall

Re: Oracle Advanced Replication

2002-02-15 Thread Stephane Faroult
; Bummer... > > Pete > > --- [EMAIL PROTECTED] wrote: > > Pete, > > > > Have you considered using a standby database? > > > > More suitable for failover than Advanced > > Replication, and > > much easier to implement and maintain. > > > >

RE: Oracle Advanced Replication

2002-02-15 Thread Peter Barnett
the database. Somehow, this did not quite seem right! We finally agreed to try replication. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Peter - Since nobody seems to be answering your > question, I guess you get > the second tier here. I have not used Oracle > Replication,

Re: Oracle Advanced Replication

2002-02-15 Thread Jared . Still
Pete, Have you considered using a standby database? More suitable for failover than Advanced Replication, and much easier to implement and maintain. Jared Peter Barnett <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/14/02 03:03 PM Please respond to ORACLE-L To: Mu

<    1   2   3   4   >