gruntjs bom 乱码 html iis,误操作删除数据文件恢复案例讨论-CSDN博客

在执行数据库checkpoint操作后，遇到了ORA-01171和ORA-01110错误，表明datafile7无法在线并出现打开错误。日志显示datafile7('/u01/app/oracle/oradata/yft/jack01.dbf')丢失，导致无法查询数据。进一步查看进程句柄，发现与该数据文件相关的句柄已消失，可能的原因包括文件系统问题或数据文件物理损坏。

摘要由CSDN通过智能技术生成

----在拷贝之前，数据库checkpoint了一下----

1 SQL> alter system checkpoint;2

3 System altered.4

----告警日志中的错误----

5 Thu Jan 10 08:35:08 2013

6 Errors in file /u01/app/oracle/diag/rdbms/yft/yft/trace/yft_ckpt_3915.trc:7 ORA-01171: datafile 7 going offline due to error advancing checkpoint

8 ORA-01116: error in opening database file 7

9 ORA-01110: data file 7: '/u01/app/oracle/oradata/yft/jack01.dbf'

10 ORA-27041: unable to open file

11 Linux Error: 2: No such file ordirectory12 Additional information: 3

----查询不到数据，并报错----

14 SQL> select * fromecho.tab;15 select * fromecho.tab16 *

17 ERROR at line 1:18 ORA-00376: file 7 cannot be readat this time19 ORA-01110: data file 7: '/u01/app/oracle/oradata/yft/jack01.dbf'

----句柄已经消失----

21 [oracle@yft ~]$ ll /proc/3911/fd22 total 0

23 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 0 -> /dev/null

24 l-wx------ 1 oracle oinstall 64 Jan 10 08:14 1 -> /dev/null

25 l-wx------ 1 oracle oinstall 64 Jan 10 08:14 10 -> /u01/app/oracle/diag/rdbms/yft/yft/trace/yft_ora_3855.trc

26 l-wx------ 1 oracle oinstall 64 Jan 10 08:14 11 -> /u01/app/oracle/diag/rdbms/yft/yft/trace/yft_ora_3855.trm

27 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 12 -> /u01/app/oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msb

28 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 13 -> /dev/zero

29 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 14 -> /proc/3911/fd

30 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 15 -> /dev/zero

31 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 16 -> /u01/app/oracle/product/11.2.0/db_1/dbs/hc_yft.dat

32 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 17 -> /u01/app/oracle/product/11.2.0/db_1/dbs/lkYFT

33 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 18 -> /u01/app/oracle/oradata/yft/control01.ctl

34 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 19 -> /u01/app/oracle/flash_recovery_area/yft/control02.ctl

35 l-wx------ 1 oracle oinstall 64 Jan 10 08:14 2 -> /dev/null

36 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 22 -> socket:[13943]

37 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 23 -> /u01/app/oracle/oradata/yft/system01.dbf

38 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 24 -> /u01/app/oracle/oradata/yft/sysaux01.dbf

39 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 25 -> /u01/app/oracle/oradata/yft/undotbs01.dbf

40 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 26 -> /u01/app/oracle/oradata/yft/users01.dbf

41 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 27 -> /u01/app/oracle/oradata/yft/example01.dbf

42 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 28 -> /u01/app/oracle/oradata/yft/yft01.dbf

43 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 29 -> /u01/app/oracle/oradata/yft/temp01.dbf

44 l-wx------ 1 oracle oinstall 64 Jan 10 08:14 3 -> /u01/app/oracle/product/11.2.0/db_1/rdbms/log/yft_ora_3855.trc

45 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 30 -> /u01/app/oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msb

46 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 4 -> /dev/null

47 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 5 -> /dev/null

48 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 6 -> /dev/null

49 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 7 -> /u01/app/oracle/product/11.2.0/db_1/dbs/hc_yft.dat

50 lrwx------ 1 oracle oinstall 64 Jan 10 08:14 8 -> /u01/app/oracle/product/11.2.0/db_1/dbs/lkinstyft (deleted)

51 lr-x------ 1 oracle oinstall 64 Jan 10 08:14 9 -> /proc/3911/fd