Informix Error -12145: Smart Large Objects: sbspace is not fully recovered.

Cause and resolution

Smart Large Objects: sbspace is not fully recovered.

An attempt was made to archive an sbspace that is not recovered or consistent. An sbspace must be online and consistent before a backup is attempted. Wait until the recovery is complete before backup. If the sbspace is online, check the sbspace using oncheck -cS and oncheck -ce. If it is inconsistent, you need to restore it from a backup first.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12145 fires when an archive/backup is attempted on an sbspace that isn't recovered or consistent — per the official guidance.

The sbspace not yet online and consistent, per the official guidance — the direct, only cause; a backup requires both.

Solutions / Resolution

Wait until recovery is complete before attempting the backup, per the official guidance.
If the sbspace is online, check it with oncheck -cS and oncheck -ce, per the official guidance.
If inconsistent, restore the sbspace from a backup first, per the official guidance.

Examples

Checking sbspace consistency

$ oncheck -cS sbspace_name
$ oncheck -ce sbspace_name

Diagnostic Checks

Check the sbspace's recovery status, then run oncheck -cS/oncheck -ce once online, restoring from backup if inconsistent.

Related Errors / Related Topics

-12141 — "Smart Large Objects: sbspace is not fully recovered." The same condition, encountered accessing an object directly rather than during an archive/backup attempt.

An archive/backup was attempted on an sbspace that isn't recovered/consistent — wait for recovery, then check with oncheck.