Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Logging and log administration
Manage logical-log files
Back up logical-log files
Back up sbspaces

Back up sbspaces

When you turn on logging for smart large objects, you must perform a level-0 backup of the sbspace.

The following figure shows what happens if you turn on logging in an sbspace that is not backed up. The unlogged changes to smart large object LO1 are lost during the failure, although the logged changes are recoverable. You cannot fully restore LO1.

During fast recovery, the database server rolls forward all committed transactions for LO1. If LO1 is unlogged, the database server would be unable to roll back uncommitted transactions. Then the LO1 contents would be incorrect. For more information, see Fast recovery.

The paragraphs that precede this figure describe the content of the figure. — Figure 1: Turn on logging in an sbspace

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.