Listing Recovery Report with SAPDBA (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Listing Recovery Report with SAPDBA

Use

You can use SAPDBA to list a recovery report to help you restore your database. However, you must have prepared correctly for the report before the restore is necessary, that is, during normal database operation.

You can use this procedure to list the report whichever version of Informix you are using. For more information, see:

Recovery Report with SAPDBA (applies to Informix versions later than 6.0)

Creation of Recovery Report with SAPDBA (Informix 6.0).

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

You are using the Informix tool ON-Archive for data recovery. The recovery reports are not available if you are using ontape or ON-Bar .

You have prepared correctly for the report:

If you have an Informix version later than 6.0, refer to Preparing for Recovery Reports with SAPDBA. SAPDBA automatically creates the report after every archive and logical-log backup.

If you have Informix version 6.0, refer to Preparing for Recovery Reports with SAPDBA (Informix 6.0). With version 6.0, you also need to create the report after every archive logical-log backup. Refer to Creating the Recovery Report with SAPDBA (Informix 6.0).

Procedure

Choose Recovery Report in SAPDBA for Informix.

Choose one of the numbers from the list of available recovery reports.

You see a report similar to the following:

Recovery requirements as of 1995-05-30 14:22:52 for * + = required for minimal restore
Vol	Vset	Save Set	Label	Device	Date	Level
-------	---------	--------	-------	----------	-------------------	-------
0001	DBTAP1	00000001	DBT1_1	DBTP1_VOP	1995-05-26 12:12:37	0
+rootdbs, psapsource, psappool, psapuser1, psapprot, psapclu, psaplod
0001	DBTAP2	00000002	DBT2_1	DBTP2_VOP	1995-05-26 12:12:39	0
+logdbs, +physdbs, psapdocu, psapstab, psapbtab, psapddic
0001	DBTAP1	00000005	DBT1_1	DBTP1_VOP	1995-05-26 15:04:49	1
+rootdbs, psapsource, psappool, psapuser1, psapprot, psapclu, psaplod
0001	DBTAP2	00000010	DBT2_1	DBTP2_VOP	1995-05-26 15:05:45	1
+logdbs, +physdbs, psapdocu, psapstab, psapbtab, psapddic
0001	LOGTAP	00000003	LOGT1	LOGTP1_VOP	1995-05-26 14:13:18	Backup
LF00001180
0001	LOGTAP	00000009	LOGT1	LOGTP1_VOP	1995-05-26 15:26:58	Backup
LF00001181

- The report title Recovery requirements as of 1995-05-30 14:22:52 for * means that, if you correctly restore the data listed in this report, your database will be consistent with the state it was in at this date and time.

- The entry + = required for minimal restore means that, for a minimal restore, you only need the dbspaces listed with +. However, the R/3 System is so integrated that you must have all dbspaces online and in a consistent state in order to run the system reliably.

- The Vol field refers to the volume number for the tape volume containing the data.

- The Vsets field refers to the volume set in which the tape volume logically resides.

- The Save set field refers to the logical group of data created from an ON-Archive logical-log backup or archive request.

- The Label field refers to the logical label of the tape volume.

- The Device field refers to the logical name used by ON-Archive for the tape (or disk) drive which writes the archive or logical-log backup data.

- The Date field refers to the actual date and time of the archive or logical-log backup.

- The Level field refers either to the level of the archive (possible values are 0, 1 or 2). In the case of a logical-log backup, the word backup appears here. In the case where a save set has been copied, the word copy appears here.

- The second line of each entry contains one of the following pieces of information:

- For archives (for example +rootdbs, psapsource, psappool), these lines refer to the dbspaces contained in the restore. For a minimal restore, you only need the dbspaces listed with +. However, SAP does not recommend you to do a minimal restore because the remaining dbspaces are also essential for correct functioning of the R/3 System.

- For logical-log backups (for example LF00001180), these lines refer to the logical-log files contained in the backup.

- The information is presented in the order in which you need to restore the data when recovering your database. You start at the top and work down. You always see at the top of the report the most current level-0 (full) archive existing at the time the report was produced. This is because you must always start a restore with this data.

- As you do more and more incremental archives (level 1 or 2), and more and more logical-log backups, the report gets longer and longer. Only when you next do a level-0 archive, does the report shrink again to include just the level-0 archive data.

Example

The first entry on the report shows that a level-0 (full) archive was taken on the 26th May at 12:12:37. The archive was written to the first volume of volume set DBTAP1 , labeled DBT1_1 , using tape device DBTP1_VOP . The save set created was 00000001 and included dbspaces rootdbs , psapsource , psappool , psapuser1 , psapprot , psapclu , and psaplod . It was the first half of a parallel archive. The second entry is the other half, writing the remaining dbspaces as save set 00000002 to volume labeled DBT2_1 of volume set DBTAP2 , using device DBTP2_VOP .

For more information about printing the report, see Printing a SAPDBA Report.

Result

You can now use the information on the report to restore your database. See Restore and Preparing for Restore with the SAPDBA Recovery Report.

You must perform regular housekeeping to clear up the directory containing the reports (that is, $INFORMIXDIR/sapreorg/recover.rpt ). Refer to SAPDBA Housekeeping.