In this example, we are going to migrated golden gate from 11g to 19c. As part of migration, we need to perform the below steps.
Step 1: Prerequisites.
1. Make sure that you can connect to GGSCI prompt.
2. check whether you have write access under $GGS_HOME
Step 2: Encrypt the GGSUSER password.
Note : Welcome123 is the actual password which will get encrypt.
GGSCI > ENCRYPT PASSWORD Welcome123 BLOWFISH ENCRYPTKEY DEFAULT
Using Blowfish encryption with DEFAULT key.
Encrypted password: AACAAAAAAAKKKAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF
Algorithm used: BLOWFISH
Step 3: Login to the db using the encrypted password in GGSCI prompt.
GGSCI > dblogin USERID GGSUSER, password AACAAKKKAAAAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF, BLOWFISH encryptkey default
Successfully logged into database.
Step 4: create extract
GGSCI > edit params E_extract01
--ADD the below value and save it.
EXTRACT E_extract01
SETENV (ORACLE_SID="test")
SETENV (ORACLE_HOME="/opt/app/user/oracle/product/19.8.0")
USERID GGSUSER@test, password AACAAAAAAAAAAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF, BLOWFISH ENCRYPTKEY DEFAULT
EXTTRAIL /opt/app/test/ggs/19.1.0.0.4/trails/g1
DISCARDFILE /opt/app/test/ggs/19.1.0.0.4/dirrpt/e_extract01.dsc, APPEND
GETTRUNCATES
NOCOMPRESSDELETES
REPORTROLLOVER ON sunday
REPORTCOUNT EVERY 60 MINUTES, RATE
REPORT At 23:59
TABLE user.A8;
TABLE user.BACKUP;
TABLE user.BAND;
GGSCI > add extract E_extract, integrated tranlog, begin now
EXTRACT (Integrated) added.
GGSCI > register extract E_extract database
2024-06-06 03:13:03 INFO OGG-02003 Extract E_extract successfully registered with database at SCN 31393982.
GGSCI > ADD RMTTRAIL /opt/app/test/ggs/19.1.0.0.4/trails/g1, EXTRACT E_extract01
RMTTRAIL added.
Step 4: start the extract
GGSCI > start E_extract01
Step 5: create the pump process to communicate to the target server.
GGSCI > edit params P_pump01
STATOPTIONS REPORTFETCH
REPORTCOUNT EVERY 10 MINUTES, RATE
RMTHOST target_localhost, MGRPORT 8000, TcpBufSize 1048576, TcpFlushBytes 1048576
RMTTRAIL /opt/app/target_host/acfs/ggs/ggs19c/trails/Bag/b1
PASSTHRU
TABLE user.A8;
TABLE user.BACKUP;
TABLE user.BAND;
GGSCI > ADD EXTRACT P_pump01, EXTTRAILSOURCE /opt/app/test/ggs/19.1.0.0.4/trails/g1
EXTRACT added.
GGSCI > ADD RMTTRAIL /opt/app/target_test/acfs/ggs/ggs19c/trails/BAG/b1, EXTRACT P_pump01
RMTTRAIL added.
Step 6: start the Pump process
GGSCI > start P_pump01
Step 7: Validate the extract and the pump process.
If still RBA is 0, then cross check below link
