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.

  • 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 '14 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 '14 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 '14 at 9:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.