Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g.

We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far as we know.

For Persistent queue, we have import/export option available. But there are some Buffered queues as well need to be replicated.

can anyone guide how we can avoid data loss in this situation.

Appreciate any help.

share|improve this question
1  
My knowledge of the AQ system is limited, but I don't think you're supposed to replicate the queues themselves. That would result in simultaneous identical changes happening. Aren't you supposed to only replicate the data changes that result from the messages? –  Andrew Brennan Apr 10 at 12:48
    
If DML on one of your table somehow results in AQ message generation, it will be same when those underlying tables are replicated by GG, as long as your application code doesn't change. –  Raj Apr 10 at 19:30
    
guys u did not get my point... i am talking about the messages which are in a queue waiting for their turn to be processed. and these are critical transaction messages in production. –  Ahsan Shah Apr 11 at 9:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.