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 utility to back up and restore database server data. This will 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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.