This is the first stage in a full-system cold restore of the Informix database if you use ON-Archive as your data recovery tool (that is, for your archives and backups). The logical-log files that were not already backed up when the failure occurred are backed up in this stage. This stage is not compulsory. However, if you leave it out, your database is less up-to-date at the end of the restore process.

• You are logged on as user informix or root .
• The database server is offline.

• The procedure is easier if you have two tape devices (in the example below, /dev/rmt/0m and /dev/rmt/1m are used).
• You have completed Preparing for a Full-System Cold Restore (ON-Archive).

1. Start ondatartr with level-0 archive volume.

Load the level-0 volume containing rootdbs on the first tape device and enter the following command, including the parameter salvagelogs :

$ ondatartr 'retrieve/dbspaceset=*/tape=(/dev/rmt/0m)/
salvagelogs=(/dev/rmt/1m)'

The parameters for this command are as follows:

Parameter	Explanation
dbspaceset	The save set containing the rootdbs dbspace. In this example, dbspaceset=* indicates that all dbspaces are archived to the same save set. For example, if you used the parallel archive illustrated in Preparing for Full-System Cold Restore (ON-Archive) you would enter dbspaceset=SET000072A , because this dbspace set indicates the save set containing the dbspace rootdbs .
tape	The device containing the archive volume.
salvagelogs	The device containing the volume on which you want to store the salvaged logical-log files. If you are retrieving from tape you must salvage the logs to tape. Similarly, although unlikely, if you are retrieving from disk, you must salvage the logs to disk. If you only have one tape device, mount the tape for the salvaged logical-log files first, and then mount the volume containing the archived data when prompted. It is easier if you have at least two tape devices available for the restore.

ondatartr starts a dialog similar to the following:

Executing...

Log Files 345 through 377 are eligible for salvaging.

What log file number should ONDATARTRLOG start with?: 345

2. Determine where to begin salvaging logical-log files.

In general, salvage all eligible logical-log files. In the example above the user chose to start salvaging with the first eligible logical-log file.

ondatartr displays the following prompt:

Please mount volume 1 of ONDATARTRLOG and press <Return> **Write**

3. Mount the tape volume for the salvaged logical-log files and confirm the prompt.

If you have used the SAP scripts – see script arcprep in SAP Scripts for ON-Archive – to set up your volume sets and volumes, use tape volume ONDAT1 from ONDATARTRLOG . You cannot change the tape drive once the recovery has started, so make sure you get the correct tape mounted first time.

4. Note the save set ID (1345 in this example) for the end of the logical restore.

A message like the following appears:

Save Set 1345 being written to vset ONDATARTRLOG.

Logfile 374 backed up

Logfile 375 backed up

Logfile 376 backed up

Logfile 377 backed up

5. Physically label your tape with all the information shown in the message and the current date.

Now that you have salvaged the logical-log files, you can go on to the next stage, Performing Physical Restore for Full-System Cold Restore (ON-Archive).