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.
Syntax for archecker utility commandsThe 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.
Restore tables with large objects

Restore tables with large objects

ON-Bar supports table-level restores of smart large objects and binary large objects.

Smart large objects
Table-level restore also supports smart large objects for physical restore only (restore from level-0 archive).
The storage location of the smart large object columns being restored must be specified with the PUT clause in the CREATE TABLE statement. The restored smart large objects are created with the create-time flags LO_NOLOG and LO_NOKEEP_LASTACCESS_TIME. These flags override the LOG and KEEP ACCESS TIME column attributes if they are specified in the target table for the smart large object column.
Binary large objects
Table-level restore supports restoring tblspace binary large objects, but not blobspace binary large objects. If you attempt to restore a blobspace binary large object, the value is set to NULL and a warning is issued.