第一台机器备份操作 1.sudo yum install nfs-utils 2.sudo vi /etc/exports 3.sudo chown nobody:nobody -R /data/nfs_server 4.sudo systemctl restart nfs-server 5.sudo vi /etc/sysconfig/nfs 输入内容 RPCNFSDCOUNT=8 RPCNFSDARGS="-N 2 -N 3 -U" NFSD_V4_GRACE=90 NFSD_V4_LEASE=90 6.sudo systemctl restart nfs-server sudo vi /etc/sysctl.conf sudo sysctl -w sunrpc.tcp_max_slot_table_entries=128 cat /proc/sys/sunrpc/tcp_max_slot_table_entries 7.obclient -h127.0.0.1 -P2881 -uroot -p'Passw' obclient [(none)]> CREATE RESOURCE POOL dscom_resource_pool1 -> UNIT = 'dscom_unit_config1', -> UNIT_NUM = 1, -> zone_list = ('zone1'); Query OK, 0 rows affected (0.022 sec) obclient [(none)]> CREATE TENANT IF NOT EXISTS test_tenant -> PRIMARY_ZONE='zone1', -> RESOURCE_POOL_LIST=('dscom_resource_pool1') -> set OB_TCP_INVITED_NODES='%'; Query OK, 0 rows affected (36.809 sec) obclient [(none)]> ALTER SYSTEM SET LOG_ARCHIVE_DEST='LOCATION=file:///data/nfs/backup/archive' TENANT = test_tenant; Query OK, 0 rows affected (0.107 sec) obclient [(none)]> ALTER SYSTEM ARCHIVELOG TENANT = test_tenant; Query OK, 0 rows affected (0.016 sec) obclient [(none)]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = 'USER'\G *************************** 1. row *************************** TENANT_NAME: test_tenant LOG_MODE: ARCHIVELOG 1 row in set (0.038 sec) obclient [(none)]> ALTER SYSTEM SET DATA_BACKUP_DEST= 'file:///data/nfs/backup/data' TENANT = test_tenant; Query OK, 0 rows affected (0.052 sec) obclient [(none)]> ALTER SYSTEM BACKUP DATABASE; Query OK, 0 rows affected (0.038 sec) 第二台机器恢复操作 1.obclient -h127.0.0.1 -P2881 -uroot -p'Passw' obclient [oceanbase]> CREATE RESOURCE UNIT dscom_unit_config1 -> max_cpu = 1, -> min_cpu = 1, -> memory_size = '3G', -> log_disk_size = '3G'; Query OK, 0 rows affected (0.037 sec) obclient [oceanbase]> CREATE RESOURCE POOL dscom_resource_pool1 -> UNIT = 'dscom_unit_config1', -> UNIT_NUM = 1, -> zone_list = ('zone1'); Query OK, 0 rows affected (0.041 sec) obclient [oceanbase]> ALTER SYSTEM RESTORE mysql FROM 'file:///data/nfs/backup/data,file:///data/nfs/backup/archive' WITH 'pool_list=dscom_resource_pool1'; Query OK, 0 rows affected (1 min 1.313 sec)