达梦数据库DM8在windows上使用命令通过物理备份进行完整恢复测试一例

郑全

1.开启归档
   具体步骤略

2.准备演示数据
   SQL> create table emp(empid number,last_name varchar(20));
   操作已执行
   已用时间: 9.743(毫秒). 执行号:2804.
   SQL> insert into emp values(100,'abc');
   影响行数 1

   已用时间: 1.166(毫秒). 执行号:2805.
   SQL> commit;
   操作已执行
   已用时间: 5.511(毫秒). 执行号:2806.
   SQL> exit


3.联机备份

   c:\dmdbms\bin>disql sysdba/sztech_4U@192.168.133.1:5236

服务器[192.168.133.1:5236]:处于普通打开状态
登录使用时间 : 21.604(ms)
disql V8
SQL> backup database full backupset 'd:\backup\dm_full\db_full_bak_04';
操作已执行
已用时间: 00:00:05.272. 执行号:2505.

2.破坏环境
   略

3.创建一个空环境
dminit PATH=C:\dmdbms\data DB_NAME=DAMENG INSTANCE_NAME=DAMENG SYSDBA_PWD=sztech_4U SYSAUDITOR_PWD=sztech_4U PORT_NUM=5236

4.还原数据库
  RMAN> restore database 'C:\dmdbms\data\DAMENG\dm.ini' from backupset 'd:\backup\dm_full\db_full_bak_04';
restore database 'C:\dmdbms\data\DAMENG\dm.ini' from backupset 'd:\backup\dm_full\db_full_bak_04';
Read ini warning, default dm.ctl backup path [C:\dmdbms\data\DAMENG\ctl_bak] does not exist.
Read ini warning, default backup path [C:\dmdbms\data\DAMENG\bak] does not exist.
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:03][Remaining:00:00:00]
restore successfully.
time used: 00:00:03.791

5.还原归档日志

rman>restore archive log from backupset 'd:\backup\arch_0307' to archivedir 'd:\arch_log';

此处由于在同一台机器，归档没有变化，暂时不用还原。


6.恢复数据库
  RMAN> recover database 'C:\dmdbms\data\DAMENG\dm.ini' from backupset 'd:\backup\dm_full\db_full_bak_04';
recover database 'C:\dmdbms\data\DAMENG\dm.ini' from backupset 'd:\backup\dm_full\db_full_bak_04';
Read ini warning, default backup path [C:\dmdbms\data\DAMENG\bak] does not exist.
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[58621], file_lsn[58621]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:03.036

7.刷归档日志

RMAN> recover database 'C:\dmdbms\data\DAMENG\dm.ini' with archivedir 'd:\arch_log';
recover database 'C:\dmdbms\data\DAMENG\dm.ini' with archivedir 'd:\arch_log';
Read ini warning, default backup path [C:\dmdbms\data\DAMENG\bak] does not exist.
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[58800], file_lsn[58800]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 740.874(ms)

8.更新数据库magic  (resetlogs)
RMAN> recover database 'C:\dmdbms\data\DAMENG\dm.ini' update db_magic;
recover database 'C:\dmdbms\data\DAMENG\dm.ini' update db_magic;
Read ini warning, default backup path [C:\dmdbms\data\DAMENG\bak] does not exist.
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[58979], file_lsn[58979]
recover successfully!
time used: 00:00:01.342

9.打开数据库
  dbserver.exe path=C:\dmdbms\data\DAMENG\dm.ini

10.验证数据库
  在另外一个窗口
  c:\dmdbms\bin>disql
disql V8
用户名:sysdba
密码:


服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 20.866(ms)
SQL> select * from emp;

行号       EMPID LAST_NAME
---------- ----- ---------
1          100   abc

已用时间: 5.736(毫秒). 执行号:801.
SQL>

数据已经回来。