【干货攻略】达梦数据库LINUX下误删数据文件如何进行数据恢复

SQL> create tablespace TEST_RM datafile '/dm8/data/DAMENG/TEST_RM01.DBF' size 128 ;
SQL>  create user TEST_RM identified by Dameng123 default tablespace TEST_RM;
SQL>  grant "PUBLIC","RESOURCE","SOI","VTI" to TEST_RM;
SQL> create table TEST_RM.T1 as select * from dba_objects;
SQL> select count(*) from TEST_RM.T1;
复制

[dmdba@localhost ~]$ cd dm8/data/DAMENG/
复制

[dmdba@RH6 DAMENG]$ mv TEST_RM01.DBF tmp
复制

SQL> select count(*) from TEST_RM.T1;
复制

SQL> select * from dba_data_files;
复制

SQL> SELECT GROUP_ID,PATH,CLIENT_PATH FROM "V$DATAFILE";
复制

SQL> call SP_FILE_SYS_CHECK();
SQL> select count(*) from TEST_RM.T1;
复制

SQL> call sp_tablespace_prepare_recover('TEST_RM');
复制

[dmdba@localhost DAMENG]$ ps -ef|grep dmserver
复制

[dmdba@localhost 1359]$ cd proc/1359/fd
[dmdba@RH6 fd]$ ls -ltr
复制

[dmdba@localhost fd]$  cp 49 dm8/data/DAMENG/TEST_RM01.DBF
复制

SQL> call sp_tablespace_recover('TEST_RM');
SQL> call SP_FILE_SYS_CHECK();
复制

SQL> select count(*) from TEST_RM.T1;
复制

SQL> SELECT GROUP_ID,PATH,CLIENT_PATH FROM "V$DATAFILE";
复制

已用时间: 0.450(毫秒). 执行号:53315.
SQL> select tablespace_name, file_name, status from dba_data_files;
复制