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 16 - Changes and Upgrading » How to upgrade to SQL Anywhere 16 » Upgrades and rebuilds in a database mirroring system

 

Updating the database server software to a different minor release for a mirroring system without rebuilding the database

Update the software of the database servers in a mirroring system by installing the software, stopping each server, and starting the database on the new server. All database servers in a database mirroring system must use the same minor release.

Prérequis

You must have the BACKUP DATABASE system privilege. You must be the owner of the database, or have the VALIDATE ANY OBJECT system privilege.

By default, you must have the SERVER OPERATOR system privilege to stop network database servers.

Test the following steps in non-production environment with your application before performing the steps in a production environment.

Contexte et remarques

The mirroring system stops temporarily during the update.

 Apply a SQL Anywhere major or maintenance version to a database mirroring system

  1. Make a backup of the primary database, copy the backup, and validate the copy of the backup.

    For example, run the following command to back up a database named mydb.db: 

    dbbackup -c "DBN=mydb;ENG=myserver;UID=DBA;PWD=sql" backup-dir

    Create a copy of the backup:

    xcopy backup-dir\*.db validatebackup-dir\backupmydb.db

    Validate the backup copy:

    dbvalid -c "DBF=validatebackup-dir\backupmydb.db;UID=DBA;PWD=sql"

    If the copy of the backup does not validate, then fix the problems that cause the validation to fail before proceeding. Otherwise, you risk losing data.

  2. Stop the servers in the following order:

    1. copy nodes

    2. mirror server

    3. primary server

    4. arbiter server

    For example, run the Stop utility (dbstop):

    dbstop -y -c "UID=DBA;PWD=sql;Server=myserver"

  3. Install the new software on the primary, mirror, and arbiter servers.

  4. Start the servers in the following order:

    1. arbiter server

    2. primary server

    3. mirror server

  5. If the mirroring system is involved in read-only scale-out, install the software on the copy nodes, and then restart the copy nodes

Résultat

The databases in the mirroring system run on the new version of the software.

Suivant

Examine the database mirroring system to confirm that the upgrade completed properly, and test the database mirroring system with your application.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0