Backing up Logical-Log Files Using ondatartr (ON-A (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Backing up Logical-Log Files Using ondatartr (ON-Archive)

Use

This procedure is part of an emergency logical-log backup on the Informix database with ON-Archive without the SAP scripts. For an overview, see Emergency Logical-Log Backup without SAP Scripts (ON-Archive).

You have to use ondatartr for this step because ON-Archive is not available until the end of the step, when the logical log has been backed up.

Prerequisites

You have completed the necessary preparations. Refer to "Prerequisites" in Emergency Logical-Log Backup Without SAP Scripts (ON-Archive).

The program ontdatartr used in this procedure writes to the volume set ONDATARTRLOG . Therefore, you must have this volume set available.

Procedure

Note

Make sure in the command given below that:

You specify the full volume path for ONDATARTRLOG (in this example, /infbackup/logpanic/V1 ). This is because access to the sysmaster database is suspended until the logs are backed up, which means that the catalog information specifying volume paths is not available.

The parameter max_space is large enough to accommodate the entire logical log, that is, the number of logical-log files currently in use on the system. max_space is given in blocks of 512 byte.

Enter a command like the following from the command line:

$ ondatartr 'backup/logfile/disk =(/infbackup/logpanic/V1)/max_space=99999999)'

As each log file is backed up, a message similar to the following appears:

Logfile LF00000023 being processed.

The backed up log files are not yet registered in the sysmaster database because the ondatartr command does not record any details in the sysmaster database. The log files are backed up to a single save set (that is, an emergency save set) in the directory /infbackup/logpanic/V1 and are called, for example, 00023370.SAV .

Result

The logical log is now backed up and the database resumes processing. Make sure you perform the remaining steps so that you can use the data backed up in this procedure in a restore.

The next step is to check the result of the emergency logical-log backup.

See also:

Informix documentation