Home » Server Options » Replication » Replication between oracle 10g & 11g (oracle database ,11g ,linux)
Replication between oracle 10g & 11g [message #360035] Wed, 19 November 2008 05:28 Go to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi all ,

we have master site and materialized view site that both of them are oracle 10g now , we decided to upgrade materialized view site to 11g , I want to be sure about this things :

1- we can have snapshot logs on 10g and snapshots on 11g and if i upgrade target database to 11g any problem will not happen for doing fast refresh from snapshot logs ?

2- some times some problrm happens for my snapshot logs and becasue that i want to use oracle 11g Compare feature for compare source table with target snapshot and find the changes , anyone have better solution for sorting this problem ?

best regards.

[Updated on: Wed, 19 November 2008 05:29]

Report message to a moderator

Re: Replication between oracle 10g & 11g [message #360116 is a reply to message #360035] Wed, 19 November 2008 12:06 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

Quote:
>>1- we can have snapshot logs on 10g and snapshots on 11g and if i upgrade target database to 11g any problem will not happen for doing fast refresh from snapshot logs ?


I have upgraded my oracle 9.2.0.8 database (advanced replication) to 10.2.0.3

After upgrate everything fine. I'm not faced any issue.

Now I suggess to you take complete cold/hot backup from 10g (both master & mv site) -> restore to test env -> upgrade to 11g and then come back to me with your all issues.

Quote:
2- some times some problrm happens for my snapshot logs
.

Please share your shapshot logs problem to us. Then only we can learn/guide to you

Babu

[Updated on: Wed, 19 November 2008 12:07]

Report message to a moderator

Previous Topic: Hange while refreshing materialized view
Next Topic: Refresh group
Goto Forum:
  


Current Time: Thu Mar 28 18:48:50 CDT 2024