Backup detail on online

1. Using the Ontape command

Online Dynamic Server 7.1 provides a database administrator with an online incremental backup tool that enables database administrators to use Ontape for data backup and logical log backups. also provides a onarchive with interactive interface and menu-driven database Backup tool. OnLine Dynamic Server 7.1 provides an incremental backup of the data, which is divided into three levels, 0 levels (level 0), 1 levels (Level 1), and 2 levels (Level 2).

Level 0: Back up the entire database system

Level 1: Back up data that has changed since the level 0 backup

Level 2: Back up data that has changed since the Level 1 backup

For example, yesterday and today all do level 2 backup, then today's backup must contain the data backed up yesterday. At the same time, the database administrator retains a maximum of three data backup disks, that is, a level 0 backup band, a 1-level backup band, and a 2-level backup belt. A complete system backup should also include a logical log backup band.

Database backup content and purpose:

A Data backup: Back up the data state at some point in the database and use it to restore the system when it is out of the system.

b Logical log Backup: After the logical log file is full, it must be backed up before it can be emptied, continue to use, and cause the system to crash if all the logical log files are full. In addition, the logical log records changes to the database after the last data backup, so the logical log is also used to recover the system when there is an unexpected system.

1.1 Data backup

Online Dynamic Server 7.1 's command-line data backup method using the Ontape command, the parameter option for the data backup is-s,$ ontape-s–l number

At this point the database server will prompt you to do what level of data backup, you only need to enter number:0, 1 or 2 on the keyboard, you can return.

1.2 Logical log file backups

A Scheduled backup logical Log

Periodically make logical log file backups, the system backs up the fully-written logical log files to tape, and then empty and release the files. Do scheduled backups must be done before all the logical log files are full, so if you are using a scheduled backup, observe the usage of the logical log. Sparked, if you often have long things happen, you should avoid the use of scheduled backups, using continuous backup is more secure.

Command format: ontape-a

B Continuous Backup logical Log

A continuous backup is filled with a logical log file, one is backed up, and then the log file is freed, so to do a continuous backup, you must ensure that there is a tape in the tape drive. A continuous backup takes up one screen or terminal display information. When the tape is full, the system prompts for the replacement of the tape.

Command format: ontape–c

Note: Informix recommends using continuous backup, but continuous backup will always occupy the tape drive, if the system has two tape drives, can be used as physical log backup and logical log backup, if the system has only one tape drive, and data backup conflict, the need to replace the tape in a timely manner.