达梦备份恢复相关

达梦简单创建过程, 不知道为什么恢复总是部分表没有数据.

./dminit path=/opt/dmdbms/data INSTANCE_NAME=DMSERVER PORT_NUM=5236 charset=0 log_size=2048 page_size=32
rm -rf  /opt/dmdbms/bin/DmServiceDMSERVER

 cd /opt/dmdbms/script/root/
./dm_service_installer.sh -t dmserver -p DMSERVER -dm_ini  /opt/dmdbms/data/DAMENG/dm.ini
cd /opt/dmdbms/bin
./DmServiceDMSERVER start
./disql SYSDBA/SYSDBA

create tablespace gscloud2009dm datafile '/opt/dmdbms/data/DAMENG/gscloud2009dm.dbf' size 256;

create user gscloud2009dm  identified by 123456789 default tablespace gscloud2009dm ;

grant dba,resource to gscloud2009dm ;

select * from v$dm_ini where para_name like '%CHARSET%';

./dimp gscloud2009dm/123456789 fromuser=gscloud2009dm touser=gscloud2009dm file=/root/gscloud2009dm.dmp log=/root/2021021902.txt

select * from v$dm_ini where para_name like '%CHARSET%';

./disql GSCLOUD2009DM/123456789

select  count(1) from PFACT_GE_PROPERTY ;
原文地址:https://www.cnblogs.com/jinanxiaolaohu/p/14417865.html