Re: synchronize 2 instances

This method is very common - it's used in may shops that need a reporting database, as long as the users can deal with data that can be as old as 24 hours.

Make sure that your dbf files of your target database are placed in directories that are named the same as your source database so when you copy the source control files to the target, you don't get error message that Oracle can't find your dbf files.

Regards

Ron Bogdanoff
Sr. Software Engineer
Digital Market Inc.

In article <774epp$g1j$1_at_nnrp1.dejanews.com>,   kho_at_juno.com wrote:
> Hi,
>
> I need to copy an Oracle 8 database to another database on different machine
> every night. The target database will be read-only and the source database
> is used by a 24*7 system. One of my co-workers suggested me to use the
> archivelog of the source instance after the hot backup.
>
> Then, for the target instance, do the following:
> 1. Shutdown the instance
> 2. Copy the archivelog, control files of source instance to target
> 3. Restart the instance
> 4. unmount the database
> 5. Use "recover database" to let Oracle apply the new archivelog
>
> Do I miss anything in the above steps? What is the drawback to use such a
> method?
>
> Thanks,
> Kin
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 15:26:58 CST