Prev: DBMS_LDAP
Next: Is there any way to Synchronize 2 databases on Oracle 10gStandard One edition ?
From: Frank van Bortel on 28 Mar 2010 10:39
Jia Lu wrote:
> Hi all
> I want to synchronize 2 databases with oracle 10g R2 standard One
> edition.
> How can I do it ?(With old 8i systems we created snapshots )
> and is there any better ways in 10g R2?
> Thank you.
> Best
> Lau. Lu
Streams. Transportable tablespaces.

But -as already mentioned- why change what's working, and still supported?

--

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply
From: Noons on 31 Mar 2010 06:06
Frank van Bortel wrote,on my timestamp of 29/03/2010 12:39 AM:

>> I want to synchronize 2 databases with oracle 10g R2 standard One
>> edition.
>> How can I do it ?(With old 8i systems we created snapshots )
>> and is there any better ways in 10g R2?
>> Thank you.
>> Best
>> Lau. Lu
> Streams. Transportable tablespaces.

Why not simply use manual standby? Archive redo logs and send them to the
remote site. Restore db from backup, mount with the snapcf copy of the
controlfile taken by rman at end of redo log archive, roll it forward, shut it
down or open read only or open resetlogs, depending on what is needed in the
second site. There is a paper on that in MOS.
Works for me - and has worked for a looong time - it's not buggy and fast...
 | 
Pages: 1
Prev: DBMS_LDAP
Next: Is there any way to Synchronize 2 databases on Oracle 10gStandard One edition ?