When you are using database mirroring, extra steps are required to apply a SQL Anywhere maintenance release or EBF, or to upgrade the database file:
Installing SQL Anywhere maintenance releases in a database mirroring systemAll database servers in a database mirroring system must use the same maintenance release of SQL Anywhere. If you use the following procedure to apply a SQL Anywhere maintenance release, the only time the database is not available is during steps 3 and 4.
To apply a SQL Anywhere maintenance release to a database mirroring systemShut down the mirror server by issuing a dbstop command.
Install the new version of SQL Anywhere on the mirror server.
Shut down the primary and arbiter servers by issuing a dbstop command for each server.
Install the new version of SQL Anywhere on the primary server.
Restart the primary and mirror servers.
Install the new version of the software on the arbiter.
Restart the arbiter.
Applying SQL Anywhere EBFs in a database mirroring system See also Upgrading databases in a database mirroring systemThere are two procedures you can use to upgrade or rebuild a database that is participating in a database mirroring system. The first process is simpler, but it has a longer database downtime than the second procedure.
To upgrade or rebuild a database in a database mirroring systemShut down the mirror server.
Shut down the primary server.
Upgrade or rebuild the database using the copy on the primary server. See Upgrading version 10 and later databases, or Rebuilding version 10 and later databases.
Copy the upgraded or rebuilt database and transaction log to the mirror server.
Restart the primary server.
Restart the mirror server.
Any renamed transaction log files should be moved because they are incompatible with the new database. An initial transaction log file is required on both servers for mirroring to start. You can create a transaction log file by executing a dbping command against the database.
To minimize downtime while upgrading or rebuilding a database in a database mirroring systemMake a backup of the database and rename the transaction log.
Upgrade or rebuild the backup copy of the database on a different computer. See Upgrading version 10 and later databases or Rebuilding version 10 and later databases.
Shut down both the primary and mirror servers.
Save the current copy of the transaction log on the primary database.
Use the dbtran utility to translate the transaction log saved in step 4.
This transaction log contains any changes made to the database since the backup in step 1.
Start the rebuilt database using a local database server.
Apply the translated transaction log using the READ statement from Interactive SQL.
Stop the rebuilt database.
Copy the upgraded or rebuilt database and its transaction log to the primary and mirror servers.
Start the primary server.
Start the mirror server.
Applying SQL Anywhere EBFs in a read-only scale-out system Upgrading databases that use read-only scale-outThis procedure describes how to upgrade a database being used in a scale-out system, including when scale-out is being used with database mirroring.
To upgrade a database in a scale-out systemMake a backup of the database and rename the transaction log.
Upgrade or rebuild the backup copy of the database on a different computer. See Upgrading version 10 and later databases or Rebuilding version 10 and later databases.
Stop the database servers for all of the copy nodes in the system.
Shut down the root server. If you are using database mirroring in conjunction with scale-out, you must shut down both the primary and mirror servers.
Save the current copy of the transaction log on the primary database.
Use the dbtran utility to translate the transaction log saved in step 4.
This transaction log contains any changes made to the database since the backup in step 1.
Start the rebuilt database using a local database server.
Apply the translated transaction log using the READ statement from Interactive SQL.
Stop the rebuilt database.
Copy the upgraded or rebuilt database and its transaction log to the root database server.
Copy the upgraded database and an empty transaction log files to each copy server.
Start the root database server. If you are using database mirroring with scale-out, you must start both the primary and the mirror servers.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |