达梦数据库磁盘切换

1. 源数据库

1归档

ALTER DATABASE MOUNT;

ALTER DATABASE ADD ARCHIVELOG 'DEST = /mnt/sdb/shuju/archive_dest, TYPE = local, FILE_SIZE = 1024, SPACE_LIMIT = 2048';

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

2热备份

select object_type as "对象类型",count(*) as "数量" from dba_objects group by object_type;

backup database full to FULL_BACK01 BACKUPSET '/mnt/sdb/shuju1/';

select SF_BAKSET_CHECK('DISK','/mnt/sdb/shuju1/');

目标实例

服务器

进入安装目录

 cd /opt/dmdbms/bin

查看 dmap

systemctl status DmAPService

启动rman

./dmrman

停止目标实例

systemctl stop DmServiceDBSERVER.service

数据还原

restore database '/mnt/sdb/data/DMDB/dm.ini' from backupset '/mnt/sdb/shuju1';

归档

recover database '/mnt/sdb/data/DMDB/dm.ini' with archivedir '/mnt/sdb/shuju/archive_dest';

魔数更新

recover database '/mnt/sdb/data/DMDB/dm.ini' update db_magic;

修改实例端口

Vim dm.ini

 PORT_NUM    = 5237  #Port number on which the database server will listen

修改最大连接数

MAX_SESSIONS = 1000

停源库

数据库执行shutdown immediate或服务器systemctl stop  DmServiceDBSERVER.service

启动新实例

systemctl start DmServiceDBSERVER.service