Update the software of the database servers in a mirroring system by installing the software, stopping each database server, and starting the databases on servers running the new software. The database itself is not upgraded or rebuilt.
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.
Context and remarks
Test the following steps in non-production environment with your application before performing the steps in a production environment.
All database servers in a database mirroring system must use the same minor release of SQL Anywhere. So, the mirroring system stops temporarily during the update.
Make a backup of the primary database, copy the backup, and validate the copy of the backup.
For example, the following command backs up a database named mydb.db:
dbbackup -c "DBN=mydb;ENG=myserver;UID=DBA;PWD=sql" backup-dir
To create a copy of the backup and apply the transaction logs to the copy of the backup, run the following commands:
xcopy backup-dir\mydb.db validatebackup-dir xcopy backup-dir\mydb.log validatebackup-dir
Validate this 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.
Install the new software on the primary, mirror, and arbiter servers.
If the mirroring system is involved in read-only scale-out, install the software on the copy nodes.
Stop the servers in the following order:
For example, run the Stop utility (dbstop):
dbstop -y -c "UID=DBA;PWD=sql;Server=myserver"
(Optional) Upgrade or rebuild the databases.
Start the databases on the new servers in the following order:
arbiter server, primary server, and mirror server
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|