达梦脱机备份也称冷备份，指在数据库关闭状态下进行数据备份，可以进行库级、归档备份
第一步：将数据库关闭，使数据库处于脱机状态
第二步：备份
- 1、进入 dmrman
./dmrman
- 2、进行备份
backup database '/home/dm/data/PROD/dm.ini' backupset '/home/dm/backup/20230214'
整体运行结果如下：
[dmdba@localhost bin]$ ps -ef|grep dma
dmdba 6622 1 0 Feb10 ? 00:00:10 /home/dm/app/db/bin/dmap
dmdba 92777 92502 0 15:10 pts/1 00:00:00 grep --color=auto dma
[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> backup database '/home/dm/data/PROD/dm.ini' backupset '/home/dm/backup/20230214';
backup database '/home/dm/data/PROD/dm.ini' backupset '/home/dm/backup/20230214';
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[11465296], file_lsn[11465296]
Processing backupset /home/dm/backup/20230214
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:05][Remaining:00:00:00]
backup successfully!
第三步
- 1、还原
restore database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214
- 2、恢复
recover database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214'
- 3、更新数据库魔数
recover database '/dm8/data/DMDB/dm.ini' update db_magic
整体运行结果如下：
-sh-4.2$ ./dmrman
dmrman V8
RMAN>
RMAN>
RMAN>
RMAN> restore database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214';
restore database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:29][Remaining:00:00:00]
restore successfully.
time used: 00:00:29.628
RMAN> recover database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214';
recover database '/dm8/data/DMDB/dm.ini' from backupset '/dm8/backup/20230214';
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[11465296], file_lsn[11465296]
备份集[/dm8/backup/20230214]备份过程中未产生日志
recover successfully!
time used: 343.230(ms)
RMAN> recover database '/dm8/data/DMDB/dm.ini' updatedb_magic;
[-8301]:SQL[recover database '/dm8/data/DMDB/dm.ini' updatedb_magic;]第[1]行，第[41]列[updatedb_magic]附近出现错误[-2007]:语法分析出错
RMAN> recover database '/dm8/data/DMDB/dm.ini' update db_magic;
recover database '/dm8/data/DMDB/dm.ini' update db_magic;
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[11465296], file_lsn[11465296]
recover successfully!
time used: 00:00:01.115
