DISCARDROLLOVER

Valid For

Extract and Replicat

Description

Use the DISCARDROLLOVER parameter to set a schedule for aging discard files. For long or continuous runs, setting an aging schedule prevents the discard file from filling up and causing the process to abend, and it provides a predictable set of archives that can be included in your archiving routine.

When the DISCARDROLLOVER age point is reached, a new discard file is created, and old files are renamed in the format of GROUPn.extension, where:

• GROUP is the name of the Extract or Replicat group.

• n is a number that gets incremented by one each time a new file is created, for example: myext0.dsc, myext1.dsc, myext2.dsc, and so forth.

• extension is the file extension, such as .dsc.

You can specify a time of day, a day of the week, or both. Specifying just a time of day (AT option) without a day of the week (ON option) generates a discard file at the specified time every day.

Discard files always roll over at the start of a process run, regardless of whether DISCARDROLLOVER is used or not.

If the NODISCARDFILE parameter is used with the DISCARDROLLOVER parameter, the process abends.

For more information about the discard file, see Administering Oracle GoldenGate.

Default

Disabled. By default, discard files are rolled over when a process starts.

Syntax

DISCARDROLLOVER
{AT hh:mi |
ON day |
AT hh:mm ON day}

AT hh:mi

The time of day to age the file.

Valid values:

• hh is an hour of the day from 00 through 23.

• mm is minutes from 00 through 59.

ON day

The day of the week to age the file.

Valid values:

SUNDAY
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY

They are not case-sensitive.

Examples

Example 1   

DISCARDROLLOVER AT 05:30

Example 2   

DISCARDROLLOVER ON friday

Example 3   

DISCARDROLLOVER AT 05:30 ON friday