OGG Upgrade steps on system hosting Goldengate during DB upgrade

 

OGG Upgrade steps on system hosting Goldengate during DB upgrade

 

BPEL Source details: DB:11.2.0.4 GG:12.3

1.       Comment out any autostart and autorestart parameters in manager parameter file.

2.       Restart mgr after Step 1.

--Assume that DB shutdown is at 12 AM(midnight), Below step shud be done 60-90 mins prior to DB shutdown(10.30 PM)

3. Stop Extract , pump processes on source

note the info of all the extract and pump

Stop extract process on source1(CIM) and source2(BPEL) wait until pump process all the trail files , then stop it.

 

                GGSCI> INFO EXTRACT group, SHOWCH

                GGSCI> SEND PUMP group LOGEND

                GGSCI> STOP EXTRACT group

3.       Edit the parameter file for both extract and pump and remove FORMAT RELEASE Parameter. And also update rmttrail parameter in Pump.

update existing one to _11g. and then Swap <processname>_prodday param file with <processname>.prm. Keep the copy of existing param file.

5. Check info pump and save the output.

Delete the pump and add it again with new target remote trail location.

6. alter extract,etrollover

7 . Alter the pump to read from new generated trail file : Example : alter <pump_name> , extseqno <newtrail file seq> extrba 0

alter <pump_name> , etrollover <<<< It will generate new trail file on site 3 >

 

Start extract and note down new trail file being generated

Steps on Target (OGG 11g home):

Comment out any autostart and autorestart parameters in manager parameter file.

Restart mgr after Step 1.

 

7. Wait until there is no lag on replicat except RCRAMER8 , stop replicat process.

-- RCEAMER8 is the process which will require reconfig

Stop Replicat,logend

STOP Replicat *

8. For extract on this server follow below:

Once application shutdown is completed:

Stop Extract , pump processes on CIM:

 

SEND EGCPUSER,logend

Run above until u get YES.

STOP EGCPUSER

Start EGCPUSER

SEND EGCPUSER,logend

STATS EGCPUSER

STOP EGCPUSER

Once EGPUSER is stopped, ensure that Pump has processed all transactions and then stop pump

SEND PP044EDF LOGEND

Run above until u get YES.

STOP PP044EDF

START PP044EDF

SEND PP044EDF LOGEND

STATS PP044EDF

STOP PP044EDF

Dblogin userid ggsuser,  password sh4d0wdb

Delete extract EGPUSER

DELETE EXTRACT PP044EDF

 

Dblogin userid ggsuser@p2can1d7.db.att.com,  password sh4d0wdb

STOP RCANOPI

STOP RCARMR66

STOP RCIRCUIT

STOP RCRAM00

STOP RCRAM00R

STOP RCRAMER1

STOP RCRAMER2

STOP RCRAMER3

STOP RCRAMER4

STOP RCRAMER5

STOP RCRAMER6

STOP RCRAMER7

STOP RCRAMER8

STOP RCRAMER9

STOP RCRAMERX

STOP RCRAMR99

STOP RCRAMR9X

STOP REXTNNN

STOP REXTPORT

STOP REXTRRR

STOP RPARTITN

STOP RPORT

STOP RPORT11

STOP RWKODOB1

 

5. Install OGG 12.3.0.1.4 under different home (Choose appropriate DB version during installation , choose for 12.1.0.2 database ) .

Get 770 permission on 12.3.0.1.4

chmod 770 12.3.0.1.4

6. Upgrade database on 12.1.0.2 .

(from the new GG HOME)(12.3 OGG home):

Connect to DB as sysdba:

.               SQL>@ulg.sql

                This script converts the existing supplemental log groups to the new format required by the new release.

                This step is required even if you plan to use the new triggerless capture method.

                The script should run without error; if errors occur, contact Oracle Support.

 

7. Copy goldengate process related files from old goldengate to the new 19c goldengate for 19c RDBMS like .prm and .cpe in appropriate directories.

Below needs to be done in 12.3 OGG HOME and after DB upgrade is done:

Dblogin userid ggsuser,  password sh4d0wdb Add extract egcpuser,tranlog,begin now Add exttrail /opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p2can1d7/lt,extract egpuser Add extract PP044EDF,exttrailsource /opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p2can1d7/lt Add rmttrail /opt/app/p2gcp1d23/acfs/ggs/ggs01/trails/IDIS_GG/nc,extract PP044EDF Copy all param files from dirprm directory of older home to new home cp /opt/app/p2can1d7/ggs/11.2.1.0.3/dirprm/* /opt/app/p2can1d7/ggs/12.3.1.0.4/dirprm Make necessary changes in param file. Ensure to add FORMAT RELEASE parameters in EXTRACT and Pump Param file Edit param EGCPUSER Edit param PP044EDF   Question: to generate the remote trail for target EDF, they will have to repoint there replicat to new trail being sent. Options available to us: 1.       ETROLLOVER PUMP for 5500 times 2.       Take backup of existing trails on target and then we restart remote trails from sequence 0

 

NOTE ! If your new goldengate version on target site is lower then source , you should add "format release " into the extract and pump for trail files , otherwise , the OGG lower version cannot read 12c trail file format.

 

 

11. Create all the replicats in new GG HOME:

ADD REPLICAT RCANOPI, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1cnp1d1/rt ADD REPLICAT RCARMR66, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCIRCUIT, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAM00, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAM00R, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER1, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER2, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER3, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER4, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER5, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER6, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER7, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER8, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMER9, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMERX, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMR99, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RCRAMR9X, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT REXTNNN, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT REXTPORT, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT REXTRRR, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RPARTITN, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RPORT, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RPORT11, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt ADD REPLICAT RWKODOB1, exttrail/opt/app/p2can1d7/ggs/12.3.1.0.4/trails/p1bbn1d9/rt

 

 

12 . Start replicat

 

13. After ensuring all goldengate processes are running, start the applications accessing the database.

14. Edit Manager Param file and add AUTOSTART and AUTORESTART parameter as per old home and also use PURGEOLDEXTRACTS command to point to new home

 

Post Maintenance task:

Empty the 11g Goldengate home