Informix Error -43018: A point-in-time restore is permitted only during a full restore.
Cause and resolution
A point-in-time restore is permitted only during a full restore.
You cannot do a point-in-time restore unless all spaces are restored.
Do not specify any spaces on the command line.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-43018 fires when a point-in-time restore is attempted without restoring all spaces — per the official guidance.
- Specific spaces named on the command line for a point-in-time restore, per the official guidance — the direct, only cause; point-in-time requires a full restore.
Solutions / Resolution
- Don't specify any spaces on the command line, per the official guidance, so all spaces are restored.
Examples
N/A
No specific triggering statement is documented beyond naming specific spaces for a point-in-time restore.
Diagnostic Checks
- Check the restore command for named storage spaces, and remove them for a point-in-time restore.
Related Errors / Related Topics
- -43016 — "Invalid Point In Time value specified:
." A related point-in-time restore error, on an invalid value rather than a full-restore requirement. - -43017 — "A Point in Log restore is permitted only during a Full restore." A related restriction, requiring an offline (cold) restore rather than a full-space restore.
A point-in-time restore named specific spaces, but it requires restoring all spaces — omit the space names.