达梦数据DM8主从数据同步
时间: 2023-12-26 21:41:21 浏览: 32
达梦数据DM8主从数据同步的步骤如下:
1. 首先,跳过以下步骤:cd /dm/app/db/bin dmctlcvt TYPE=3 SRC=/dm/data/PROD/dmwatcher.ini DEST=/dm/data/PROD/ cd /dm/data/PROD/ mv ./GRP1/* ./ chown -R dmdba:dinstall dmwatcher.ctl 将文件传到备份服务器 su - dmdba cd /dm/backup scp -r prod_fb_20201124/ 192.168.222.134:/dm/backup cd /dm/data/PROD/ scp dmarch.ini dmmal.ini dmwatcher.ini dmwatcher.ctl 192.168.222.134:/dm/data/PROD/ 关闭数据服务,重启 cd /dm/app/db/bin ./DmServicePROD stop ./dmserver path=/dm/data/PROD/dm.ini mount \[1\]
2. 在从机上启动管道服务器:cd /dm/app/db/bin ./DmAPService start \[1\]
3. 创建备份还原目录:su - dmdba mkdir -p /dm/data/PROD/ctl_bak mkdir -p /dm/data/PROD/bak \[2\]
4. 使用dmrman进行备库备份还原,确保在dmdba用户下执行以下命令:cd /dm/app/db/bin dmrman RMAN>RESTORE DATABASE TO '/dm/data/PROD' overwrite FROM BACKUPSET '/dm/backup/prod_fb_20201124'; RMAN>RECOVER DATABASE '/dm/data/PROD/dm.ini' FROM BACKUPSET '/dm/backup/prod_fb_20201124'; RMAN>RECOVER DATABASE '/dm/data/PROD/dm.ini' UPDATE DB_MAGIC; \[2\]
5. 创建数据库实例,要在root用户下执行以下代码:cd /dm/app/db/script/root #dm7执行 ./dm_service_installer.sh -t dmserver -p PROD -i /dm/data/PROD/dm.ini #dm8执行 #主库 ./dm_service_installer.sh -t dmserver -p PROD -dm_ini /dm/data/PROD/dm.ini #备库 ./dm_service_installer.sh -t dmserver -p STB1 -i /dm/data/PROD/dm.ini \[3\]
这些步骤将帮助您在达梦数据DM8中实现主从数据同步。请确保按照顺序执行这些步骤,并根据您的具体情况进行相应的调整。
#### 引用[.reference_title]
- *1* *2* *3* [DM8数据库实时主备](https://blog.csdn.net/qq_51808662/article/details/124091535)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]