Enhanced pdb_skip_op Command

Syntax

You can specify this parameter combination to add, return, or remove XStream operations from a list of operations to skip:

pdb_skip_op [
{
add , { locator | {commitscn, scn, sequence, thread} }
|
remove, { all | locator | {commitscn, scn, sequence, thread } }
}
]

You can also use the new parameter combination in the ra_helpop command.

For other database parameter combinations, see the Replication Agent Reference Manual.

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.
• locator – the locator keyword from the list of Log Transfer Manager (LTM) locators to identify the operations to skip.
• commitscn – (for Oracle) the system change number (SCN) keyword identifies a log record to skip.
• scn – (for Oracle) the SCN keyword identifies a specified log record to skip.
• sequence – (for Oracle) the sequence keyword identifies a specified log record to skip.
• thread – (for Oracle) the thread keyword of the redo log thread of the operation to skip.

Examples

• Example 1 – adds an operation into skip list:

  pdb_skip_op add, 0x0000.00425c72.0000, 0x0000.00425c72.0000, 1, 1 
  go

• Example 2 – checks the current skip list:

  pdb_skip_op
  go
  Skip List
  -----------------------------------------------------------------------------------------
  SCN:0x0000.00425c72.0000, Thread:0x0001, Sequence:0x0000, CommitSCN:0x0000.00425c72.0000
  (1 row affected)
  

• Example 3 – removes the skip operation from skip list:

  pdb_skip_op remove,0x0000.00425c72.0000, 0x0000.00425c72.0000, 1, 1 
  go

• Example 4 – checks the current skip list:

  pdb_skip_op go 
  (0 rows affected)

Usage