Upgrade GG from 12c to 19c:
It is recommended to upgrade both source as well as target OGG at same time.
Pre upgrade steps:
A. Verify that there are no open or uncommitted transactions:
send extract,showtrans
send extract ,logend
1. Stop The OGG Processes
On SOurce:
Stop extract *
stop extract pump
Stop mgr !
On target:
Ensure Rpelicat on target has finished processing all current DML and DDL data before stopping replicat.
send replicat,status
When EOF is received then:
stop replicat *
Stop mgr !
2. Take backup of OGG Homes
3. Extract and run installation files in machine - unzip the installer
4. Run 19c installer and uopgrade the OGG homes
Software location field enter existing goldengate home directory other wise there will be two homes
Unselect start manager otherwise existing processes will be deleted
Execute the ulg.sql script located in OGG home. The script converts existing supplemental log groups to format required by new release
Connect to db as sysdba
sqlplus / as sysdba
$OGG_HOME/ulg.sql
5. Decide which trail file release format to use
After the installation is completed,alter the primary extract processand pump process to write to new trail seq number using ETROLLOVEr command
alter extract ,etrollover
alter pump,etrollover
alter pump,extseqno <>,extrba 0
alter replicat,extseqno <>,extrba 0
If the target is also getting upgraded to 19c then no need to add FORMAT RELEASE parameter. If target is not getting upgraded then, use FORMAT RELEASE parameter in extract and Pump file.
EXTTRAIL ./dirdat/lt FORMAT RELEASE 12.3
6. Start the processes
No comments:
Post a Comment