ISM restore results in return code 147

Technote (troubleshooting)


Problem(Abstract)

A restore from backup is performed using Onbar and an Informix Storage Manager (ISM) Backup. The restore fails with Return Code 147. This return code indicates 'No backup list'.

A simplified example illustrates the origin of the problem. Given a sequence of savesets in a period from A to B, which we will display as 'A:1,2,3,4:B', and reference as 'Volume AB'. The retention period is set to this most recent volume. For some reason, saveset 4 is not available and the desired task is to restore to saveset 3. When the restore is attempted, the restore fails and the 147 return code is present.

Cause

ISM uses a media catalog that maps out the sequence of how a restore can proceed. A missing saveset in the volume makes the catalog inconsistent. The catalog needs to be repaired in order to restore any saveset from the volume.

Resolving the problem

  1. Recreate the catalog by piecing it back together from the existing backup saveset, using the command: ' ism_catalog -recreate from device'
  2. At this point you could restore from the recreated saveset, or select a Point In Time (PIT) and restore to a previous saveset in the volume, using a PIT restore.

Related information

Details for the ism_catalog command
How to get a Save Set ID for recovery
Missing index error in ISM
Resolve a failed restore

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

10.0, 11.1, 11.5, 11.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1621465

Modified date:

2012-12-31

Translate my page

Machine Translation

Content navigation