Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » Database mirroring » Tutorial: Creating a database mirroring system

 

Lesson 5: (Optional) Restarting the mirroring system

Start the mirroring system by starting the partner and arbiter servers.

Prerequisites

All database servers in the mirroring system must be stopped.

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Creating a database mirroring system.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Creating a database mirroring system with multiple databases that share an arbiter server.

 Task

  1. Run the following command to restart the first partner:

    dbsrv16 -n mirror_server1 -x "tcpip(PORT=6871;DOBROAD=no)" -su sql "c:\server1\mirror_demo.db" -xp on

  2. Run the following command to restart the second partner:

    dbsrv16 -n mirror_server2 -x "tcpip(PORT=6872;DOBROAD=no)" -su sql "c:\server1\mirror_demo.db" -xp on

  3. Run the following command to restart the arbiter:

    dbsrv16 -n demo_arbiter -su sql -x "tcpip(PORT=6870;DOBROAD=no)" -xf "c:\arbiter\arbiter.state" -xa "AUTH=abc;DBN=mirror_demo"

Results

The mirroring system is restarted.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0