达梦8热备份与恢复（增量备份）

1.热备保持数据库开启状态，但归档是必须要开启的
./DmServicedmdb start

2.开启归档
alter database mount;
alter database add archivelog ‘dest=/dmdata/arch,TYPE=local,FILE_SIZE=256,SPACE_LIMIT=1024’;
alter database archivelog;
alter database open;

切换归档检查归档是否生效
alter system switch logfile;


3.使用rman在线全备
disql sysdba/dameng123
backup database full to “dmdb_full_02” backupset ‘/dmdata/dmback/dmdb_full_02’;

备份后再插入数据
insert into rmantest values (2,‘达梦数据库公司’);

4.增量备份
backup database increment base on backupset ‘/dmdata/dmback/dmdb_full_02’ to “dmdb_incr_02” backupset ‘/dmdata/dmback/dmdb_full_incr_02’;

5.模拟删除数据库文件，演练数据库故障
rm -rf /dmdata/dmdb/*.DBF

6.数据库还原
./DmServicedmdb stop

再次启库发现数据库文件已经丢失

cd /home/dmdba/dmdbms/bin/
./dmrman
restore database ‘/dmdata/dmdb/dm.ini’ from backupset ‘/dmdata/dmback/dmdb_full_02’

restore database ‘/dmdata/dmdb/dm.ini’ from backupset ‘/dmdata/dmback/dmdb_full_incr_02’

recover database ‘/dmdata/dmdb/dm.ini’ from backupset ‘/dmdata/dmback/dmdb_full_02’

recover database ‘/dmdata/dmdb/dm.ini’ from backupset ‘/dmdata/dmback/dmdb_full_incr_02’

recover database ‘/dmdata/dmdb/dm.ini’ update db_magic

exit;

7.重新启动数据库
./DmServicedmdb start

8.验证数据
disql sysdba/dameng123
select name,status$ from v$database;

9.其它信息查询

查看数据库魔数 (类似SCN)
SELECT DB_MAGIC FROM V$RLOG;

数据库永久魔数
SELECT PERMANENT_MAGIC;s

查看备份集db_magic
./dmrman
show backupset ‘/dmdata/dmback/dmdb_full_02’;

欢迎进入达梦社区
https://eco.dameng.com