Procedure:

• CHECK to make sure that the Extract has processed all the records in the data source (Online Redo/archive logs)

GGSCI> send extract , logend
(The above command should print YES)

• Verify the extract, pump and replicat has ZERO lag.

GGSCI> send extract , getlag
GGSCI> send extract , getlag
GGSCI> send replicat , getlag

(The above command should pring “At EOF, no more records to PROCESS.”)

• STOP all application and database activity.
• Make sure that the primary extract is reading the end of the redolog and that there is no LAG at all for the PROCESSES.
• Now proceed with stopping the processes:

Source:

• Stop the primary extract
• Stop the pump extract
• Stop the manager process
• Make sure all the processes are down.

Target:

• Stop replicat process
• Stop mgr
• Make sure that all the processes are down.
• Proceed with the maintenance
• After the maintenance, proceed with starting up the processes:

Source:

• Start the manager process
• Start the primary extract
• Start the pump extract

(Or simply all the extract processes as GGSCI> start extract *)

• Make sure all that the processes are up.

Target:

• Start the manager process
• Start the replicat process.
• Make sure that all the processes are up.

Procedure:

GGSCI> send extract , logend
(The above command should print YES)

GGSCI> send extract , getlag
GGSCI> send extract , getlag
GGSCI> send replicat , getlag

(The above command should pring “At EOF, no more records to process.”)

Source:

Target:

Source:

(Or simply all the extract processes as GGSCI> start extract *)

Target: