达梦误删表空间恢复

1.构造测试环境

SQL> create tablespace tb_test datafile '/dm8/data/XGQ/tb_test.dbf' size 100;
executed successfully
used time: 14.472(ms). Execute id is 55202.
SQL>
SQL>
SQL> create table xgq(id int) storage(on tb_test);
executed successfully
used time: 4.169(ms). Execute id is 55203.
SQL>
SQL>
SQL> insert into xgq values(1);
affect rows 1

used time: 0.477(ms). Execute id is 55204.
SQL> commit;
executed successfully
used time: 4.106(ms). Execute id is 55205.

2.操作系统级删除数据文件

rm -f tb_test.dbf

3.检查表空间

SQL> SP_FILE_SYS_CHECK();
DMSQL executed successfully
used time: 0.370(ms). Execute id is 55209.
SQL>
SQL> select * from xgq;
select * from xgq;
[-3433]:tablespace is offline.
used time: 0.116(ms). Execute id is 0.

4.开始恢复

[dmdba@dm8 XGQ]$ ps -ef|grep dmserver
dmdba     14025  13965  0 18:26 pts/1    00:00:03 ./dmserver path=/dm8/data/XGQ/dm.ini
dmdba     14300  14251  0 18:33 pts/2    00:00:00 grep --color=auto dmserver
[dmdba@dm8 XGQ]$
[dmdba@dm8 XGQ]$
[dmdba@dm8 XGQ]$ cd /proc/14025/fd

[dmdba@dm8 fd]$ ls -l|grep deleted
lrwx------. 1 dmdba dinstall 64 Jul 12 18:33 44 -> /dm8/data/XGQ/tb_test.dbf (deleted)
[dmdba@dm8 fd]$
[dmdba@dm8 fd]$

SQL> SP_TABLESPACE_PREPARE_RECOVER('TB_TEST');
DMSQL executed successfully
used time: 0.377(ms). Execute id is 55212.

[dmdba@dm8 fd]$ cp 44 /dm8/data/XGQ/tb_test.dbf
[dmdba@dm8 fd]$
[dmdba@dm8 fd]$

SQL> SP_TABLESPACE_RECOVER('TB_TEST');
DMSQL executed successfully
used time: 6.878(ms). Execute id is 55213.
SQL>

SQL> select * from xgq;

LINEID     ID
---------- -----------
1          1

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