lr_dump_marker

(Oracle only) 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.

Note: This command is available only for Oracle.

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.

  • The value of lr_dump_marker is reset to zero:
    • If you remove the Replication Agent transaction log base components using the pdb_xlog command.
    • If Replication Agent resumes after you run the resume command with no option.
      Note: If Replication Agent resumes after you run the resume command with no option, the dump database marker is not sent to the Replication Server.