| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: replication with Indexes
Sounds like your talking yourself into multi-master replication.=20
You can replicate all the types of objects you've mentioned, with the exception of the sequences. You will need to tailor the sequences to stop them creating duplicates. The simplest solution (assuming you don't need the sequences to imply any order), is to make the production database sequences produce even numbers, and the stand-by database sequence produce odd numbers, that way they will always be unique.
As far as replicating the database, I would suggest you 'clone' the production database (essentially a renamed copy the datafiles), then overlaying replication definitions on top. You can choose to using existing objects and data when you setup the replication.
Recovery from backups will be a problem? If you need to restore, you'll have to and re-apply replication!
I'd also suggest you upgrade/patch to the terminal release of 8i ie 8.1.7.4.13 before doing any of this...
-----Original Message-----
From: Seema Singh [mailto:oracledbam_at_hotmail.com]
Sent: 26 May 2004 21:13
To: oracle-l_at_freelists.org
Subject: RE: replication with Indexes
Thanks for your reply.
The db2(snapshot site) wILL be for failover site.therfore I want to
setup=20
updatable replication on snapshot site.IN CASE of failoure of master
site we=20
can pint application to ssnapshot site.I want to replicate whole
schema.How=20
to replicate whole schema?I want to replicate all procedures/functions
etc.
Snapshot site would be also available currently for select by setting=20
application configuration.
Please suggest.
Thx
-Seema
>From: Stephen.Lee_at_DTAG.Com
>Reply-To: oracle-l_at_freelists.org
>To: oracle-l_at_freelists.org
>Subject: RE: replication with Indexes
>Date: Wed, 26 May 2004 11:54:30 -0500
>
> > -----Original Message-----
> > I wanted to replicate db1 to db2 with all indexes how to do this?
>
>I'm a little rusty on what features are in this version of Oracle
versus
>that version Oracle. But, ASSUMING you can do this in 8.1.6.3, you can
>export the master tables without rows; import them into the second=20
>database.
>After I do this, I keep only the primary key constraints and drop the
>others. Then:
>
>In the master database:
>create snapshot logs on the master tables.
>If needed, grant select on the master tables AND on the mlog$ tables to
>whatever user the database link uses.
>
>In the secondary database:
>
>create the database link to masterdb. For this I create a READONLY
user
>which has readonly (duh) privilege on the master and mlog$ tables is
the
>master database. And I make the database link a public database link.
>
>create snapshot xyz on prebuilt table refresh force as select * from
>owner.xyz_at_masterdb;
>exec dbms_snapshot.refresh('XYZ','C')
>
>connect to replication schema owner guy.
>create the refresh group and refresh job.
>exec dbms_refresh.add('REFGROUP','OWNER.XYZ')
>
>test it:
>exec dbms_job.run(##)
>
>I think 8.1.6 supports the "on prebuilt table" thing.
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu May 27 2004 - 04:06:37 CDT
 |
 |