达梦物理备份/恢复

达梦物理备份/恢复

一、物理备份

1. 联机备份

注：联机备份前提：开启归档

1. 1 完全备份

SQL> backup database full backupset '/dm/bak/full_database';    

1. 2 增量备份

(基于上次备份为起始点，到当前时间结束)
SQL> alter system switch logfile;               -------------切换归档
SQL> backup database increment with backupdir '/dm/bak' backupset '/dm/bak/increment_database';

1. 3 表空间备份

SQL> select TABLESPACE_NAME from dba_tablespaces;
SQL> backup tablespace system full backupset '/dm/bak/ts_system';

1. 4 表备份

SQL> backup table fx.t1 backupset '/dm/bak/tab_t1';

1. 5 备份所有归档

SQL> backup archive log all backupset '/dm/bak/arch';

1. 6 根据lsn号备份归档

SQL> select arch_lsn,clsn from v$arch_file;       ---------查询LSN

SQL> backup archivelog lsn between 30519 and 39331 backupset '/dm/bak/lsn_30519_39331';

2. 脱机备份

脱机备份支持库级和归档备份。
进入DMRMAN

2. 1 数据库备份

RMAN> backup database '/dm/data/DAMENG/dm.ini' backupset '/dm/bak/20220520';

2. 2 归档备份

SQL>  select first_change# from V$ AR select first_change# from V$ARCHIVED_LOG;

RMAN> backup archive log lsn between 25828 and 37222 database  '/data/dm/dm.ini' backupset '/data/bak/arch';

二、物理还原

1. 脱机还原

允许库级、表空间级和归档还原。分布式数据库仅支持库级脱机还原恢复。

1. 1 数据库还原

./dmrman

检查备份：RMAN> check backupset '/dm/bak/20220520'
还原：RMAN> restore database '/dm/data/DAMENG/dm.ini' from backupset '/dm/bak/20220520'				  					
恢复：RMAN> recover database '/data/dmdbms/DAMENG/dm.ini' from backupset '/dm/bak/20220520'; 
更新魔数：RMAN> recover database '/dm/data/DAMENG/dm.ini' update DB_MAGIC;

1. 2 归档还原

RMAN> check backupset '/dm/bak/arch';
RMAN> restore archive log from backupset '/dm/bak/arch' to database '/dm/data/DAMENG/dm.ini' overwrite 2;
RMAN>  repair archivelog database '/dm/data/DAMENG/dm.ini';

达梦技术社区：https://eco.dameng.com