Monitoring Logical-Log Backups

To find out if a logical-log file is ready to be backed up, check the flags field of onstat -l. After the logical-log file is marked as backed up, it can be reused. When the flags field displays any of the following values, the logical-log file is ready to be backed up:

U------
U-----L

The value U means that the logical-log file is used. The value L means that the last checkpoint occurred when the indicated logical-log file was current. The value C indicates the current log. If B appears in the third column, the logical-log file is already backed up and can be reused.

U-B---L

The following example shows the output of onstat -l when you use it to monitor logical logs on the database server:

Logical Logging
Buffer bufused  bufsize  numrecs  numpages numwrits recs/pages pages/io
  L-2  0        16       1        1        1        1.0        1.0     
   Subsystem    numrecs  Log Space used
   OLDRSAM      1        32
address  number   flags    uniqid   begin        size     used    %used
a038e78  1        U-B----  1        10035f        500      500   100.00
a038e94  2        U-B----  2        100553        500      500   100.00
a038eb0  3        U---C-L  3        100747        500      366    73.20
a038ecc  4        F------  0        10093b        500        0     0.00
a038ee8  5        F------  0        100b2f        500        0     0.00
a038f04  6        F------  0        100d23        500        0     0.00

For information about the onstat -l fields, see onstat -l.