Start of Content Area

Procedure documentation Choosing the Correct Kind of Restore  Locate the document in its SAP Library structure

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

  1. Choose the correct kind of restore, depending on what the problem is. You need to perform a full-system cold restore if the problem is due to any of the following:
  2. · 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.

    Note

    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.

  3. Choose the appropriate restore, depending on what kind of restore you need and what your normal data recovery tool is:

· Full-System Cold Restore (ON-Bar)

· 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)

Caution

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