Home
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Backup and Restore Guide
The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
ontape backup and restore system
Back up with ontape
Back up logical-log files with ontape
You must only use ontape to back up logical-log files when you use ontape to make your backup tapes.
Start an automatic logical-log backup

Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
- System administration
  These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
- Backup and Restore Guide
  The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
  - Overview of backup and restore
    These topics provide an overview of backup and restore concepts. They also provide information about planning for backup and restore operations.
  - ON-Bar backup and restore system
  - ontape backup and restore system
    - Configure ontape
      You configure the ontape utility by setting configuration parameters for backups of storage spaces and logical logs.
    - Back up with ontape
      - Summary of ontape tasks
      - Change database logging status
        You can use the ontape utility to change the logging status of a database. Most changes in logging mode require a full level-0 backup.
      - Create a backup
      - Back up logical-log files with ontape
        You must only use ontape to back up logical-log files when you use ontape to make your backup tapes.
        Before you back up the logical-log files
        When to back up logical-log files
        Start an automatic logical-log backup
        Starting a continuous logical-log file backup
        When you do not want to monitor the logical-log files and start backups when the logical-log files become full, you can start a continuous backup.
        End a continuous logical-log backup
        Devices that logical-log backups must use
    - Restore with ontape
    - Perform an external backup and restore
      These topics discuss performing an external backup and recovering data by restoring it with the ontape utility.
  - Backup and restore a Remote Secondary Server(RSS)
  - Integrated Backup Encryption
    These topics provide information about Integrated Backup Encryption.
  - Informix® Primary Storage Manager
    The Informix® Primary Storage Manager manages storage for ON-Bar backup and restore operations, including parallel backups, that use file devices (disks).
  - archecker table level restore utility
  - Backup and restore configuration parameter reference
  - Cloud Backup
    These topics provide information about storing and retrieving the backups directly to the ecosystem of selected cloud providers, namely Amazon S3 and Softlayer Object Storage.
  - Appendixes
- Enterprise Replication
  The HCL® Informix® Enterprise Replication Guide describes the concepts of data replication using Informix Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.

Start an automatic logical-log backup

The database server can operate online when you back up logical-log files. To back up all full logical-log files, use the -a option of the ontape command.

Figure 1. Request a logical-log backup

The -a option backs up all full logical-log files and prompts you with an option to switch the logical-log files and back up the formerly current log.

When the tape mounted on LTAPEDEV becomes full before the end of the logical-log file, ontape prompts you to mount a new tape.

When you press the Interrupt key while a backup occurs, the database server finishes the backup and then returns control to you. Any other full logical-log files receive a used status.

To back up all full logical-log files, execute the ontape -a command.