lr_dump_marker

Returns or sets the system change number (SCN), indicating the last committed transaction in the primary database dump. This value is sent to Replication Server when Replication Agent encounters a log record with an SCN greater than or equal to this value.

Syntax

lr_dump_marker [scn]

Parameters

Usage

  • lr_dump_marker invoked with no option returns the SCN marking the point at which the primary database was last dumped. If no SCN has yet been specified, lr_dump_marker returns 0.

  • To set an SCN dump point, invoke lr_dump_marker with a valid SCN marking the point at which the primary database was last dumped. If you made the dump with the Oracle Recovery Manager (RMAN) utility, you can obtain this SCN by using the RMAN list backup command.

  • The SCN set with the lr_dump_marker command takes effect when Replication Agent is in the Replicating (Resynchronization) state.