Path: news.easynews.com!easynews!nntp.flash.net!prodigy.*.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr13.news.prodigy.com.POSTED!1af50a29!not-for-mail From: "Stephen Ferracioli" Newsgroups: comp.databases.oracle.server,comp.databases.oracle,comp.databases.oracle.misc References: <3d523de1$1@news.starhub.net.sg> Subject: Re: Oracle Replication question Lines: 38 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: NNTP-Posting-Host: 63.83.249.3 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr13.news.prodigy.com 1028827680 ST000 63.83.249.3 (Thu, 08 Aug 2002 13:28:00 EDT) NNTP-Posting-Date: Thu, 08 Aug 2002 13:28:00 EDT Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: Q[R_PJSCTS@UCU\Y\ROF_WPAUKXD@D@MGPW^OBPLAH[\BTUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Thu, 08 Aug 2002 17:28:00 GMT Xref: easynews comp.databases.oracle.server:157289 comp.databases.oracle:16847 comp.databases.oracle.misc:85325 X-Received-Date: Thu, 08 Aug 2002 10:25:09 MST (news.easynews.com) Retrofitting an existing system with Oracle replication is a risky proposition and IMO, and a mis-application of technology for what you seem to want to accomplish. Also IMO, the most cost effective solution is to perform standard scripted backup (a combination of cold and hot using RMAN) and recovery procedures. If you want to achieve continuous uptime you need to spend money. We are using EMC technology to perform what you want to do. We put our database in backup mode around 2AM, then we quickly update a BCV and then end backup mode. On Sunday morning we shutdown and update the BCV for a cold image. The cold image is then backed up to tape. Downtime is minimal. Just my $0.02 worth. Stephen Ferracioli Database Administrator "TOHSH" wrote in message news:3d523de1$1@news.starhub.net.sg... > Hi, > > I am having 2 server(HPUX) running Oracle. I would like to implement a > replication system where the database will be copied from Server A to > server B on a perodic timing. There is no requirement for real time data > replication. > > I know that there are a lot of replication software or HA package out in > the market, but I would only require the most basic and the most cost > efective solution. > > I have this idea, if is is posible to backup the Oracle DB on line and > dump the backups to disk. We will put the DB into Backup mode every X > hour and the things that will be backup are all the table space, archive > logs, control files and etc from server A. After that we will ftp these > backup files to server B where we will use the archive logs, control > files and etc to apply changes to the DB in server B. > > Please comment. > > Thanks, > TohSH >