obclient [ns_xxx_yxxx]> use oceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
obclient [oceanbase]> show tables;
±------------------------------------------+
| Tables_in_oceanbase |
±------------------------------------------+
| ALL_OB_EXTERNAL_TABLE_FILES |
| DBA_DB_LINKS |
| DBA_IND_PARTITIONS |
| DBA_IND_STATISTICS |
| DBA_IND_SUBPARTITIONS |
| DBA_OBJECTS |
| DBA_OB_ACCESS_POINT |
| DBA_OB_ARCHIVELOG |
| DBA_OB_ARCHIVELOG_PIECE_FILES |
| DBA_OB_ARCHIVELOG_SUMMARY |
| DBA_OB_ARCHIVE_DEST |
| DBA_OB_AUTO_INCREMENT |
| DBA_OB_BACKUP_DELETE_JOBS |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY |
| DBA_OB_BACKUP_DELETE_POLICY |
| DBA_OB_BACKUP_DELETE_TASKS |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY |
| DBA_OB_BACKUP_JOBS |
| DBA_OB_BACKUP_JOB_HISTORY |
| DBA_OB_BACKUP_PARAMETER |
| DBA_OB_BACKUP_SET_FILES |
| DBA_OB_BACKUP_STORAGE_INFO |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY |
| DBA_OB_BACKUP_TASKS |
。。。。。。
数据库oceanbase中有好多tables,为何我使用obdumper导出数据时,提示说没有可导出的表,具体报错如下
[root@master bin]# ./obdumper -h xxx.xxx.xxx.xxx -P 2883 -u root -p ‘xxx’ -c obcluster -t tenant1 -D oceanbase --ddl --sql --all -f /tmp/test
2024-07-09 15:46:13 [INFO] Parsed args:
[–ddl] true
[–sql] true
[–file-path] /tmp/test
[–host] xxx.xxx.xxx.xxx
[–port] 2883
[–user] root
[–tenant] tenant1
[–cluster] obcluster
[–password] **
[–database] oceanbase
[–sys-user] root
[–all] true
2024-07-09 15:46:13 [INFO] Load jdbc driver class: “org.mariadb.jdbc.Driver” finished
2024-07-09 15:46:13 [WARN] No tables are exists in the schema: “oceanbase”
2024-07-09 15:46:13 [WARN] No VIEW are exist in the schema: “oceanbase”
2024-07-09 15:46:13 [WARN] No SEQUENCE are exist in the schema: “oceanbase”
2024-07-09 15:46:13 [WARN] No TABLEGROUP are exist in the tenant: “dpa”
2024-07-09 15:46:13 [WARN] No FUNCTION are exist in the schema: “oceanbase”
2024-07-09 15:46:13 [WARN] No PROCEDURE are exist in the schema: “oceanbase”
2024-07-09 15:46:13 [ERROR] Dump failed! Error: No dump tasks are generated for schema: “oceanbase”
2024-07-09 15:46:13 [ERROR] System exit 1