【达梦】DMRMAN达梦数据库冷备备份恢复

1.DmAPService 服务状态检查 

--进行备份必须确保这个服务是运行状态。
[dmdba@dm1 dmback]$ DmAPService status
DmAPService (pid 9123) is running.

2.冷备 

[dmdba@dm1 dmback]$ dmrman
dmrman V8
RMAN> backup database '/dm/mdbms/data/DAMENG1/dm.ini' backupset '/dm/dmback/dm_fullback';

RMAN> backup database '/dm/mdbms/data/DAMENG1/dm.ini' backupset '/dm/dmback/dm_fullback';
backup database '/dm/mdbms/data/DAMENG1/dm.ini' backupset '/dm/dmback/dm_fullback';
file dm.key not found, use default license!
[-137]:服务器正在运行或者存在其他进程正在操作同一个库

--需要先停止数据库 
[dmdba@dm1 DAMENG1]$ DmServiceDAMENG1 stop
Stopping DmServiceDAMENG1:                                 [ OK ]
[dmdba@dm1 DAMENG1]$ 
--重新执行冷备。
RMAN> backup database '/dm/mdbms/data/DAMENG1/dm.ini' backupset '/dm/dmback/dm_fullback';
backup database '/dm/mdbms/data/DAMENG1/dm.ini' backupset '/dm/dmback/dm_fullback';
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[126116], file_lsn[126116]
Processing backupset /dm/dmback/dm_fullback
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 
backup successfully!
time used: 00:00:03.372

3.删除文件并恢复 

[dmdba@dm1 DAMENG1]$ rm -rf BOOKSHOP.DBF 
[dmdba@dm1 DAMENG1]$ rm -rf tps_sjzt.DBF 

--还原数据库 
RMAN> restore database '/dm/mdbms/data/DAMENG1/dm.ini' from backupset '/dm/dmback/dm_fullback';
restore database '/dm/mdbms/data/DAMENG1/dm.ini' from backupset '/dm/dmback/dm_fullback';
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:02][Remaining:00:00:00]                                 
restore successfully.
time used: 00:00:02.468

--恢复数据库 
RMAN> recover database '/dm/mdbms/data/DAMENG1/dm.ini' from backupset '/dm/dmback/dm_fullback'
recover database '/dm/mdbms/data/DAMENG1/dm.ini' from backupset '/dm/dmback/dm_fullback'
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[126116], file_lsn[126116]
备份集[/dm/dmback/dm_fullback]备份过程中未产生日志
recover successfully!
time used: 277.354(ms)

--更新DB_MAGIC;
RMAN> recover database '/dm/mdbms/data/DAMENG1/dm.ini' update db_magic;
recover database '/dm/mdbms/data/DAMENG1/dm.ini' update db_magic;
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[126116], file_lsn[126116]
recover successfully!
time used: 00:00:01.013

4.启动数据库

启动并验证数据
[dmdba@dm1 dmback]$ DmServiceDAMENG1 start
Starting DmServiceDAMENG1:                                 [ OK ]

--数据还在，说明恢复完成。
SQL> select count(1) from sjzt.sjzt_tab1 ;

行号     COUNT(1)            
---------- --------------------
1          100

已用时间: 2.893(毫秒). 执行号:500.