GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Advance Queue DB Migration - From host A (DB A) to host B (DB B)

edited Jun 1, 2018 4:11AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered ✓

Hi experts,

I have to migrate some databases with the following characteristics:

Situation:

Source:

OS: HP-UX (itanium) - HOST A

DB: Database A

Version: 11.2.0.2 ; 11.2.0.4

Target:

OS: Linux RH 7.4 - HOST B

DB: Database B

Version:11.2.0.4

Migration Method:

-Taking into account the different endian format, I will use a physical method (XTTS).

-The logic methods (expdp/impdp - OGG) are discarded by the customer (DB size ; license)

-Using XTTS method, all segments are migrated to the target, including " AQ$_QT_* ".

-Other objects (EVALUATION CONTEXT, QUEUE...) are migrated using expdp/impdp

Questions:

1-. Once migrated the database, is it necessary to execute an additional step (configuration or task or procedure) to enable the functioning of AQ in the target?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center