达梦物理全量和归档恢复

物理备份恢复最常用的是全量备份和归档备份恢复

1、传输备份到目标库（/backup/full_bak)

将主库服务器/backup/full_bak中最近的完全备份集传输到目标单机上

scp -r /dmdata/bak/db_bak_01/ 10.99.1.130:/dmdata

然后拷贝全备时间点附近及之后的归档到目标单机上

scp ARCHIVE_LOACL1_2022-04-06_19-08-46.log 10.99.1.130:/dmdata/arch

scp ARCHIVE_LOACL1_2022-04-06_19-54-46.log 10.99.1.130:/dmdata/arch

2、目标端恢复数据库

Root:systemctl stop DmServiceSRVDP.service

Dmdba:dmrman

RMAN>check backupset ‘/dmdata/db_bak_01’;

RMAN>restore database ‘/dmdata/DMSERVERSDP/dm.ini’ from backupset  ‘/dmdata/db_bak_01’;

RMAN>recover database ‘/dmdata/DMSERVERSDP/dm.ini’ with archivedir  ‘/dmdata/arch’;

RMAN>recover database ‘/dmdata/DMSERVERSDP/dm.ini’ update DB_MAGIC;

3、目标端启动数据库（用源库的用户和密码）

Root:systemctl start DmServiceSRVDP.service

4、将数据库模式改为普通模式再打开数据库

Disql sysdba/***@10.99.1.130:5236

SQL>Alter database normal;

SQL>Alter database open;