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.
archecker table level restore utility
archecker table level restore utility
You can use the archecker utility to perform point-in-time table-level restores that extract tables or portion of tables from archives and logical logs.
Data restore with archecker
Use the archecker utility to perform to types of restore operations.

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
  - 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
    - archecker table level restore utility
      You can use the archecker utility to perform point-in-time table-level restores that extract tables or portion of tables from archives and logical logs.
      - Overview of the archecker utility
        The archecker utility is useful where portions of a database, a table, a portion of a table, or a set of tables need to be recovered. It is also useful in situations where tables need to be moved across server versions or platforms.
      - Data restore with archecker
        Use the archecker utility to perform to types of restore operations.
        Physical restore
        When the archecker utility performs a physical restore, the utility extracts data from a level-0 archive.
        Logical restore
        After a physical restore, logical recovery can further restore tables to a user-specified point in time. To do this, the archecker utility reads backed-up logical logs, converts them to SQL statements, and then replays these statements to restore data.
      - Syntax for archecker utility commands
        The archecker utility provides a command-line interface for restoring data from an archive. To use archecker, you must specify both a configuration file and a schema command file.
      - The archecker schema reference
        The topics in this section describe the SQL-like statements used by the archecker schema command file. This file provides information that the archecker utility uses to perform data recovery.
  - 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.

Data restore with archecker

Use the archecker utility to perform to types of restore operations.

The two types of restores that the archecker utility performs are:

A physical restore that is based on a level-0 archive.
A physical restore followed by a logical restore, which uses both a level-0 archive and logical logs to restore data to a specific point in time.

When reading the command file, archecker determines whether to perform a physical restore only or a physical restore followed by a logical restore. By default, archecker performs a physical and logical restore. If you use the WITH NO LOG clause, archecker does not perform a logical restore.

The procedures and resources that archecker uses differ between a physical-only restore and a physical and logical restore. These procedures are outlined in the following sections.