RE: Setting up a 2nd snapshot replication site
- From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
- To: <ajay_1ajay1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 14:42:29 +1100
The original tables in SLAVE#1 NOT created on PREBUILT tables (this
database was built by another DBA who should have know better!) So
dropping the MV on SLAVE#1 or SLAVE#2 will drop the underlying tables as
well. Wish Oracle would just make the underlying tables prebuilt by
default so that we don't run into such problems.
So is there anyway of registering SLAVE#2 and getting replication to
both slave destinations without have to recreate the MVs?
________________________________
From: Ajay [mailto:ajay_1ajay@xxxxxxxxx]
Sent: Sunday, 24 December 2006 6:08 AM
To: Leng Kaing; oracle-l@xxxxxxxxxxxxx
Subject: Re: Setting up a 2nd snapshot replication site
If you shutdown SLAVE #1 and bring it up as SLAVE #2 then you still have
only one slave.
You could make a copy of slave #1 to slave #2 and use it or you can make
a copy of the master itself. After making a copy you can define MV on
the pre-built table at slave #2 as select from master site. This will
register slave #2. Thanks
Leng Kaing <Leng.Kaing@xxxxxxxxxxx> wrote:
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.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
