误delete tab$后使用DUL类工具恢复数据(有抽取不出来的可能-原因未知)

1、实验环境
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

2、在会话1中delete tab$表
SQL> select count(*) from tab$;
  COUNT(*)
----------
      4496

SQL> delete from tab$;
4496 rows deleted.

SQL> commit;
Commit complete.

SQL> select count(*) from tab$;
  COUNT(*)
----------
         0

3、在会话2中尝试登陆数据库报错如下
[oracle@sourcedb ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 15:24:16 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-01075: you are currently logged on


SQL>  conn / as sysdba
ERROR:
ORA-01075: you are currently logged on


此时alert报错:
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2153.trc  (incident=19211):
ORA-00600: internal error code, arguments: [18061], [1403], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_19211/orcl_ora_2153_i19211.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun May 07 15:25:34 2017
Dumping diagnostic data in directory=[cdmp_20170507152534], requested by (instance=1, osid=2153), summary=[incident=19210].
Sun May 07 15:25:41 2017
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc  (incident=18228):
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_18228/orcl_m000_2159_i18228.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc:
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Dumping diagnostic data in directory=[cdmp_20170507152543], requested by (instance=1, osid=2159 (M000)), summary=[incident=18228].

4、在会话1中重启数据库
SQL> shutd
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值