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
Restore with ontape
Configuring continuous log restore with ontape

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
    - Restore with ontape
      - Types of physical restore
      - Cold, warm, or mixed restores
      - ontape utility syntax: Perform a restore
        Use the -r option to perform a full physical and logical restore of the database server data with ontape. Use the -D option to restore selected storage spaces. Use the -rename option to rename chunks during the restore.
      - Restore the whole system
        This section outlines the prerequisites and steps you need to complete to restore your entire database server with ontape.
      - Configuring continuous log restore with ontape
      - Rename chunks during a restore
      - Restore from standard input
        You can perform a restore from standard input, you must first have performed a backup to standard output.
      - Restore data to a remote server
        You can restore data to a remote server with the ontape utility.
      - Simultaneous backup and restore by using standard I/O
    - 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.

Configuring continuous log restore with ontape

Before you begin

Ensure that the version of HCL Informix® is identical on both the primary and secondary systems.

About this task

Use continuous log restore to restart a log restore with newly available logs after all currently available logs have been restored. For more information, see Continuous log restore.

To configure continuous log restore with ontape:

Procedure

On the primary system, perform a level-0 archive with the ontape -s -L 0 command.
On the secondary system, copy the files or mount the tape (as assigned by LTAPEDEV) and perform a physical restore with the ontape -p command.
Respond to the following prompts:
```
Continue restore? Y
Do you want to back up the logs? N
Restore a level 1 archive? N
```
After the physical restore completes, the database instance waits in fast recovery mode to restore logical logs.
On the primary system, back up logical logs with the ontape -a command.
On the secondary system, copy the files or mount the tape that contains the backed up logical logs from the primary system. Perform a logical log restore with the ontape -l -C command.
Repeat steps 4 and 5 for all logical logs that are available to back up and restore.
If you are doing continuous log restore on a secondary system as an emergency standby, run the following commands to complete restoring logical logs and quiesce the server
- If logical logs are available to restore, use the ontape -l command.
- After all available logical logs are restored, use the ontape -l -X command.