Re: Off-Line Replication

Joel,

Thanks for your reply. The reason I want the copy is that I am a lucky one and remote work from home 3 days a week where I have another Oracle set-up for development work. I need to refresh my home system each week with the latest data as I also do some analysis as well as development. The phone line would be too slow for replication. SQL server make it easier and advertise their transaction log as a means of backup and synchronising two databases.

Michael

joel.thrasher wrote in message
<01bd3c07$209debe0$013a37a6_at_0302165162711542>...
>Michael....What you are describing (copying an archived redo log file from
>system a to system b) is what Oracle sells as its standby database. But
>there are a few conditions. 1) The system being copying to/updated cannot
>be up and running for users (with a standby database). 2) You have the
>money for matching systems ( you really don't want a cheaper - read slower
>- system for your backups). 3) You have an efficient means of transferring
>archived redo's from system a to b. Of course you must be in archivelog
>mode. Oracle began allowing the technology with 7.1.6 provided that Oracle
>personnel configured the systems. The product was introduced as a
>stand-alone feature (pun) in version 7.3. Realistically, the systems
>SHOULD be connected, because you want to automate the transfer of archived
>redo's. Of course, if the other system must be active you should consider
>Symmetric Replication, or build your own using the distributed option. Any
>way you do it you should have the systems connected.
>
>I hope this helps.
>
>Joel
>
Received on Thu Feb 19 1998 - 00:00:00 CST