Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Backup and Restore GuideThe HCL OneDB™ Backup and Restore Guide describes how to use the HCL® OneDB® 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 utilityYou 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.
The archecker schema referenceThe 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.
The RESTORE statementThe RESTORE statement is an optional command to restore tables to a specific point in time.

The RESTORE statement

The RESTORE statement is an optional command to restore tables to a specific point in time.

Syntax


Element	Description
"time"	The date and time the table is to be restored to.

Usage

The TO clause is used to restore the table to a specific point in time, which is specified by a date and time or the reserved word CURRENT.

Only one RESTORE statement can be specified in a command file. If this statement is not present in the command file, then the system will be restored to the most current time using logical logs.

If the WITH NO LOG clause is present, only a physical restore is performed. In addition, the two extra columns and the index are not added to the destination table. Physical-only restores are based on level-0 archives only.

Tip: Use this option when you do not have logical logs. You will not receive any messages about logical recovery.

Example

RESTORE TO CURRENT WITH NO LOG;