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 » Database maintenance » Backup and data recovery » Database recovery » Media failure recovery

 

Recovering from media failure on a transaction log mirror

Use the transaction log mirror to recovery from media failure.

Prerequisites

There are no prerequisites for this task.

Context and remarks

If your database is a consolidated database in a SQL Remote installation, you should use a transaction log mirror or a hardware equivalent.

 Task

  1. Make an extra copy of the backup of your database file taken at the time the transaction log was started.

  2. Identify which of the two files is corrupt. Run the Log Translation utility (dbtran) on the transaction log and on its mirror. The file that generates an error message is corrupt.

    The following command translates a transaction log named demo.log, placing the translated output into demo.sql: 

    dbtran demo.log

  3. Copy the correct file over the corrupt file.

  4. Restart the database server.

Results

The database is recovered.

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