达梦备份恢复

达梦数据库备份恢复

1.配置 dm.ini，打开 ARCH_INI 参数
ARCH_INI = 1 #打开归档配置
2.配置 dmarch.ini
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /dm/data/DAMENG/arch #本地归档文件存放路径
ARCH_FILE_SIZE = 128 #单位 Mb，本地单个归档文件最大值
ARCH_SPACE_LIMIT = 0 #单位 Mb， 0 表示无限制，范围 1024~4294967294M

联机备份
mkdir /home/dmdba/dmdbms/bak
SQL> backup database backupset ‘mkdir /home/dmdba/dmdbms/bak/backup_file_01’;
拷贝备份文件
初始化实例
RMAN> restore database ‘/home/dmdba/dmdbms/data/DAMENG/dm.ini’ from backupset ‘/home/dmdba/dmdbms/data/bak/backup_file_01’;
recover database ‘/home/dmdba/dmdbms/data/DAMENG/dm.ini’ from backupset ‘/home/dmdba/dmdbms/data/bak/backup_file_01’;
recover database ‘/home/dmdba/dmdbms/data/DAMENG/dm.ini’ update db_magic;

脱机备份
正常关闭数据库
./dmrman
backup database ‘/home/dmdba/dmdbms/data/DAMENG/dm.ini’ full backupset ‘/home/