pdb_skip_op

Description

This command is available only for Oracle and Microsoft SQL Server.

Returns, adds, or removes record identifiers from a list of records to skip in processing. The format of the identifier is database-specific.

Syntax

pdb_skip_op [add | remove], [identifier] [remove, all]

Parameters

add: Adds a specified ID to the list of identifiers of records to skip.

remove: Removes a specified ID from the list of identifiers to skip.

identifier: Identifies the log record to skip. The syntax is database specific

all: Allows you to add or remove all IDs in the list of identifiers to skip.

Examples

Example 1

pdb_skip_op

This command with no parameters returns a list of the identifiers for the records you want to skip.

Example 2

pdb_skip_op add, id

This command adds an ID to the list of identifiers you want to skip.

Example 3

pdb_skip_op remove, id

To remove an ID to the list of identifiers you want to skip:

Example 4

pdb_skip_op remove, all

This command removes all the IDs on the list of identifiers you want to skip.

Usage

The pdb_skip_op command allows you to skip problem records, thereby avoid having to reinitialize the Replication Agent.
Skipped records are written to the system log as a warning message.
The pdb_skip_op command is valid when the Replication Agent is in Admin state.
The format of the identifier is database specific:
- For Microsoft SQL Server, the identifier is Log Sequence Number (LSN) and it has the following form:
```
virtualfileseqno:pageid:operationsseqno
```
  where:
  - virtualfileseqno is the virtual log sequence number.
  - pageid is the page number.
  - operationsseqno is the sequence number of the operation.
  You can get the LSN using the Microsoft SQL Server DBCC command, or you can parse it from the locator. For example:
  - LSN in decimal format
```
‘489:112:27’
```
  - LSN in hexadecimal format
```
‘0x00000489:00000112:0027’
```
- For Oracle, the identifier contains, SCN (System Change Number), redo log Thread, and Record Byte Address (RBA) and it has the following form:
```
scn, thread, lsn.blknum.blkoffset
```
  where:
  - scn is the System Change Number.
  - thread is the thread being used.
  - lsn is the log sequence number.
  - blknum is the block number.
  - blkoffset is the offset into the block where this record resides.
  The values must be specified in the pdb_skip_op command together, enclosed in quotes, each item separated by a period.
  
  For example:
```
‘0000.012345678’, ’1’, ’0012.0000444.0000123’
```
  All values can be described as a hexadecimal by prefixing the identifier with an ‘0x’ as follows:
```
‘0x000c.00001bc.000007b’
```
  or
```
‘0x000.00BC614E’
```