达梦数据库备份及还原

1、登录数据库服务器，进入达梦的bin目录

cd /data/dmdbms/bin

2、通过命令进行备份

./dexp ncc_2005/nccloud001 file=/data/ncc_2005_yace_dbbak202006.dmp parallel=16 log=/data/test.log

#ncc_2005为用户名/模式名

#nccloud001为对应的用户密码

#file后的值为导出数据库的存放路径及文件名



#进一步优化速度的可选参数

#FAST_LOAD=Y

#TASK_THREAD_NUMBER=8

3、导出完成确认文件存在

导出部分表

 ./dexp NCC_2005_DM8/nccloud001@127.0.0.1:5237 file=/data/dm8/1.dmp log=/data/dm8/1.log TABLES=SM_CREATECORP,sm_appmenuitem,sm_appmenureg,sm_appregister,temp_pam_pk

数据库导入： ./dimp NCC2005/nccloud001@127.0.0.1:5237 file=/data/ncc_dm/ncc_dm/imp_exp.dmp parallel=16 log=/data/ncc_dm/ncc_dm/202010231605.imp.log

可选参数 ：remap_schema=原:新

/data/dm8/bin/dexp "SYSDBA"/"******"@localhost:5236 DIRECTORY=/data/dbbak FILE=NCC2111_FEELING_exp.2022.06.24.dmp SCHEMAS="\"NCC2111_FEELING\"" COMPRESS=Y TABLESPACE=Y TABLE_POOL=20 DROP=N PARALLEL=32 TABLE_PARALLEL=4 LOG=NCC2111_FEELING_exp.2022.06.24.log LOG_WRITE=N

/opt/dmdbms/bin/dimp "SYSDBA"/"******"@LOCALHOST:5236 DIRECTORY=/data/software FILE=NCC2111_FEELING_exp.2022.06.24.dmp SCHEMAS="\"NCC2111_FEELING\"" IGNORE=N COMPILE=Y INDEXFIRST=N TABLE_FIRST=N COMMIT_ROWS=20000 FAST_LOAD=N PARALLEL=64 LOG=NCC2111_FEELING_exp.2022.06.24.dmp.imp_2022_06_24_14_26_23.log LOG_WRITE=N

#启用快速装载

/data/dm8/bin/dimp "SYSDBA"/"******"@localhost:5237 DIRECTORY=/data/dbbak FILE=yonbip_ruipu_0613_exp.dmp IGNORE=N COMPILE=Y INDEXFIRST=N TABLE_FIRST=N COMMIT_ROWS=5000 FAST_LOAD=Y FLDR_ORDER=Y LOB_NOT_FAST_LOAD=N TASK_THREAD_NUMBER=64 BUFFER_NODE_SIZE=2048 TASK_SEND_NODE_NUMBER=16 REMAP_SCHEMA="YONBIP_RUIPU_0613":"YONBIP_RUIPU_YACE" PARALLEL=100 LOG=yonbip_ruipu_0613_exp.dmp.imp_2022_06_29_12_40_29.log LOG_WRITE=N

./dimp YONBIP_RUIPU/XXX@127.0.0.1:5247 DIRECTORY=/data/backup FILE=yonbip_ruipu_20220722.imp_exp.dmp SCHEMAS=YONBIP_RUIPU IGNORE=N COMPILE=Y INDEXFIRST=N TABLE_FIRST=N COMMIT_ROWS=15000 FAST_LOAD=N PARALLEL=96 LOG=imp_2022_07_22_18_58_25.log LOG_WRITE=N dummy=N

/data/dmdbms_V8_20201026/bin/dimp "YONBIP_RUIPU"/"******"@LOCALHOST:5248 DIRECTORY=/data/backup FILE=yonbip_ruipu_20220722.imp_exp.dmp SCHEMAS="\"YONBIP_RUIPU\"" IGNORE=N COMPILE=Y INDEXFIRST=N TABLE_FIRST=N COMMIT_ROWS=5000 FAST_LOAD=N PARALLEL=48 LOG=imp_2022_07_23_11_16_59.log LOG_WRITE=N