Choosing the Correct Kind of Restore
Use
This section shows you how to choose the correct kind of restore when a failure with your Informix database has occurred and data has been lost.
Prerequisites
You have correctly
identified the problem. Be sure to identify whether a critical dbspace is affected because this determines the kind of restore to use.Critical dbspaces are essential for the database server to function properly. Critical dbspaces in the database configured for the R/3 System are
rootdbs , physdbs , and logdbs . Non-critical dbspaces are all other dbspaces.Procedure
· Critical dbspace is down
· Both critical and non-critical dbspaces are down
· A logical error caused by an application program occurred after a known point in time
Otherwise, if the database server was not brought down by the fault, then presumably the problem is with a non-critical dbspace and you can perform a partial-system warm restore.

Generally, SAP does not recommend you to perform a partial-system warm restore, unless you are sure that the problem only affects a small number of non-critical dbspaces. In any case, the R/3 System is not properly functional if a dbspace fails, and it might be possible that other dbspaces are affected as well. Therefore, the safest and most effective procedure is to close down the database and do a cold restore.
·
·
Full-System Cold Restore (ON-Archive)·
Full-System Cold Restore (ontape)·
Partial-System Warm Restore (ON-Bar)·
Partial-System Warm Restore (ON-Archive)·
Partial-System Warm Restore (ontape)
The archives and backups written by
ON-Bar , ON-Archive and ontape are not compatible. You cannot mix tapes from these tools. Use the same tool for restores as you normally use for archives and backups (except if you need to use ondatartr for a cold restore when your normal tool is ON-Archive ).
See also:
Informix documentation