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.
ON-Bar backup and restore system
Back up with ON-Bar
You can use the ON-Bar utility to back up and verify storage spaces (dbspaces, blobspaces, and sbspaces) and logical-log files.
onbar -v syntax: Verifying backups
Use the onbar -v command to verify that backups that were created by the ON-Bar utility are complete and can be restored.
Verification failures
Restoring when a backup is missing data
If a backup fails verification because of missing data, you can perform a restore from an older 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
    - Overview of the ON-Bar backup and restore system
      ON-Bar consists of various components and it works with a storage manager to back up and restore data.
    - Configure the storage manager and ON-Bar
      The topics in this section provide the information that you need to plan and to set up ON-Bar with a storage manager.
    - Back up with ON-Bar
      You can use the ON-Bar utility to back up and verify storage spaces (dbspaces, blobspaces, and sbspaces) and logical-log files.
      - Preparing to back up data
        Before you back up storage spaces and logical logs, you must prepare the system and copy critical administrative files.
      - onbar -b syntax: Backing up
        Use the onbar -b command to back up storage spaces and logical logs.
      - onbar -m syntax: Monitoring recent ON-Bar activity
        You can monitor recent ON-Bar activity with the onbar -m command. Only users who have permission to perform backup and restore operations can use this option.
      - Viewing a list of registered backups
        You can create a list of the registered ON-Bar backups performed on your system.
      - onbar -P syntax: Printing backed-up logical logs
        You can use the onbar -P command to print logical logs that are backed up using the ON-Bar utility.
      - onbar -v syntax: Verifying backups
        Use the onbar -v command to verify that backups that were created by the ON-Bar utility are complete and can be restored.
        Temporary space for backup verification
        When you verify backups, 15-25 MB of temporary space must be available.
        Verification failures
        Diagnosing why a backup failed verification
        If a backup failed verification, you can take steps to diagnose and attempt to fix the problem.
        Verifying an expired backup
        You can verify an expired backup in case subsequent backups are not valid.
        Restoring when a backup is missing data
        If a backup fails verification because of missing data, you can perform a restore from an older backup.
    - Restore data with ON-Bar
      You can use the ON-Bar utility to restore data that was backed up by the ON-Bar utility.
    - External backup and restore
    - Customize and maintain ON-Bar
    - ON-Bar catalog tables
      These topics describe the ON-Bar tables that are stored in the sysutils database.
    - ON-Bar messages and return codes
      ON-Bar prints informational, progress, warning, and error messages to the ON-Bar activity log file. ON-Bar return codes indicate the status of the command.
  - ontape backup and restore system
  - 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.

Restoring when a backup is missing data

If a backup fails verification because of missing data, you can perform a restore from an older backup.

About this task

To restore when a backup is missing data:

Procedure

Choose the date and time of an older backup than the one that failed. To perform a point-in-time verification, use the onbar -v -t time space command.
If the older backup passes verification, perform a point-in-time physical restore by using the same time value, then perform a log restore, as follows:
```
onbar -r -p -t time space
onbar -r -l
```
Expire the corrupted backup at your storage manager.
Run the onsmsync command without arguments.
The onsmsync utility removes backups that are no longer held by the storage manager from the emergency boot file and the sysutils database, preventing ON-Bar from attempting to use such backups.