Oninit
Talk to an expert →

Informix Error -43140: Due to the previous error, logical restore will not be attempted.

Cause and resolution

Due to the previous error, logical restore will not be attempted.

An error occurred in the physical restore. ON-Bar does not attempt a logical restore to give the user a chance to fix the problem. If the physical restore was cold, the database server is left in fast recovery mode.

You have the following two choices:

1) Fix the problem and finish the restore with onbar -r or onbar -r <failed_space>. ON-Bar re-attempts to restore the failed storage space. </failed_space>

2) Finish the restore with onbar -r -l. ON-Bar performs a logical restore but leaves off-line any storage spaces that are not yet physically restored.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-43140 fires when a physical restore fails — per the official guidance, ON-Bar skips the logical restore to give the user a chance to fix the problem; if the physical restore was cold, the server is left in fast recovery mode.

  1. A prior error during the physical restore, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Fix the problem and finish the restore with onbar -r or onbar -r <failed_space>, per the official guidance — ON-Bar re-attempts the failed storage space.
  2. Or finish the restore with onbar -r -l, per the official guidance — ON-Bar performs a logical restore but leaves any not-yet-physically-restored storage spaces offline.
Examples
Resuming after a failed physical restore
$ onbar -r -l   # logical restore only, leaving unrestored spaces offline

$ onbar -r space1   # re-attempt physical restore of just space1
Diagnostic Checks
  1. Identify and fix the physical-restore error reported previously, then choose onbar -r <failed_space> to retry it, or onbar -r -l to proceed with logical restore and leave the space offline.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -43140 in this set yet.

A physical-restore error blocked the logical restore — fix the problem and retry the failed space, or proceed logical-only with onbar -r -l.