在bin里面停止服务
./dmserver stop
image.png
su - root
给权限
chown -R dmdba:dinstall /dbdata/dmdata/DAMENG/
到dmdbms里面
cd /home/dmdba/dm/dmdbms/bin
找到DAMENG
image.png
查看
image.png
复制dmarch.ini sqllog.ini到上一层
dmarch.ini sqllog.ini …/
返回上一层
cd …/
rm -rf DAMENG/
在bin里面重新初始化
./dminit INI_FILE=/dbdata/dmdata/DAMENG/dm.ini PATH=/dbdata/dmdata extent_size=16 page_size=32 case_sensitive=y log_size=2048
image.png
把备份的dmarch.ini sqllog.ini覆盖现在的
cp dmarch.ini sqllog.ini DAMENG/
cd /home/dmdba/dm/dmdbms/bin
image.png
重新启动服务
./dmserverd start
image.png

备份：
联机备份：在数据库bin目录下，使用disql命令
./disql sysdba/密码
全库备份
SQL>BACKUP DATABASE FULL BACKUPSET ‘/dbbak/dmbak/db_full_bak_01’ compressed;
增量备份
SQL>BACKUP DATABASE INCREMENT WITH BACKUPDIR ‘/dbbak/dmbak’ BACKUPSET ‘/dbbak/dmbak/db_increment_bak_02’;

脱机备份：在数据库bin目录下，使用如下命令进入DMRMAN系统：
./dmran
全库备份
RMAN>BACKUP DATABASE ‘/dbdata/dmdata/DAMENG/dm.ini’ FULL BACKUPSET '/dbbak/dmbak/db_full_bak_01’;
./dmrman CTLSTMT=“BACKUP DATABASE ‘/home/dmdba/dm/dmdbms/bin/dm.ini’ FULL TO BACKUP_FILE1 BACKUPSET ‘/dbdata/dmdata/DMDB/BACKUP_FILE_01’”
增量备份
RMAN>BACKUP DATABASE ‘/dbdata/dmdata/DAMENG/dm.ini’ INCREMENT WITH BACKUPDIR ‘/dbbak/dmbak’ BACKUPSET ‘/dbbak/dmbak/db_increment_bak_02’;

还原：
在数据库bin目录下，使用如下命令进入DMRMAN系统：
./dmran
校验备份
RMAN>CHECK BACKUPSET ‘/dbbak/dmbak/db_full_bak_01’;
还原数据库
RMAN>RESTORE DATABASE ‘/dbdata/dmdata/DAMENG/dm.ini’ FROM BACKUPSET ‘/dbbak/dmbak/db_full_bak_01’;
./dmrman CTLSTMT=“RESTORE DATABASE ‘/home/dmdba/dm/dmdbms/bin/dm.ini’ FROM BACKUPSET ‘/dbdata/dmdata/DMDB/BACKUP_FILE_01’”
恢复数据库
RMAN>RECOVER DATABASE ‘/dbdata/dmdata/DAMENG/dm.ini’ FROM BACKUPSET ‘/dbbak/dmbak/db_full_bak_01’;
./dmrman CTLSTMT=“RECOVER DATABASE ‘/home/dmdba/dm/dmdbms/bin/dm.ini’ FROM BACKUPSET ‘/dbdata/dmdata/DMDB/BACKUP_FILE_01’”