达梦备份和恢复

环境:

OS:Centos 7

DB:DM8

说明:

SQL模式的备份可以联机

dmrman模式的备份必须是脱机 

 

1.备份归档日志并删除

SQL> backup archivelog all delete input to "archbak_20220811" backupset '/dmdbms/backup/archbak_20220811';
executed successfully
used time: 00:00:03.687. Execute id is 2000.

[dmdba@localhost archbak_20220811]$ pwd
/dmdbms/backup/archbak_20220811
[dmdba@localhost archbak_20220811]$ ls -al
total 32668
drwxr-xr-x 2 dmdba dinstall       63 Aug 11 14:23 .
drwxr-xr-x 3 dmdba dinstall       30 Aug 11 14:23 ..
-rw-r--r-- 1 dmdba dinstall 33367552 Aug 11 14:23 archbak_20220811.bak
-rw-r--r-- 1 dmdba dinstall    78336 Aug 11 14:23 archbak_20220811.meta

 

2.全备+备份归档

 

#! /bin/bash
. /etc/profile
. ~/.bash_profile


backup_date=`date "+%Y%m%d"`
disql SYSDBA/dameng123<<EOF
backup database full backupset '/home/dmdba/rmanbak/fullbak_${backup_date}';
backup archivelog all delete input to "archbak_${backup_date}" backupset '/home/dmdba/rmanbak/archbak_${backup_date}';
exit;
EOF

 

 

查看刚才的备份
su - dmdba
dmrman
##查看备份
RMAN>show backupset '/dmdbms/backup/rmanbak/fullbak_20240104';
RMAN>show backupset '/dmdbms/backup/rmanbak/archbak_20240104';

##检查备份
RMAN> CHECK BACKUPSET '/dmdbms/backup/rmanbak/fullbak_20240104';

##查看配置
RMAN> CONFIGURE
THE DMRMAN DEFAULT SETTING:

DEFAULT DEVICE:
MEDIA : DISK
DEFAULT TRACE :
FILE : ../log/dm_SBTTRACE_202401.log
LEVEL : 1
DEFAULT BACKUP DIRECTORY:
TOTAL COUNT :0

DEFAULT ARCHIVE DIRECTORY:
TOTAL COUNT :0

DEFAULT OPEN FILES:
OPEN FILES : 65535
time used: 5.504(ms)