Returns and modifies a list of Oracle RAC database instances (or nodes) that are filtered for commit log record generation.
This command is available only for Oracle and is only
applicable to Oracle RAC databases.
pdb_commit_generation_filter
{ [add, inst_name] | [remove, [inst_name | all] ] }
To add an Oracle instance name to the list of instances filtered for commit log record generation, follow the pdb_commit_generation_filter command with the add keyword and the inst_name parameter specifying the Oracle instance name:
pdb_commit_generation_filter add, inst_name
To remove an Oracle instance from the list of instances filtered for commit log record generation, follow the pdb_commit_generation_filter command with the remove keyword and the inst_name parameter specifying the Oracle instance name:
pdb_commit_generation_filter remove, inst_name
To remove all Oracle instances from the list of instances filtered for commit log record generation, follow the pdb_commit_generation_filter command with the remove keyword and all keyword:
pdb_commit_generation_filter remove, all
To list the Oracle instances that are currently being filtered for commit log record generation, enter the pdb_commit_generation_filter command alone:
pdb_commit_generation_filter
pdb_commit_generation_filter
This command lists Oracle RAC database instances that are currently being filtered for commit log record generation.
pdb_commit_generation_filter add, ora_inst1
This command adds the Oracle instance named ora_inst1 to the list of instances filtered for commit log record generation.
pdb_commit_generation_filter remove, ora_inst1
This command removes the Oracle instance named ora_inst1 from the list of instances filtered for commit log record generation.
pdb_commit_generation_filter remove, all
This command removes all Oracle instance names from the list of instances filtered for commit log record generation.
The instance name specified in the pdb_commit_generation_filter command represents the primary database instance being filtered for commit log record generation.
Filtering should only be used in an Oracle RAC environment to allow the user to control which nodes generate commit log records. For example, in a database with both active and inactive nodes, commit log record generation has no effect on an active node, but it is desirable for passive nodes to reduce replication latency.
