Returns the current value of the database generation ID or updates the value of the database generation ID.
pdb_gen_id [number]
This is the value of the new database generation ID to be used when the database generation ID is updated.
pdb_gen_id
This command returns the current value of the database generation ID, as shown below:
Generation ID ------------- 0 (1 row affected)
pdb_gen_id 10
This command updates the value of the database generation ID.
When pdb_gen_id is invoked with no option, it returns the current value of the database generation ID stored in the Replication Agent transaction log system table.
When pdb_gen_id is invoked with the number option, it updates the value of the database generation ID in the Replication Agent transaction log system table. Changing the database generation ID takes effect immediately.
The database generation ID is the first two bytes of the origin queue ID. The database generation ID is used by Replication Server to support recovery operations, which may require Replication Agent to re-send transactions.
During recovery, if Replication Agent must re-send operations that the primary Replication Server has already processed, the database generation ID can be changed to prevent the primary Replication Server from recognizing the information as already processed.
For more information about the origin queue ID, see the appendix for your specific primary database server at the end of this book.
If the Replication Agent transaction log does not exist, the pdb_gen_id command returns an error message.
The pdb_gen_id command is valid when the Replication Agent instance is in either Admin or Replicating state.
ra_locator, pdb_truncate_xlog
