BR
Valid For
Extract (Oracle only)
Description
Use the BR
parameter to control the Bounded Recovery (BR) feature. This feature currently supports Oracle databases.
Default
BR BRINTERVAL 4, BRDIR BR
Syntax
BR
[, BRDIR directory]
[, BRINTERVAL number {M | H}]
[, BRKEEPSTALEFILES]
[, BROFF]
[, BROFFONFAILURE]
[, BRFSOPTION { MS_SYNC | MS_ASYNC }]
-
BRDIR
directory
-
Specifies the relative or full path name of the parent directory that will contain the
BR
directory. TheBR
directory contains the Bounded Recovery checkpoint files, and the name of this directory cannot be changed. The default parent directory for theBR
directory is a directory namedBR
in the root directory that contains the Oracle GoldenGate installation files.Each Extract group within a given Oracle GoldenGate installation will have its own sub-directory under the directory that is specified with
BRDIR
. Each of those directories is named for the associated Extract group.For
directory
, do not use any name that contains the stringtemp
ortmp
(case-independent). Temporary directories are subject to removal during internal or external cleanup procedures. -
BRINTERVAL
number
{M | H}
-
Specifies the time between Bounded Recovery checkpoints. This is known as the Bounded Recovery interval. This interval is an integral multiple of the standard Extract checkpoint interval, as controlled by the
CHECKPOINTSECS
parameter. However, it need not be set exactly. Bounded Recovery will adjust any legalBRINTERVAL
parameter internally as it requires.The minimum interval is 20 minutes. The maximum is 96 hours. The default interval is 4 hours.Note:
BRINTERVAL
should only be changed after consulting with Oracle Support. -
BRKEEPSTALEFILES
-
Causes old Bounded Recovery checkpoint files to be retained. By default, only current checkpoint files are retained. Extract cannot recover from old Bounded Recovery checkpoint files. Retain old files only at the request of an Oracle support analyst.
-
BROFF
-
Turns off Bounded Recovery for the run and for recovery. Consult Oracle before using this option. In most circumstances, when there is a problem with Bounded Recovery, it turns itself off.
-
BROFFONFAILURE
-
Disables Bounded Recovery after an error. By default, if Extract encounters an error during Bounded Recovery processing, it reverts to normal recovery, but then enables Bounded Recovery again after recovery completes.
BROFFONFAILURE
turns Bounded Recovery off for the runtime processing. -
BRRESET
-
BRRESET
is a start up option that forces Extract to use normal recovery for the current run, and then turn Bounded Recovery back on after the recovery is complete. Its purpose is for the rare cases when Bounded Recovery does not revert to normal recovery if it encounters an error. Bounded Recovery is enabled during runtime. Consult Oracle Support before using this option.To use this option, you must start Extract from the command line. To run Extract from the command line, use the following syntax:
extract paramfile name.prm reportfile name.rpt
Where:
-
paramfile
name
.prm
is the relative or fully qualified name of the Extract parameter file. The command name can be abbreviated topf
. -
reportfile
name
.rpt
is the relative or fully qualified name of the Extract report file, if you want it in a place other than the default. The command name can be abbreviated torf
.
-
-
BR BRFSOPTION {MS_SYNC | MS_ASYNC}
-
Performs synchronous/asynchronous writes of the mapped data in Bounded Recovery. Consult Oracle Support before using this option.
Example
BR BRDIR /user/checkpt/br
specifies that the Bounded Recovery checkpoint files will be created in the /user/checkpt/br
directory.