Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract
3
EXAMPLE 2: CONFIGURATION OF REAL-TIME DOWNSTREAM MINING
DATABASE FOR INTEGRATED EXTRACT FOR A RAC SOURCE ............ 21
EXAMPLE 3: CONFIGURATION OF ARCHIVE LOG DOWNSTREAM
MINING DATABASE FOR INTEGRATED EXTRACT .................................... 22
Configure the downstream database to archive the local redo data .................................................. 23
Prepare the source database to send archive to the mining database ............................................... 23
Set up Extract to capture changes from archived logs sent by DBMS1 ............................................ 24
EXAMPLE 4: CONFIGURATION OF ARCHIVE LOG DOWNSTREAM
MINING DATABASE FOR INTEGRATED EXTRACT FOR A RAC SOURCE
........................................................................................................................ 25
EXAMPLE 5: CONFIGURATION OF ARCHIVE LOG DOWNSTREAM
MINING DATABASE FOR INTEGRATED EXTRACT FOR MULTIPLE
SOURCE DATABASES ................................................................................. 27
Configure the downstream mining database to archive the local redo data ..................................... 28
Prepare the first source database to send archive to the mining database ....................................... 29
Prepare the second source database to send archive to the mining database ................................... 30
Set up Extract1 to capture changes from archived logs sent by DBMS1 .......................................... 30
Set up Extract2 to capture changes from archived logs sent by DBMS2 .......................................... 31
EXAMPLE 6: CONFIGURATION OF ARCHIVE LOG DOWNSTREAM
MINING FOR 1
ST
SOURCE DATABASES AND REAL-TIME DOWNSTREAM
MINING FOR 2
ND
SOURCE DATABASE ....................................................... 33
Configure the downstream database to archive the local redo data .................................................. 34
Prepare the first source database to send archive logs to the mining database ................................ 35
Prepare the mining database to accept redo from the 2
nd
source database ...................................... 36
Prepare the 2
nd
source database to send redo to the mining database .............................................. 36
评论0