## 11.5 M\_SYSTEM\_REPLICATION\_TAKEOVER\_HISTORY System View
Provides access to a history of HSR takeover executions.
## Structure
| Column name                    | Data type   | Description                                                                                                                                      |
|--------------------------------|-------------|--------------------------------------------------------------------------------------------------------------------------------------------------|
| TAKEOVER_START_TIME            | TIMESTAMP   | Specifies the start time of the takeover command. This value matches tenant takeovers that are executed within the same system takeover process. |
| TAKEOVER_END_TIME              | TIMESTAMP   | Specifies the end time of the takeover command.                                                                                                  |
| EXECUTION_START_TIME           | TIMESTAMP   | Specifies the execution start time for takeover of the transaction domain.                                                                       |
| EXECUTION_END_TIME             | TIMESTAMP   | Specifies the execution end time for takeover of the transaction domain.                                                                         |
| SITE_ID                        | INTEGER     | Specifies the generated ID of the secon­ dary site at takeover time.                                                                              |
| SITE _NAME                     | VARCHAR(64) | Specifies the logical name provided by the site administrator at takeover time.                                                                  |
| MASTER_NAMESERVER_HOST         | VARCHAR(64) | Specifies the master nameserver host at takeover time.                                                                                           |
| VERSION                        | VARCHAR(32) | Specifies the SAP HANAversion for the site that is executing the takeover.                                                                       |
| SOURCE_SITE_ID                 | INTEGER     | Specifies the generated ID of the source site at takeover time.                                                                                  |
| SOURCE_SITE _NAME              | VARCHAR(64) | Specifies the logical name for the source site provided by the site admin­ istrator at takeover time.                                             |
| SOURCE_MASTER_NAME­ SERVER_HOST | VARCHAR(64) | Specifies the source site master name­ server host at takeover time.                                                                              |
| Column name               | Data type      | Description                                                                                                                            |
|---------------------------|----------------|----------------------------------------------------------------------------------------------------------------------------------------|
| SOURCE_VERSION            | VARCHAR(32)    | Specifies the source siteSAPHANA version.                                                                                              |
| TAKEOVER_TYPE             | VARCHAR(10)    | Specifies how the system went online: ● ONLINE: an online takeover ● OFFLINE: an offline takeover ● TIMETRAVEL: a timetravel take­ over |
| REPLICATION_MODE          | VARCHAR(16)    | Specifies the replication mode at take­ over time.                                                                                      |
| OPERATION_MODE            | VARCHAR(32)    | Specifies the operation mode at take­ over time.                                                                                        |
| REPLICATION_STATUS        | VARCHAR(16)    | Specifies the replication status at take­ over time.                                                                                    |
| LOG_POSITION              | BIGINT         | Specifies the master log position, that has been reached by takeover.                                                                  |
| LOG_POSITION_TIME         | TIMESTAMP      | Specifies the time reached by the take­ over.                                                                                           |
| SHIPPED_LOG_POSITION      | BIGINT         | Specifies the highest master log posi­ tion that has been shipped before exe­ cuting takeover.                                           |
| SHIPPED_LOG_POSITION_TIME | TIMESTAMP      | Specifies the time of the last shipped log buffer before executing takeover.                                                           |
| COMMENTS                  | NVARCHAR(5000) | Specifies a comment for the remote subscription.                                                                                       |