Create a new Oracle Configuration

Request

HTTP Method: POST
Content Type: application/json

Parameters

Property	Type	Required

Property	Type	Required
`general`	object of type `general`	required
`source`	object of type `source`	required
`source_oda_kvm`	object of type `source_oda_kvm`
`source_rac`	object of type `source_rac`
`source_seha`	object of type `source_seha`
`standby`	object of type `standby`
`standby_oda_kvm`	object of type `standby_oda_kvm`
`standby_rac`	object of type `standby_rac`
`standby_seha`	object of type `standby_seha`

general

Property	Type	Description

Property	Type	Description
`configuration_name`	string	new configuration name
`import`	string	name of existing configuration (DDC) to import
`license`	string	license key

source

Property	Type	Description	Required

Property	Type	Description	Required
`source_db`	string	name of source database (for detected source database)
`source_host`	string	host name of source database	required
`source_log_dir`	string	archivelog staging location on source host
`source_oracle_home`	string	Oracle home directory on source host (for manual source database)
`source_sid`	string	Oracle SID for source database (for manual source database)

source_oda_kvm

Property	Type	Description

Property	Type	Description
`source_asm_host`	string	host name for source ASM instance
`source_asm_password`	string(password)	password for source ASM instance
`source_asm_port`	integer	port for source ASM instance (non-negative)
`source_asm_service`	string	service name for source ASM instance
`source_asm_user`	string	user name for source ASM instance

source_rac

Property	Type	Description

Property	Type	Description
`source_rac1`	object of type `rac_thread`	the first RAC thread
`source_rac2`	object of type `rac_thread`	the second RAC thread
`source_rac3`	object of type `rac_thread`	the third RAC thread
`source_rac4`	object of type `rac_thread`	the fourth RAC thread
`source_rac5`	object of type `rac_thread`	the fifth RAC thread

source_seha

Property	Type	Description

Property	Type	Description
`source_seha1`	object of type `seha_node`	the first SEHA node
`source_seha2`	object of type `seha_node`	the second SEHA node

standby

Property	Type	Description

Property	Type	Description
`standby_asm`	boolean	enable automatic storage management (ASM) for the standby database
`standby_asm_instance`	string	automatic storage management (ASM) instance for the standby database
`standby_db`	string	unique database name of standby database
`standby_dbvisit_dir`	string	directory containing StandbyMP installation on standby host
`standby_host`	string	host name for standby database
`standby_log_dir`	string	archivelog staging location on standby host
`standby_oracle_home`	string	Oracle home directory on standby host
`standby_sid`	string	Oracle SID for standby database

standby_oda_kvm

Property	Type	Description

Property	Type	Description
`standby_asm_host`	string	host name for standby ASM instance
`standby_asm_password`	string(password)	password for standby ASM instance
`standby_asm_port`	integer	port for standby ASM instance (non-negative)
`standby_asm_service`	string	service name for standby ASM instance
`standby_asm_user`	string	user name for standby ASM instance

standby_rac

Property	Type	Description

Property	Type	Description
`standby_rac`	boolean	enable RAC for the standby database
`standby_rac1`	object of type `rac_thread`	the first RAC thread
`standby_rac2`	object of type `rac_thread`	the second RAC thread
`standby_rac3`	object of type `rac_thread`	the third RAC thread
`standby_rac4`	object of type `rac_thread`	the fourth RAC thread
`standby_rac5`	object of type `rac_thread`	the fifth RAC thread

standby_seha

Property	Type	Description

Property	Type	Description
`standby_seha`	boolean	enable SEHA for the standby database
`standby_seha1`	object of type `seha_node`	the first SEHA node
`standby_seha2`	object of type `seha_node`	the second SEHA node

rac_thread

Property	Type	Description

Property	Type	Description
`asm`	boolean	enable ASM
`asm_instance`	string	ASM instance
`host`	string	host name
`sid`	string	Oracle SID

seha_node

Property	Type	Description

Property	Type	Description
`asm`	boolean	enable ASM
`asm_instance`	string	ASM instance
`host`	string	host name

{
    "params": {
        "general": {
            "configuration_name": "string",
            "import": "string",
            "license": "string"
        },
        "source": {
            "source_db": "string",
            "source_host": "string",
            "source_log_dir": "string",
            "source_oracle_home": "string",
            "source_sid": "string"
        },
        "source_oda_kvm": {
            "source_asm_host": "string",
            "source_asm_password": "string",
            "source_asm_port": 123,
            "source_asm_service": "string",
            "source_asm_user": "string"
        },
        "source_rac": {
            "source_rac1": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "source_rac2": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "source_rac3": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "source_rac4": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "source_rac5": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            }
        },
        "source_seha": {
            "source_seha1": {
                "asm": false,
                "asm_instance": "string",
                "host": "string"
            },
            "source_seha2": {
                "asm": false,
                "asm_instance": "string",
                "host": "string"
            }
        },
        "standby": {
            "standby_asm": false,
            "standby_asm_instance": "string",
            "standby_db": "string",
            "standby_dbvisit_dir": "string",
            "standby_host": "string",
            "standby_log_dir": "string",
            "standby_oracle_home": "string",
            "standby_sid": "string"
        },
        "standby_oda_kvm": {
            "standby_asm_host": "string",
            "standby_asm_password": "string",
            "standby_asm_port": 123,
            "standby_asm_service": "string",
            "standby_asm_user": "string"
        },
        "standby_rac": {
            "standby_rac": false,
            "standby_rac1": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "standby_rac2": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "standby_rac3": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "standby_rac4": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            },
            "standby_rac5": {
                "asm": false,
                "asm_instance": "string",
                "host": "string",
                "sid": "string"
            }
        },
        "standby_seha": {
            "standby_seha": false,
            "standby_seha1": {
                "asm": false,
                "asm_instance": "string",
                "host": "string"
            },
            "standby_seha2": {
                "asm": false,
                "asm_instance": "string",
                "host": "string"
            }
        }
    }
}

Response

HTTP Status: 200

Content Type: application/json

Response

Property	Type	Description

Property	Type	Description
`error`	object of type `error_response`	error response
`result`	object of type `configuration`	DR Configuration
`successful`	boolean	response with error or not

configuration

Property	Type	Description

Property	Type	Description
`configuration_id`	integer(int64)	configuration ID (non-negative)
`configuration_name`	string	configuration name
`configuration_type`	string	configuration type (possible values: 'oracle', 'pgsql' and 'mssql')
`observer`	object of type `observer_config`	observer configuration
`auto_update`	object of type `auto_update_config`	automated standby update configuration
`primary`	object of type `database_info`	information about the primary database or cluster
`replication_mode`	string	replication mode for PostgreSQL configurations, or empty for other configuration types (possible values: 'not available', 'ARCHIVING', 'LOGSHIPPING' and 'STREAMING')
`standby`	object of type `database_info`	information about the standby database or cluster
`time_gap_formatted`	string	time gap between primary and standby, formatted for display
`time_gap_seconds`	integer	number of seconds standby is behind primary, or null if not available
`update_delay`	object of type `update_delay_config`	standby update delay configuration

error_response

Property	Type	Description

Property	Type	Description
`message`	string	error message

auto_update_config

Property	Type	Description

Property	Type	Description
`enabled`	boolean	whether automated standby updated is enabled
`interval_seconds`	integer	the configured automated standby update interval in seconds

database_info

Property	Type	Description

Property	Type	Description
`host`	string	host name of the database, instance or cluster
`port`	integer	cluster port for PostgreSQL configurations, instance port for SQL Server configurations, or omitted for Oracle configurations
`state`	string	database or cluster state, if requested, otherwise empty

observer_config

Property	Type	Description

Property	Type	Description
`check_interval_seconds`	integer	the configured observer check interval in seconds
`custom_script_primary`	string	full path of the custom script to use on the primary host
`custom_script_rule`	string	whether and how to use custom scripts to affect the Observer's behavior' (possible values: 'disabled', 'custom-only', 'either' and 'both')
`custom_script_standby`	string	full path of the custom script to use on the standby host
`emergency_action`	string	action to take once the maximum number of failures has been reached (possible values: 'activate' and 'notify')
`enabled`	boolean	whether the observer is enabled
`heartbeat_enabled`	boolean	whether to send a daily notification to confirm the observer is running; you need to have send_email or send_slack enabled for this to work
`heartbeat_hour`	integer	the hour of the day in the Control Center timezone at which to send the heartbeat notification (0-23)
`heartbeat_minute`	integer	the minute of the hour at which to send the heartbeat notification (0-59)
`max_fail_count`	integer	once this number of failures has been reached, the emergency action is taken and the observer is disabled
`send_email`	boolean	whether to send notifications to the email addresses configured for notifications on the configuration
`send_slack`	boolean	whether to send notifications to the Slack webhooks configured for notifications on the configuration
`time_gap_check_enabled`	boolean	whether to send a notification if the time gap exceeds the configured threshold
`time_gap_check_threshold_seconds`	integer	maximum number of seconds for the time gap check

update_delay_config

Property	Type	Description

Property	Type	Description
`delay_minutes`	integer	number of minutes to keep standby behind primary; 0 to disable

{
    "error": {
        "message": "string"
    },
    "result": {
        "auto_update": {
            "enabled": false,
            "interval_seconds": 123
        },
        "configuration_id": 1,
        "configuration_name": "string",
        "configuration_type": "oracle",
        "observer": {
            "check_interval_seconds": 123,
            "custom_script_primary": "string",
            "custom_script_rule": "disabled",
            "custom_script_standby": "string",
            "emergency_action": "activate",
            "enabled": false,
            "heartbeat_enabled": false,
            "heartbeat_hour": 123,
            "heartbeat_minute": 123,
            "max_fail_count": 123,
            "send_email": false,
            "send_slack": false,
            "time_gap_check_enabled": false,
            "time_gap_check_threshold_seconds": 123
        },
        "primary": {
            "host": "string",
            "port": 123,
            "state": "string"
        },
        "replication_mode": "not available",
        "standby": {
            "host": "string",
            "port": 123,
            "state": "string"
        },
        "time_gap_formatted": "string",
        "time_gap_seconds": 123,
        "update_delay": {
            "delay_minutes": 123
        }
    },
    "successful": true
}

HTTP Status: 400

Content Type: application/json

Response

Property	Type	Description

Property	Type	Description
`error`	object of type `error_response`	error response
`successful`	boolean	always false

error_response

Property	Type	Description

Property	Type	Description
`message`	string	error message

{
    "error": {
        "message": "string"
    },
    "successful": false
}

Dbvisit Standby Version 12 User Guide

/new/oracle

Request

Parameters

Response

HTTP Status: 200

Response

HTTP Status: 400

Response