Show detailed log gap report

Request

HTTP Method: POST
Content Type: application/json

Parameters

Property	Type	Description	Required
`configuration_id`	integer(int64)	configuration ID (non-negative)	required

{
    "params": {
        "configuration_id": 1
    }
}

Response

HTTP Status: 200

Content Type: application/json

Response

Property	Type	Description
`error`	object of type `error_response`	error response
`result`	object of type `log_gap_report_oracle_response`	log-gap-report/oracle response
`successful`	boolean	response with error or not

error_response

Property	Type	Description
`message`	string	error message

log_gap_report_oracle_response

Property	Type	Description
`data_loss_exposure_formatted`	string	data loss exposure, formatted for display
`data_loss_exposure_seconds`	integer	number of seconds of transactions that would be lost if the primary database were lost now, based on redo received on the standby (including Zero Data Loss streaming); null if not available
`log_chain_gaps`	array of `log_chain_gap`	archive log sequences missing from the standby's log chain
`threads`	array of `log_gap_report_thread`	list of log gap information, one for each thread
`warnings`	array of string	warning messages
`zero_data_loss`	object of type `zero_data_loss_status`

log_chain_gap

Property	Type	Description
`first_missing_sequence`	integer	first missing sequence number in this gap
`last_missing_sequence`	integer	last missing sequence number in this gap
`next_available_sequence`	integer	next sequence number available on the standby after the gap
`thread`	integer	redo thread number

log_gap_report_thread

Property	Type	Description
`archive_log_gap`	integer	archive log gap
`archived_source_sequence`	integer	archived source sequence number
`current_source_sequence`	integer	current source sequence number
`last_transferred_timestamp`	string(date-time)	last transferred timestamp
`recovery_sequence`	integer	next required destination recovery sequence number
`thread`	integer	thread number
`time_lag_formatted`	string	time lag formatted to string
`time_lag_in_seconds`	integer	time lag in seconds
`transfer_log_gap`	integer	transfer log gap

zero_data_loss_status

Property	Type	Description
`currently_replicating_member`	string	full path of the redo member currently being streamed to the standby; omitted unless replication_state is replicating
`error`	string	error that stopped redo log replication
`last_redo_timestamp_primary`	string	latest timestamp written to the online redo logs on the primary; omitted if the primary state is unknown (for example, primary unreachable)
`last_redo_timestamp_standby`	string	latest redo timestamp received in the online redo log mirror on the standby
`replicated_redo_members`	array of `redo_member`	the online redo log members on the primary that Zero Data Loss replicates, with the latest redo observed in each; empty in external replication mode and when no recent measurements are available
`replication_state`	string	current state of Dbvisit redo log replication: - "bootstrapping" while the initial copy of the online redo logs is transferring - “replicating" during continuous streaming - “errored" when replication has failed; omitted for external replication.
`transfer_bytes_per_second`	integer	current redo transfer rate in bytes per second (1-second moving average); omitted unless replication_state is replicating

redo_member

Property	Type	Description
`latest_redo_timestamp`	string	latest timestamp observed in this member
`measurement_time`	string	when this member was last measured
`member`	string	full path of the redo log member on the primary
`sequence`	integer	redo log sequence currently in this member

{
    "error": {
        "message": "string"
    },
    "result": {
        "data_loss_exposure_formatted": "string",
        "data_loss_exposure_seconds": 123,
        "log_chain_gaps": [
            {
              "first_missing_sequence": 123,
              "last_missing_sequence": 123,
              "next_available_sequence": 123,
              "thread": 123
            }
        ],
        "threads": [
            {
                "archive_log_gap": 123,
                "archived_source_sequence": 123,
                "current_source_sequence": 123,
                "last_transferred_timestamp": "2024-07-31T13:57:42.000123456Z",
                "recovery_sequence": 123,
                "thread": 123,
                "time_lag_formatted": "string",
                "time_lag_in_seconds": 123,
                "transfer_log_gap": 123
            }
        ],
        "warnings": [
            "string"
        ],
        "zero_data_loss": {
            "currently_replicating_member": "string",
            "error": "string",
            "last_redo_timestamp_primary": "string",
            "last_redo_timestamp_standby": "string",
            "replicated_redo_members": [
                {
                    "latest_redo_timestamp": "string",
                    "measurement_time": "string",
                    "member": "string",
                    "sequence": 123
                }
            ],
            "replication_state": "string",
            "transfer_bytes_per_second": 123
        }
    },
    "successful": true
}

HTTP Status: 400

Content Type: application/json

Response

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

error_response

Property	Type	Description
`message`	string	error message

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

We're here to help!

/log-gap-report/oracle

Request

Parameters

Response

HTTP Status: 200

Response

HTTP Status: 400

Response

Comments