Replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Replication

  1. #1
    Join Date
    Nov 2002
    Posts
    30

    Replication

    I'm in the process of creating a reporting 8i database of several tables from several different 8i databases. I was planning to use snapshots but then a requirement of real time data on the reporting database was brought up. I have done something like this in the days of Oracle 8 via a data synchronization C/Pro C program. However, in that case there was quite a bit of business rule enforcement that justified the use of code.

    Does anyone have any tips on how this can be done using any built in Oracle mechanisms? Will Advanced Replication work? I've never used it before.

    Thanks!

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You should investigate Oracle Enterprise Manager and its GUI tool that can do Advanced replication for you..


    Think about adavanced asynchronous replication .Asyncronous advanced replication uses a store and forward mechanism. When I
    insert a row into my local copy of table T, Oracle will store in a queue on the same machine a copy of that transaction. After commit, Oracle will PUSH that copy of that transaction to the remote site and replay it. Hence advanced async replication uses a store and forward mechanism. If the network is down or the remote database is unavailable, transactions are just queued up locally and
    will get propagated when the systems are all available again.

    regards
    Hrishy
    Last edited by hrishy; 03-05-2003 at 09:25 AM.

  3. #3
    Join Date
    Sep 2001
    Posts
    37

    Re: Replication

    Originally posted by dre1988
    I'm in the process of creating a reporting 8i database of several tables from several different 8i databases. I was planning to use snapshots but then a requirement of real time data on the reporting database was brought up.
    Maybe the easiest way to implement your reports enforcing the real time data requeriment is using Database Links.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Re: Re: Replication

    Originally posted by ccastaneda
    Maybe the easiest way to implement your reports enforcing the real time data requeriment is using Database Links.
    Yes i agree databse links are the easiest and they are real time just forget replication..

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width