Re: Is there any way to Synchronize 2 databases on Oracle 10g Standard One edition ?
From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Wed, 31 Mar 2010 06:49:34 -0700 (PDT)
Message-ID: <91abfe0b-c1bd-4ecf-909d-36706ed18e03_at_v20g2000yqv.googlegroups.com>
On Mar 31, 6:06 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> 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...
Date: Wed, 31 Mar 2010 06:49:34 -0700 (PDT)
Message-ID: <91abfe0b-c1bd-4ecf-909d-36706ed18e03_at_v20g2000yqv.googlegroups.com>
On Mar 31, 6:06 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> 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...
Noons,
>>There is a paper on that in MOS<<
Could you post MOS number of this document.
Thank you very much.
Thomas
Received on Wed Mar 31 2010 - 08:49:34 CDT