联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有客户执行了drop tablespace xxx including contents and datafiles,虽然删除命令返回错误,但是该表空间中大量对象被删除,文件没有被从系统层面删除
Tue Jun 29 14:38:26 2021 DROP TABLESPACE "XFF" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS Tue Jun 29 14:38:32 2021 Thread 1 advanced to log sequence 975 (LGWR switch) Current log# 3 seq# 975 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\XFF\REDO03.LOG ORA-604 signalled during: DROP TABLESPACE "XFF" INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS... Tue Jun 29 14:40:44 2021 ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF' AUTOEXTEND ON NEXT 50M Completed: ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF' AUTOEXTEND ON NEXT 50M ALTER TABLESPACE "XFF" DROP DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF02.DBF' WARNING: Cannot delete file D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF02.DBF Errors in file d:\app\administrator\diag\rdbms\XFF\XFF\trace\XFF_ora_2528.trc: ORA-01265: 无法删除 DATA D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF02.DBF ORA-27056: 无法删除文件 OSD-04024: 无法删除文件。 O/S-Error: (OS 32) 另一个程序正在使用此文件，进程无法访问。 Completed: ALTER TABLESPACE "XFF" DROP DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF02.DBF' Tue Jun 29 14:58:51 2021 ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED Completed: ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XFF' AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
通过工具获取obj$字典信息，结合user$,判断业务用户表数据基本上全部删除
对于这类情况,常规方法无法恢复，只能按照表被drop的思路进行恢复.参考文章:dul恢复drop表测试,通过结合客户提供的表结构和一些特殊方法恢复出来所有对象的obj#,dataobj#信息,快速的恢复了客户数据,得到客户认可
加我QQ
