检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Distributed SQL Server From Microsoft SQL Server to GaussDB Centralized From Microsoft SQL Server to GaussDB Distributed Using DAS to export and import data SQL/CSV files You can use DAS to export data from the source database first and then import the data from your local PC or OBS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ALL,on(LOCK),off(COMMAND,DFS,GUC,GSCLEAN,HDFS,ORC,SLRU,MEM_CTL,AUTOVAC,CACHE,ADIO,SSL,GDS,TBLSPC,WLM,OBS
Value range: Boolean on indicates that the query covering the OBS is accelerated based on the cost when the computing resource pool is available. off indicates that no query is accelerated using the computing resource pool.
Default value: 1 time_to_target_rpo Parameter description: Specifies the maximum time_to_target_rpo seconds from the time when an exception occurs on the primary cluster to the time when data is archived to the OBS recovery point in dual-cluster remote DR mode.
Backups are saved as packages in OBS buckets to ensure data confidentiality and durability. Since backing up data affects the database read and write performance, you are advised to perform automated backups for tables during off-peak hours.
Default value: 1 time_to_target_rpo Parameter description: Specifies the maximum time_to_target_rpo seconds from the time when an exception occurs on the primary cluster to the time when data is archived to the OBS recovery point in dual-cluster remote DR mode.
Value range: Boolean on indicates that the query covering the OBS is accelerated based on the cost when the computing resource pool is available. off indicates that no query is accelerated using the computing resource pool.
Default value: 1 time_to_target_rpo Parameter description: In the remote DR mode of dual database instances, set the allowed time_to_target_rpo seconds from the time when an exception occurs on the primary database instance to the time when data is archived to the OBS recovery point
Default value: 1 time_to_target_rpo Parameter description: In the remote DR mode of dual database instances, set the allowed time_to_target_rpo seconds from the time when an exception occurs on the primary database instance to the time when data is archived to the OBS recovery point
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ALL,on(),off(COMMAND,DFS,GUC,GSCLEAN,HDFS,ORC,SLRU,MEM_CTL,AUTOVAC,CACHE,ADIO,SSL,GDS,TBLSPC,WLM,OBS
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ALL,on(),off(COMMAND,DFS,GUC,GSCLEAN,HDFS,ORC,SLRU,MEM_CTL,AUTOVAC,CACHE,ADIO,SSL,GDS,TBLSPC,WLM,OBS
OBSList Traverses an OBS directory. OBSRead Reads an OBS object. OBSWrite Writes an OBS object. LOGCTRL_SLEEP Waiting for the standby node to catch up with logs. ShareStorageWalRead Reads log files from the shared disk. ShareStorageWalWrite Writes log files to the shared disk.
OBSList Traverses an OBS directory. OBSRead Reads an OBS object. OBSWrite Writes an OBS object. LOGCTRL_SLEEP Waits for the standby node to catch up with logs. ShareStorageWalRead Reads log files from the shared disk. ShareStorageWalWrite Writes log files to the shared disk.
OBS LWLock event OBSGetPathLock Prevents concurrent read/write or concurrent write/write on an OBS path. OBS LWLock event OBSRuntimeLock Obtains environment variables, for example, GAUSSHOME.
OBSList Traverses an OBS directory. OBSRead Reads an OBS object. OBSWrite Writes an OBS object. LOGCTRL_SLEEP Waits for the standby node to catch up with logs. ShareStorageWalRead Reads log files from the shared disk. ShareStorageWalWrite Writes log files to the shared disk.
OBSList Traverses an OBS directory. OBSRead Reads an OBS object. OBSWrite Writes an OBS object. LOGCTRL_SLEEP Waits for the standby node to catch up with logs. ShareStorageWalRead Reads log files from the shared disk. ShareStorageWalWrite Writes log files to the shared disk.
OBS LWLock event OBSGetPathLock Used to prevent concurrent read/write or concurrent write/write on an OBS path. OBS LWLock event OBSRuntimeLock Used to obtain environment variables, for example, GASSHOME.
OBS LWLock event OBSGetPathLock Prevents concurrent read/write or concurrent write/write on an OBS path. OBS LWLock event OBSRuntimeLock Obtains environment variables, for example, GAUSSHOME.
It takes some time to back up and upload incremental log files (The time depends on the network and OBS traffic control). Note that the backup completion time does not represent the data consistency point that can be specified when this backup set is used to restore data.
There may be residual OBS files. EIP binding failure GaussDBV5BindEIPFailed Major The EIP has been used or EIP resources are insufficient. Submit a service ticket by choosing Service Tickets > Create Service Ticket in the upper right corner of the management console.