Checking Logical-Log Backup Result with Activity Log (ON-Archive)
Checking Logical-Log Backup Result with Activity Log (ON-Archive)
Use
You can check the results of a logical-log backup on the Informix database with
ON-Archive by looking in the ON-Archive activity log. The ON-Archive activity log is normally called archive.log and is stored in the directory /informix/<SID>/etc . For more information, see the ACTIVITYLOG parameter in Editing the config.arc File for ON-Archive.Procedure
The following is an example of an automatic logical-log backup using
onautovop :Feb 02 1995 19:29:48 #00000000# <29164> onarchive (informix) Created request #00000001#: BACKUP/LOGFILE/AUTOMATIC/CURRENT/VSET=LOGTAP/AUTOVOP
Feb 02 1995 19:30:13 #00000001# <29196> onautovop (informix) Begin automatic backup to LOGTAP
19:43:43 #00000001# <29196> Processing LF00001324 to LOGTAP:0001
19:43:44 #00000001# <29196> Processing LF00001325 to LOGTAP:0001
19:43:44 #00000001# <29196> Processing LF00001326 to LOGTAP:0001
19:43:45 #00000001# <29196> Processing LF00001327 to LOGTAP:0001
19:43:45 #00000001# <29196> Processing LF00001328 to LOGTAP:0001
19:43:46 #00000001# <29196> Processing LF00001329 to LOGTAP:0001
19:43:46 #00000001# <29196> Processing LF00001330 to LOGTAP:0001
Feb 02 1995 19:44:44 #00000001# <29196> onautovop (informix) End automatic backup: SUCCESS
See also:
Checking Logical-Log Backup Status (ON-Archive) Checking Logical-Log Backup Result with Message LogInformix documentation at
http://www.informix.com