First, download the official OceanBase Developer Center tools, as follows:
I used toThe OceanBase version is Community Edition 3.1.0When exporting using the OBC tool, the export can be successful, but the data amount is incomplete, as shown in the figure below:
The exported data is incomplete because it does not report an error, it is not found at the beginning, and the amount of data does not exceed 2G, and the data is found to be incomplete afterwards, which can be found in the alarm log, as shown in the figure below:
2022-01-19 11:14:14 [WARN] Query SELECT DBMS_METADATA. GET_DDL(OBJECT_TYPE, OBJECT_NAME) FROM USER_OBJECTS WHERE OBJECT_TYPE='INDEX' to get index definitions if observer is oboracle v2250+
2022-01-19 11:14:15 [WARN] Query SELECT DBMS_METADATA. GET_DDL(OBJECT_TYPE, OBJECT_NAME) FROM USER_OBJECTS WHERE OBJECT_TYPE='INDEX' to get index definitions if observer is oboracle v2250+
2022-01-19 11:14:15 [WARN] Query SELECT DBMS_METADATA. GET_DDL(OBJECT_TYPE, OBJECT_NAME) FROM USER_OBJECTS WHERE OBJECT_TYPE='INDEX' to get index definitions if observer is oboracle v2250+
2022-01-19 11:14:22 [WARN] Stop dump: itsvse.aaa Size: 13592097 >= 13591669
2022-01-19 11:14:23 [WARN] Stop dump: itsvse.bb Size: 13591846 >= 13591669
2022-01-19 11:14:25 [WARN] Stop dump: itsvse.cc Size: 13591702 >= 13591669
2022-01-19 11:14:26 [WARN] Stop dump: itsvse.dd Size: 13591671 >= 13591669
2022-01-19 11:14:27 [WARN] Stop dump: itsvse.ee Size: 13591943 >= 13591669
2022-01-19 11:14:30 [WARN] Stop dump: itsvse.ff Size: 13592037 >= 13591669
[ERROR] create connection SQLException, url: jdbc:mysql://127.0.0.1:2883/oceanbase? useUnicode=true&characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&useSSL=false, errorCode 1193, state HY000 java.sql.SQLTransientConnectionException: Could not connect to address=(host=127.0.0.1)(port=2883)(type=master) : Unknown system variable 'session_track_schema'
Starting from version V3.0.0 of the Derivatives Tool, the Derivatives tool supports the OceanBase Community Edition.
The community derivative tool (OBLOADER & OBDUMPER) needs to be paired with the community versionOceanBase V3.1.2 and aboveUse.
solution, upgrade the OceanBase version.
|
Posted on 1/19/2022 1:17:38 PM
|
|
|
|
