Snapshot style replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Snapshot style replication

  1. #1
    Join Date
    Mar 2002
    Posts
    60
    Is replication possible between different versions..

    I have 2 instances A and B
    Both on 8.0.5.2.1 right now

    A is a master and site B has snapshots (replicated nightly/refresh)

    I want to upgrade site A to 8.1.7....
    Is it possible to still maintain the snapshot replication
    with A on 8.1.7 and B on 8.0.5??

    What steps I would need to take to maintain replication after upgrading A?

    Please help

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I did it between 7.3 and 8.0.5. I don't see why you couln't do it... Although I do remember we had problems with fast refreshes because of the rowid changing....
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2002
    Posts
    60
    This is what I found on ORACLE 8i migration guide..

    To successfully interoperate, however, you must observe the following restrictions:

    Oracle8i snapshot sites can only interact with Oracle7 Release 7.3.3 or greater master sites.

    Oracle8i master sites can only interact with Oracle7 Release 7.3.4 or greater snapshot sites and with Oracle7 Release 7.3.3 or greater master sites.

    After migrating a master site to Oracle8i, perform a complete refresh of all of associated snapshot sites.

    The last line tells that if master site (A) is upgraded to 8.1.7. a complete refresh is needed for all snapshots sites(B)...
    So in essence I have to re-create all snapshots..
    which is a lengthy process..
    Is my understanding correct here??
    Please help

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