Sybase Database Recovery

Loading a backup to an existing database using load database can be either a database for creating a dump or not. The syntax is:

Load database database name from dump device name/physical file name

Load transaction database name from dump device name/physical file name

Use Backup Recovery database for example:

A database data and logs are stored on two separate disks, and the backup plan for the normal operation is as follows: 17:00 daily backups of the entire database, 10:00, 12:00, 14:00, 16:00 per day, incremental backups are performed.

Monday 17:00 Tapes 1 (100M) Tuesday 10:00 Tapes 2 (30M) Tuesday 12:00 Tapes 3 (30M) Tuesday 14:00 Tapes 4 (30M) Tuesday 16:00 Tapes 5 (30M) Tuesday 17:00 tape 6 (30M)

Dumpdatabasedumptransactiondumptransactiondumptransactiondumptransactiondumpdatabase

If the data disk is damaged at six o'clock in the afternoon in Tuesday, you can recover the database using the following steps:

(1) Use the DUMP TRANSACTION with No_truncate to obtain the current transaction log dump, tape 7;

(2) Use load database to reproduce the latest data dumps, tape 6; (offline)

(3) Use load Transaction to submit the latest transaction log dumps, tape 7;

(4) Use online database to set the status of the databases to online.

If the data disk is damaged at 4:50 in Tuesday, the recovery process is as follows:

(1) Use the DUMP TRANSACTION with No_truncate to obtain the current transaction log dump, tape 7;

(2) Use load database to reproduce the latest data dumps, tape 6; (offline)

(3) Using load transaction to load the transaction log on 2, 3, 4 and 5 sequentially;

(4) Use load transaction to submit the latest transaction log dumps, tape 7;

(5) Use online database to set the status of the databases to online.