Archive Log File Format Examples

Use the following examples to understand your options when specifying an Archive Log File format on the Edit Archive Mode Parameters dialog box.

Example 1

arch%s.arc

The above entry will generate archived logs as follows for log sequence numbers 100, 101, and 102:

/disk1/archive/arch100.arc,
/disk1/archive/arch101.arc,
/disk1/archive/arch102.arc
/disk2/archive/arch100.arc,
/disk2/archive/arch101.arc, /disk2/archive/arch102.arc, /disk3/archive/arch100.arc, /disk3/archive/arch101.arc, /disk3/archive/arch102.arc

Example 2

arch_%t_%s.arc

This entrty results in the following files for log sequence numbers 300-302 on thread 1:

/disk1/arc/arch_1_300.arc,
/disk1/arc/arch_1_301.arc,
/disk1/arc/arch_1_302.arc,
/disk2/arc/arch_1_300.arc,
/disk2/arc/arch_1_301.arc,
/disk2/arc/arch_1_302.arc

Example 3

arch_%t_%s_%r.arc

This setting will generate archived logs as follows for thread 1; log sequence numbers 100, 101, and 102; database incarnation 2:

/disk1/archive/arch_1_100_2.arc, /disk1/archive/arch_1_101_2.arc, /disk1/archive/arch_1_102_2.arc