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.
Overview of the archecker utilityThe 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.
Table-level restore and locales

Table-level restore and locales

For table-level restore, if the table being restored (table on the archive) has a locale code set different from the default locale (en_US.8859-1) the DB_LOCALE environment variable must be set to have the same code set as the locale of the archived table being restored.

No code set conversion is performed during a table-level restore; the locale code set of the database or table being restored must match the locale code set of the database or table that the data is being restored to. In addition, the same DB_LOCALE information is used for all of the tables being restored by using the same table-level restore command schema file.

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.