Start/Stop Replication

Starting the MINE process

The Dbvisit Replicate setup wizard creates the necessary scripts for starting the replication MINE process, so the actual dbvrep commands listed here are not required and are for information purposes only. The script names to start the MINE process are listed in the Nextsteps.txt file created by the setup wizard. The script names will have the word run and will contain the server name on which to run the actual script.

Example:
d112f-run-dbvisit210.sh

Where:

  • d112f is the DDC file name 
  • dbvisit210 is the server name

On Windows:

Start the Command Console with the DDC file.

On Windows, the Dbvisit Replicate can be started as a local service.

dbvrep> start_service mine

 

This starts the Windows service. The service can also be started from the Windows service control panel.

If the service is not yet created, the service can be created with:

dbvrep> create service mine

 

On Linux/Unix

Start the Dbvisit Replicate executable with a DDC file and start the MINE as a daemon process:

dbvrep --ddcfile w112a.ddc --daemon start mine

 

The –daemon option makes dbvrep disconnect from the console and run in the background. No further commands can be entered. 
To see the progress of the replication, start a new Dbvisit Replicate Command Console and load the same DDC file. See Viewing the status of the replication for more information.

Starting the APPLY process

The Dbvisit Replicate setup wizard creates the necessary scripts for starting the replication APPLY process, so the actual dbvrep command listed here are not required and are information purposes only. The script names to start the APPLY process are listed in the Nextsteps.txt file created by the setup wizard.

On Windows:

Start the Command Console with the DDC file.

On Windows, the Dbvisit Replicate can be started as a local service.

dbvrep> start_service APPLY

 

This starts the Windows service. The service can also be started from the Windows service control panel.

If the service is not yet created, the service can be created with:

dbvrep> create service apply

 

On Linux/Unix:

Start the Dbvisit Replicate executable with a DDC file and start the APPLY as a daemon process:

dbvrep --ddcfile w112a.ddc --daemon start apply

 

The –daemon option makes dbvrep disconnect from the console and run in the background. No further commands can be entered.
To see the progress of the replication, start a new Dbvisit Replicate Command Console and load the same DDC file. See Viewing the status of the replication for more information.

 

When restarting the MINE process after the MINE process has been stopped for some time, there maybe some additional work required by the MINE process internally before the replication is up to date again. Please see Restarting MINE Process for more information.

Starting the fetcher process

The Dbvisit Replicate setup wizard creates the necessary scripts for starting the replication fetcher process, so the actual dbvrep command listed here are not required and are information purposes only. The script names to start the APPLY process are listed in the Nextsteps.txt file created by the setup wizard.

On Windows:

Start the Command Console with the DDC file.

On Windows, the Dbvisit Replicate can be started as a local service.

dbvrep> start_service fetcher

 

This starts the Windows service. The service can also be started from the Windows service control panel.

If the service is not yet created, the service can be created with:

dbvrep> create service fetcher

 

On Linux/Unix:

Start the Dbvisit Replicate executable with a DDC file and start the fetcher as a daemon process:

dbvrep --ddcfile w112a.ddc --daemon start fetcher

 

The –daemon option makes dbvrep disconnect from the console and run in the background. No further commands can be entered.
To see the progress of the replication, start a new Dbvisit Replicate Command Console and load the same DDC file. See Viewing the status of the replication for more information.

Stopping the replication process

To stop or shutdown the replication process:

dbvrep> shutdown all                                                                                                      
Upon restart MINE will go back to redolog 5901 (thread 1), going back 4 logs.
Upon restart APPLY will go back to plog 5901, going back 4 plogs.
Are you sure you want to shutdown? (Yes/No) [No] yes                                                                      
Dbvisit Replicate MINE process shutting down.

 

This will stop all the replication processes including MINE, APPLY and fetcher (if started).

On Linux/Unix, the dbvrep process associated with the MINE, APPLY or fetcher can also stopped with a kill -9 command. 

On Windows, the APPLY, MINE or fetcher process can be also stopped by shutdown the associated Windows service.

It is always a good idea to ensure that there are no connections active for the user 'dbvrep' in either database before restarting MINE and APPLY. If any sessions after shutting down all do exist, kill the oracle session before restarting.