Cloning with Hermes Messaging Service enabled

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • 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_ip_filtering_audit
    • hermes_metrics
    • hermes_metrics_collection
    • hermes_operation_metadata
    • hermes_shared_topic_acl
    • hermes_shared_topic_connection
    • 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_ip_filtering_audit
    • hermes_metrics
    • hermes_metrics_collection
    • hermes_operation_metadata
    • hermes_shared_topic_acl
    • hermes_shared_topic_connection
    • 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