################# OCP IP ################# # 10.100.0.14 ################# 主库 IP ################# # 10.100.0.74 # 10.100.0.75 # 10.100.0.76 ################# 备库 IP ################# # 10.100.0.77 ################# 备库 10.100.0.77 ################# root@test-host5:~# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/observer/v4.5.0_CE/oceanbase-ce-libs-4.5.0.0-100000012025112711.el7.x86_64.rpm root@test-host5:~# rpm2cpio oceanbase-ce-libs-4.5.0.0-100000012025112711.el7.x86_64.rpm | cpio -idmv root@test-host5:~# scp -rp * home / root@test-host5:/data# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/observer/v4.5.0_CE/oceanbase-ce-4.5.0.0-100000012025112711.el8.x86_64.rpm root@test-host5:/data# rpm2cpio oceanbase-ce-4.5.0.0-100000012025112711.el8.x86_64.rpm | cpio -idmv root@test-host5:/data# ls -l total 189020 drwxr-xr-x 3 root root 4096 Feb 3 22:49 home -rw-r--r-- 1 root root 193544264 Dec 3 19:44 oceanbase-ce-4.5.0.0-100000012025112711.el8.x86_64.rpm drwxr-xr-x 3 root root 4096 Feb 3 22:49 usr root@test-host5:/data# cp -rp home / root@test-host5:/data# cp -rp usr / root@test-host5:/data# chown -R admin:admin /home/admin/oceanbase/ root@test-host5:~# echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:~/oceanbaseone/lib' >> ~/.bash_profile root@test-host5:~# su - admin To run a command as administrator (user "root"), use "sudo ". See "man sudo_root" for details. admin@test-host5:~$ admin@test-host5:~$ admin@test-host5:~$ for link_name in {etc3,sstable,slog}; > do > ln -s /data/1/database2/$link_name /home/admin/oceanbase/store/database2/$link_name; > done admin@test-host5:~$ for link_name in {clog,etc2}; > do > ln -s /data/log1/database2/$link_name /home/admin/oceanbase/store/database2/$link_name; > done admin@test-host5:~$ tree /home/admin/oceanbase/store/ /home/admin/oceanbase/store/ └── database2 ├── clog -> /data/log1/database2/clog ├── etc2 -> /data/log1/database2/etc2 ├── etc3 -> /data/1/database2/etc3 ├── slog -> /data/1/database2/slog └── sstable -> /data/1/database2/sstable 6 directories, 0 files admin@test-host5:~$ cd /home/admin/oceanbase admin@test-host5:~/oceanbase$ /home/admin/oceanbase/bin/observer -I 10.100.0.77 -p 2881 -P 2882 -z zone1 -d /home/admin/oceanbase/store/database2 -r '10.100.0.77:2882:2881' -c 1 -n database2 -o "config_additional_dir=/data/1/database2/etc3;/data/log1/database2/etc2" /home/admin/oceanbase/bin/observer -I 10.100.0.77 -p 2881 -P 2882 -z zone1 -d /home/admin/oceanbase/store/database2 -r 10.100.0.77:2882:2881 -c 1 -n database2 -o config_additional_dir=/data/1/database2/etc3;/data/log1/database2/etc2 local_ip: 10.100.0.77 mysql port: 2881 rpc port: 2882 zone: zone1 data_dir: /home/admin/oceanbase/store/database2 rs list: 10.100.0.77:2882:2881 cluster id: 1 appname: database2 optstr: config_additional_dir=/data/1/database2/etc3;/data/log1/database2/etc2 admin@test-host5:~/oceanbase$ ps -ef | grep observer admin 9155 1 17 23:19 ? 00:00:04 /home/admin/oceanbase/bin/observer -I 10.100.0.77 -p 2881 -P 2882 -z zone1 -d /home/admin/oceanbase/store/database2 -r 10.100.0.77:2882:2881 -c 1 -n database2 -o config_additional_dir=/data/1/database2/etc3;/data/log1/database2/etc2 admin 9518 7901 0 23:20 pts/0 00:00:00 grep --color=auto observer admin@test-host5:~/oceanbase$ netstat -ntlp (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 9155/observer tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 9155/observer tcp 0 0 0.0.0.0:2882 0.0.0.0:* LISTEN 9155/observer tcp 0 0 127.0.0.53:53 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN - tcp6 0 0 :::2882 :::* LISTEN 9155/observer admin@test-host5:~/oceanbase$ admin@test-host5:~/oceanbase$ exit root@test-host5:~# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/libobclient/v2.2.10/libobclient-2.2.10-1.el7.x86_64.rpm root@test-host5:~# rpm2cpio libobclient-2.2.10-1.el7.x86_64.rpm | cpio -idmv root@test-host5:~# cp -rp u01 / root@test-host5:~# chown -R admin:admin /u01 root@test-host5:~# su - admin To run a command as administrator (user "root"), use "sudo ". See "man sudo_root" for details. admin@test-host5:~$ echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/obclient/lib' >> ~/.bash_profile admin@test-host5:~$ cat ~/.bash_profile export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:~/oceanbaseone/lib export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/obclient/lib admin@test-host5:~$ source ~/.bash_profile admin@test-host5:~$ echo $LD_LIBRARY_PATH :/home/admin/oceanbaseone/lib:/u01/obclient/lib:/home/admin/oceanbaseone/lib:/u01/obclient/lib admin@test-host5:~$ root@test-host5:~# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/obclient/v2.2.10/obclient-2.2.10-4.el8.x86_64.rpm root@test-host5:~# rpm2cpio obclient-2.2.10-4.el8.x86_64.rpm | cpio -idmv root@test-host5:~# root@test-host5:~# cp -rf u01 usr / root@test-host5:~# chown -R admin:admin /{u01,usr/lib/.build-id} root@test-host5:~# cat >> /etc/profile << EOF export PATH=\$PATH:/u01/obclient/bin EOF root@test-host5:~# source /etc/profile root@test-host5:~# su - admin To run a command as administrator (user "root"), use "sudo ". See "man sudo_root" for details. admin@test-host5:~$ obclient -h127.0.0.1 -uroot -P2881 Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 3221228842 Server version: OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:05:51) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@(none))[(none)]> set session ob_query_timeout=720000000000; Query OK, 0 rows affected (0.000 sec) obclient(root@(none))[(none)]> alter system bootstrap ZONE 'zone1' SERVER '10.100.0.77:2882'; Query OK, 0 rows affected (9.895 sec) obclient(root@(none))[(none)]> alter user root identified by 'Abcd1234'; Query OK, 0 rows affected (0.048 sec) obclient(root@(none))[(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | LBACSYS | | mysql | | oceanbase | | ORAAUDITOR | | SYS | | sys_external_tbs | | test | +--------------------+ 8 rows in set (0.003 sec) obclient(root@(none))[(none)]> create user proxyro identified by "Abcd1234"; Query OK, 0 rows affected (0.045 sec) obclient(root@(none))[(none)]> grant select on *.* to proxyro; Query OK, 0 rows affected (0.048 sec) obclient(root@(none))[(none)]> select sha1('Abcd1234'); +------------------------------------------+ | sha1('Abcd1234') | +------------------------------------------+ | b44dda1dadd351948fcace1856ed97366e679239 | +------------------------------------------+ 1 row in set (0.001 sec) obclient(root@(none))[(none)]> exit; Bye admin@test-host5:~$ exit root@test-host5:~# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/obproxy/v4.3.5_CE/obproxy-ce-4.3.5.0-3.el8.x86_64.rpm root@test-host5:~# rpm2cpio obproxy-ce-4.3.5.0-3.el8.x86_64.rpm | cpio -idmv root@test-host5:~# cp -rp home usr / root@test-host5:~# mv /home/admin/obproxy-4.3.5.0 /home/admin/obproxy root@test-host5:~# chown -R admin:admin /{home/admin,usr/lib/.build-id} admin@test-host5:~$ /home/admin/obproxy/bin/obproxy -p 2883 -s 2885 -r '10.100.0.77:2881' -n obproxy_database2 -o observer_sys_password=b44dda1dadd351948fcace1856ed97366e679239,obproxy_sys_password=b44dda1dadd351948fcace1856ed97366e679239,enable_cluster_checkout=false,proxy_id=1,client_session_id_version=2 -c database2 /home/admin/obproxy/bin/obproxy -p 2883 -s 2885 -r 10.100.0.77:2881 -n obproxy_database2 -o observer_sys_password=b44dda1dadd351948fcace1856ed97366e679239,obproxy_sys_password=b44dda1dadd351948fcace1856ed97366e679239,enable_cluster_checkout=false,proxy_id=1,client_session_id_version=2 -c database2 listen port: 2883 rpc service listen port: 2885 rs list: 10.100.0.77:2881 appname: obproxy_database2 optstr: observer_sys_password=b44dda1dadd351948fcace1856ed97366e679239,obproxy_sys_password=b44dda1dadd351948fcace1856ed97366e679239,enable_cluster_checkout=false,proxy_id=1,client_session_id_version=2 cluster_name: database2 admin@test-host5:~$ obclient -h10.100.0.77 -uroot@sys#database2 -P2883 -p Enter password: Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 262146 Server version: OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:05:51) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@sys)[(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | LBACSYS | | mysql | | oceanbase | | ORAAUDITOR | | SYS | | sys_external_tbs | | test | +--------------------+ 8 rows in set (0.003 sec) obclient(root@sys)[(none)]> exit; Bye admin@test-host5:~$ ################# 主库 IP 10.100.0.74 ################# root@test-host1:~# obclient -h10.100.0.74 -uroot@sys#database1 -P2883 -p'Abcd1234' -D oceanbase Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 2374429 Server version: OceanBase_CE 4.4.1.0 (r100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88) (Built Oct 16 2025 10:13:47) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@sys)[oceanbase]> (SELECT LS_ID FROM oceanbase.CDB_OB_LS_HISTORY WHERE TENANT_ID = 1001) EXCEPT (SELECT LS_ID FROM oceanbase.CDB_OB_LS WHERE TENANT_ID = 1004); Empty set (0.125 sec) obclient(root@sys)[oceanbase]> select TENANT_ID , TENANT_NAME from oceanbase.DBA_OB_TENANTS; +-----------+-------------+ | TENANT_ID | TENANT_NAME | +-----------+-------------+ | 1 | sys | | 1003 | META$1004 | | 1004 | testdb | +-----------+-------------+ 3 rows in set (0.011 sec) obclient(root@sys)[oceanbase]> SELECT LS_ID, BEGIN_LSN FROM oceanbase.GV$OB_LOG_STAT WHERE TENANT_ID = 1004 AND ROLE = 'LEADER' ; +-------+-----------+ | LS_ID | BEGIN_LSN | +-------+-----------+ | 1002 | 0 | | 1003 | 0 | | 1 | 0 | | 1001 | 0 | +-------+-----------+ 4 rows in set (0.004 sec) obclient(root@sys)[oceanbase]> CALL DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT(PRIMARY_TENANT_ID => 1004, STANDBY_TENANT_UNIT_NUM => 1); +------------------------+------------+ | PHYSICAL_RESOURCE_NAME | MIN_VALUE | +------------------------+------------+ | memstore | 0 | | memory | 4294967296 | | data_disk | 0 | | clog_disk | 4294967296 | | cpu | 0 | +------------------------+------------+ 5 rows in set (0.032 sec) Query OK, 0 rows affected (0.032 sec) obclient(root@sys)[oceanbase]> exit; root@test-host1:~# obclient -h10.100.0.74 -uroot@testdb#database1 -P2883 -p'Abcd1234' -D oceanbase Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 2374431 Server version: OceanBase_CE 4.4.1.0 (r100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88) (Built Oct 16 2025 10:13:47) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@testdb)[oceanbase]> CREATE USER rep_user IDENTIFIED BY "Abcd1234"; Query OK, 0 rows affected (0.097 sec) -- obclient(root@testdb)[(oceanbase)]> GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO rep_user; -- Query OK, 0 rows affected (0.174 sec) obclient(root@testdb)[oceanbase]> GRANT all privileges on *.* to rep_user; Query OK, 0 rows affected (0.104 sec) obclient(root@testdb)[oceanbase]> exit; Bye root@test-host1:~# root@test-host1:~# obclient -h10.100.0.74 -urep_user@testdb#database1 -P2883 -p'Abcd1234' Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 2414153 Server version: OceanBase_CE 4.4.1.0 (r100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88) (Built Oct 16 2025 10:13:47) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(rep_user@testdb)[(none)]> exit Bye root@test-host1:~# obclient -h10.100.0.74 -urep_user@testdb -P2881 -p'Abcd1234' Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 3221519472 Server version: OceanBase_CE 4.4.1.0 (r100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88) (Built Oct 16 2025 10:13:47) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(rep_user@testdb)[(none)]> exit Bye root@test-host1:~# ################# 备库 10.100.0.77 ################# admin@test-host5:~$ obclient -h10.100.0.77 -uroot@sys#database2 -P2883 -p Enter password: Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 262146 Server version: OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:05:51) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@sys)[(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | LBACSYS | | mysql | | oceanbase | | ORAAUDITOR | | SYS | | sys_external_tbs | | test | +--------------------+ 8 rows in set (0.003 sec) obclient(root@sys)[(none)]> obclient(root@sys)[(none)]> select * from oceanbase.__all_virtual_sys_parameter_stat where name = '__min_full_resource_pool_memory'; +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+---------------+-----------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | value_strict | info | need_reboot | section | visible_level | scope | source | edit_level | default_value | isdefault | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+---------------+-----------+ | zone1 | observer | 10.100.0.77 | 2882 | __min_full_resource_pool_memory | INT | 5368709120 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5368709120 | 1 | +-------+----------+-------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+---------------+-----------+ 1 row in set (0.024 sec) obclient(root@sys)[(none)]> select * from oceanbase.DBA_OB_UNITS; +---------+-----------+--------+------------------+---------------+----------------------------+----------------------------+-------+-------------+----------+---------------------+-----------------------+----------------+----------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+--------------+ | UNIT_ID | TENANT_ID | STATUS | RESOURCE_POOL_ID | UNIT_GROUP_ID | CREATE_TIME | MODIFY_TIME | ZONE | SVR_IP | SVR_PORT | MIGRATE_FROM_SVR_IP | MIGRATE_FROM_SVR_PORT | MANUAL_MIGRATE | UNIT_CONFIG_ID | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | DATA_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | MAX_NET_BANDWIDTH | NET_BANDWIDTH_WEIGHT | REPLICA_TYPE | +---------+-----------+--------+------------------+---------------+----------------------------+----------------------------+-------+-------------+----------+---------------------+-----------------------+----------------+----------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+--------------+ | 1 | 1 | ACTIVE | 1 | 1 | 2026-02-04 00:02:30.161026 | 2026-02-04 00:02:30.161026 | zone1 | 10.100.0.77 | 2882 | NULL | NULL | NULL | 1 | 1 | 1 | 5368709120 | 5368709120 | NULL | 9223372036854775807 | 9223372036854775807 | 1 | 9223372036854775807 | 1 | FULL | +---------+-----------+--------+------------------+---------------+----------------------------+----------------------------+-------+-------------+----------+---------------------+-----------------------+----------------+----------------+---------+---------+-------------+---------------+----------------+---------------------+---------------------+-------------+---------------------+----------------------+--------------+ 2 rows in set (0.004 sec) obclient(root@sys)[oceanbase]> select * from oceanbase.__all_virtual_sys_parameter_stat where name = 'memory_limit'; +-------+----------+-------------+----------+--------------+-----------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------+-------------+----------+---------------+---------+---------+-------------------+---------------+-----------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | value_strict | info | need_reboot | section | visible_level | scope | source | edit_level | default_value | isdefault | +-------+----------+-------------+----------+--------------+-----------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------+-------------+----------+---------------+---------+---------+-------------------+---------------+-----------+ | zone1 | observer | 10.100.0.77 | 2882 | memory_limit | CAPACITY | 16G | NULL | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | NULL | OBSERVER | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +-------+----------+-------------+----------+--------------+-----------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------+-------------+----------+---------------+---------+---------+-------------------+---------------+-----------+ 1 row in set (0.003 sec) obclient(root@sys)[(none)]> CREATE RESOURCE UNIT S1_unit_config -> MEMORY_SIZE = '5G', -> MAX_CPU = 1, MIN_CPU = 1, -> LOG_DISK_SIZE = '10G', -> MAX_IOPS = 100000, MIN_IOPS = 100000, IOPS_WEIGHT=1; Query OK, 0 rows affected (0.011 sec) obclient(root@sys)[(none)]> CREATE RESOURCE POOL mq_pool_01 -> UNIT='S1_unit_config', -> UNIT_NUM=1, -> ZONE_LIST=('zone1'); Query OK, 0 rows affected (0.019 sec) ################# 主库 IP 10.100.0.74 ################# root@test-host1:~# obclient -h10.100.0.74 -uroot@testdb#database1 -P2883 -p'Abcd1234' -D oceanbase Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 2413992 Server version: OceanBase_CE 4.4.1.0 (r100000032025101610-70824e90816ed333c56f3dd1af34ffec43d0fa88) (Built Oct 16 2025 10:13:47) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@testdb)[oceanbase]> select * from DBA_OB_ACCESS_POINT; +-----------+-------------+--------------+----------+ | TENANT_ID | TENANT_NAME | SVR_IP | SQL_PORT | +-----------+-------------+--------------+----------+ | 1002 | testdb | 10.100.0.74 | 2881 | | 1002 | testdb | 10.100.0.75 | 2881 | | 1002 | testdb | 10.100.0.76 | 2881 | +-----------+-------------+--------------+----------+ 3 rows in set (0.096 sec) obclient(root@testdb)[oceanbase]> exit; ################# 备库 10.100.0.77 ################# admin@test-host5:~/oceanbase/log/log$ obclient -h10.100.0.77 -uroot@sys -P2881 -pAbcd1234 Welcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 3221569430 Server version: OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:05:51) Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient(root@sys)[(none)]> CREATE STANDBY TENANT IF NOT EXISTS testdb LOG_RESTORE_SOURCE='SERVICE=10.100.0.74:2881;10.100.0.75:2881;10.100.0.76:2881 USER=rep_user@testdb PASSWORD=Abcd1234' RESOURCE_POOL_LIST=('mq_pool_01'); ERROR 4012 (HY000): Timeout obclient(root@sys)[(none)]> SELECT TENANT_NAME, TENANT_TYPE, CREATE_TIME, STATUS, TENANT_ROLE, SYNC_SCN FROM oceanbase.DBA_OB_TENANTS; +-------------+-------------+----------------------------+------------------+-------------+---------------------+ | TENANT_NAME | TENANT_TYPE | CREATE_TIME | STATUS | TENANT_ROLE | SYNC_SCN | +-------------+-------------+----------------------------+------------------+-------------+---------------------+ | sys | SYS | 2026-02-04 00:02:30.183510 | NORMAL | PRIMARY | NULL | | META$1012 | META | 2026-02-05 00:10:53.743813 | NORMAL | PRIMARY | NULL | | testdb | USER | 2026-02-05 00:10:53.745939 | CREATING_STANDBY | STANDBY | 1770140001903892999 | +-------------+-------------+----------------------------+------------------+-------------+---------------------+ 3 rows in set (0.026 sec) ################# 主库 IP 10.100.0.74 ################# obclient(root@testdb)[oceanbase]> show processlist; +------------+----------+--------------------+-----------+---------+------+--------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------------+----------+--------------------+-----------+---------+------+--------+------------------+ | 2371913 | root | 10.100.0.74:60056 | oceanbase | Sleep | 104 | SLEEP | NULL | | 2455530 | root | 10.100.0.74:60746 | oceanbase | Sleep | 489 | SLEEP | NULL | | 3221973199 | rep_user | 10.100.0.77:55692 | oceanbase | Sleep | 3 | SLEEP | NULL | | 3221981140 | rep_user | 10.100.0.77:55690 | oceanbase | Sleep | 11 | SLEEP | NULL | | 3221855620 | root | 10.100.0.14:45092 | oceanbase | Sleep | 147 | SLEEP | NULL | | 3221961667 | root | 10.100.0.14:45110 | oceanbase | Sleep | 147 | SLEEP | NULL | | 2371913 | root | 10.100.0.74:55464 | oceanbase | Query | 0 | ACTIVE | show processlist | | 3222193903 | rep_user | 10.100.0.77:56824 | oceanbase | Sleep | 3 | SLEEP | NULL | | 3222167321 | rep_user | 10.100.0.77:56822 | oceanbase | Sleep | 1 | SLEEP | NULL | | 3221687614 | rep_user | 10.100.0.77:52194 | oceanbase | Sleep | 3 | SLEEP | NULL | | 2371913 | root | 10.100.0.74:55586 | oceanbase | Sleep | 101 | SLEEP | NULL | | 3221686386 | rep_user | 10.100.0.77:52192 | oceanbase | Sleep | 1 | SLEEP | NULL | +------------+----------+--------------------+-----------+---------+------+--------+------------------+ 12 rows in set (0.008 sec)