To clone your database from one instance to another successfully with Hermes enabled, you must ensure that certain Hermes tables are preserved and excluded. The list of tables in the preserve list should match those in the exclude list and vice versa.

Before you request a clone, verify the Hermes tables in the preserve and exclude lists. For example, make sure the sys_kafka_topic table is in the preserve list to maintain the current Hermes topics in the target instance. If the sys_kafka_topic table is not preserved, it is overwritten when the clone operation occurs.

The following sections assume that Hermes is installed on both the source and target instances before the clone. For example, if Hermes is not installed on the target instance, there are no Hermes tables to preserve.

Important: If you clone an instance without Hermes installed to an instance with Hermes installed, the Hermes tables in the target instance are removed.

To avoid losing this data, capture the data in the following Hermes tables using an update set:

  • hermes_cluster_config
  • hermes_topics_state
  • hermes_topic_location
  • hermes_topics_metrics
  • hermes_metrics

You must ensure the hermes_cluster_config and hermes_topic_location tables are preserved to ensure the Hermes Messaging Service is functional.

Hermes tables to preserve

Add the following Hermes tables to the Clone Data Preservers list if they're missing. Remove any Hermes tables that aren't in this list.

  • hermes_app_services
  • hermes_audit_operational_metadata
  • hermes_audit_records
  • hermes_client_metrics
  • hermes_cluster_config
  • hermes_metrics
  • hermes_metrics_collection
  • hermes_system_status
  • hermes_topic_audit_records
  • hermes_topic_location
  • hermes_topics_metrics
  • hermes_topics_state
  • hermes_usage_metrics
  • sys_kafka_namespace
  • sys_kafka_topic

Hermes tables to exclude

Add the following Hermes tables to the Clone Exclude Tables list if they're missing. Remove any Hermes tables that aren't in this list.

  • hermes_app_services
  • hermes_audit_operational_metadata
  • hermes_audit_records
  • hermes_client_metrics
  • hermes_cluster_config
  • hermes_metrics
  • hermes_metrics_collection
  • hermes_system_status
  • hermes_topic_audit_records
  • hermes_topic_location
  • hermes_topics_metrics
  • hermes_topics_state
  • hermes_usage_metrics
  • sys_kafka_namespace
  • sys_kafka_topic