Setting up a 2nd snapshot replication site
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Dec 2006 17:10:12 +1100
Hi all,
We are currently using advanced replication with snapshot replication to
replication from a master to a slave destination. Now we'd like
establish a 2nd replication destination but taking a copy of 1st
replication site and then registering it with the master site. Is this
possible? Can we just shutdown SLAVE #1, bring it up as SLAVE #2 with
new DBID and SID, and then push out replication to both sites? How do we
go about registering the 2nd replication site so that the master will
know that there are now 2 replication sites?
I don't want to start the 2nd replication site from scratch. I need to
use the 1st replication database as a starting point as it has about
400GB of data and replicating that from scratch is going to take a long
time.
TIA,
Leng.
------------------------------------------------------------------
Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108
Ph: +61-3-9840-3832
Notice:
This e-mail and any attachments are confidential and may contain legally
privileged information and/or copyright material of Hansen Technologies Limited
or third parties. Copying, distributing, disclosing, commercialising or
otherwise acting in reliance on this e-mail and any attachments is strictly
prohibited unless you are the addressee of this e-mail and have written
permission to do so. If you have received this e-mail in error please delete
this e-mail (including any copies and attachments) and contact Hansen
Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any
views expressed in this e-mail are those of the individual sender and may not
necessarily reflect the views of or be a commitment by the organisation, except
where the individual sender has the authority and expressly states them to be
so.
Other related posts:
