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

Thread: oracle replication

  1. #1
    Join Date
    Mar 2001
    Posts
    16
    hello
    Is there any one who can help me about replication.who we can do .when to do.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Replication is a very broad field. I suggest you read related docs. To implement or not mainly depends on business requirements and/or availability of mission critical systems.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Replication is nothing but maintaining another copy of table data in another database for recovery and for query (report). Replication is of 2 types:
    1 Snapshot Replication
    2 Multi-Master Replication

    In the 1st case , new committed transactions will be copied into another database at table level. The data flows from only one direction.

    In the 2nd case, data can flow from either direction. This is difficult to maintain when there is a sequence number used in the PK column.

    The Multi-Master Replication is of two types - Active/Active and Active/Passive. In Active/Active replication both tables are updated/inserted/deleted. In Active/Passive, the data flows from one database to another only.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Precise and Cool Description. Thanks tamil...
    Reddy,Sam

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