Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: REPLICATION/FAIL OVER
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.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, April 19, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
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" <Gsais_at_co.palm-beach.fl.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: REPLICATION/FAIL OVER
>Date: Fri, 19 Apr 2002 10:08:50 -0800
>
>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.
>
> >>> oracledbam_at_hotmail.com 04/19/02 01:39PM >>>
>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 way to do
>that?If I go replication then can someone suggest which replication method
>would be good.
>Thx
>-Seema
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
>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: ListGuru_at_fatcity.com (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: Seema Singh INET: oracledbam_at_hotmail.com 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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: ListGuru_at_fatcity.com (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).Received on Fri Apr 19 2002 - 15:58:21 CDT
![]() |
![]() |