Zero Downtime Upgrade Guide for Oracle

10.3 HotFix 1

Back Next

Transfer the Previous Load Table Data

You can copy the data from the previous load table in the active environment to the previous load table in the passive environment. The data in the previous load table is not transferred during the replication process. If you do not replicate the previous load table, the first stage batch job that you run after the passive environment becomes active might process all the data in the landing table. The names of the previous load tables end in _PRL.

Before you run a stage batch job, ensure that the upgrade is complete. If you run a stage job before the upgrade is complete, the data that the stage batch job adds to the source previous load tables is not added to the target previous load tables.

Generate the

prl_expdp.prm

and

prl_impdp.prm

parameter files for the previous load table in the active environment.

From SQL*Plus in the active environment, run the following command:

DECLARE 
   IN_TYPE NUMBER; 
BEGIN 
   IN_TYPE := 1;--generate prl_expdp.prm file 
   CMXZDT.write_prl_exp_imp_param(IN_TYPE => IN_TYPE); 
   IN_TYPE := 2; --generate prl_impdp.prm file
   CMXZDT.write_prl_exp_imp_param(IN_TYPE => IN_TYPE); 
END; 
/

The parameter files are generated in the

GGS/dirprm

directory.

Open a command prompt and navigate to the

GGS/dirprm

directory.

Export the data in the previous load table in the active environment:

expdp <active Operational Reference Store name>/<TNS password>@<TNS name> parfile=prl_expdp.prm

The

prl.dmp

file is generated in

GGS/dirprm

Copy the

PRL.dmp

and

prl_impdp.prm

files from the

GGS/dirprm

directory in the active environment to the

GGS/dirprm

directory in the passive environment.

If the active and passive environments are not swapping for the first time, truncate the previous load table in the passive environment. You must truncate the previous load table in the passive environment so that the data from the active previous load table can be imported.

In the passive environment, log in to SQL*Plus and run the following command:

TRUNCATE TABLE <Previous Load Table Name>;

In the passive environment, open a command prompt and navigate to

GGS/dirprm

Run the following command to import the data into the previous load table in the passive environment:

impdp <passive Operational Reference Store name>/<TNS password>@<TNS name> remap_schema=<active Operational Reference Store name>:<passive Operational Reference Store name> parfile=prl_impdp.prm

Rename Saved Search

Table of Contents

Zero Downtime Upgrade Guide for Oracle

Zero Downtime Upgrade Guide for Oracle

Transfer the Previous Load Table Data