| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Replication
Robin,
If you can have an hour of downtime, you could probably just create a clone of the original database and be done with it (but make sure you change the DB Name and the DBID if you are using RMAN). Of course, depending on your disk and network speed, this could take more or less that an hour. Try a small transfer and then do the math to determine how long it will take for you to copy/ftp all of the datafiles to another location.
Replication for the sake of setting up an extra database is one of the most ridiculous things I've heard. To begin with, if your schema isn't setup the way replication wants (all tables having primary keys or indexes for any alternate keys you specify during setup), replication can be very slow. I'm not certain if this effects the initial push of data from database A to database B or not, but that could be extremely time consuming if so. Can anyone confirm this one way or the other?
On the other hand, if you're going to use the old database for reporting and want it kept up to date, replication is probably a good idea. But learning replication in 10 days is asking for trouble. I agree with everyone else, it takes months to fully understand all the concepts and have a good grasp of what's going on inside the database, what can go wrong, and how to resolve problems....
Just my $.02
Alan
"Robin Li"
<rli_at_nyp.org> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.c Subject: Re: Replication
om
10/14/02 01:53
PM
Please respond
to ORACLE-L
Thanks to all who replied.
The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By using this
method, it will take about 4 hours downtime which the manager does not
accept. He says by using the replicating, one hour downtime will be
enough (who knows how he comes up this number?) And after the DB is cut
over,
he is going to use the DB on the old server as reporting.
Robin
Jared.Still_at_radisys.com wrote:
>
> Is this simply replicating data to another system read only?
>
> Replicated for what purpose? High Availability? Querying and reporting?
>
> Jared
>
> "Robin Li" <rli_at_nyp.org>
> Sent by: root_at_fatcity.com
> 10/14/2002 06:58 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: Replication
>
> Hi all,
>
> Does anyone have the appropriate time on implementing replication for a
> newbe?
>
> I am given a time frame on doing the replication for 10 days which is
> including testing on test server and move to production. I've never done
> that before, now just start reading. This DB is about 30G on Oracle
> 8.1.7.
>
> TIA
>
> Robin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robin Li
> INET: rli_at_nyp.org
>
> 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: 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).
-- Robin **************************************************************** * Robin Li * * Technical Specialist, DBA Phone#: (212) 297-3073 * * Information Services Fax#: (212) 297-4231 * * 333 East 38th Street, 2nd fl. E-mail: rli_at_nyp.org * * New York, NY 10016 * **************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robin Li INET: rli_at_nyp.org 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: 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: INET: alan.aschenbrenner_at_ihs.com 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: 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 Mon Oct 14 2002 - 17:48:31 CDT
 |
 |