From: "Robert Noga" Newsgroups: comp.databases.oracle.server,comp.databases.oracle,comp.databases.oracle.misc Subject: Re: Oracle Replication question Date: Thu, 8 Aug 2002 17:37:19 +0200 Organization: Portal Gazeta.pl -> http://www.gazeta.pl Lines: 41 Message-ID: References: <3d523de1$1@news.starhub.net.sg> NNTP-Posting-Host: 217.153.105.20 X-Trace: news.gazeta.pl 1028821014 4177 217.153.105.20 (8 Aug 2002 15:36:54 GMT) X-Complaints-To: usenet@agora.pl NNTP-Posting-Date: Thu, 8 Aug 2002 15:36:54 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Priority: 3 X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-User: czenx X-MSMail-Priority: Normal as far as i understand you should to use oracle replication management. you can setup replication between tables with some limitation (long datatypes). you can parametrise this replication by creating variety of group with different needs (periodic time) for replication. generaly you need see replication docs from oracle (database documentation) and run oracle enterprise manager/replication manager. i've got some experience in this area, ask if you want. Robert. "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 : -- Serwis Usenet w portalu Gazeta.pl -> http://www.gazeta.pl/usenet/