[oracle@xifenfei check_db]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 5 21:13:28 2025 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> recover datafile 1;Media recovery complete. SQL> recover datafile 2,3,4,5,6,7,8,9,10; Media recovery complete.SQL> alter database open;alter database open*ERROR at line 1:ORA-01157: cannot identify/lock data file 11 - see DBWR trace fileORA-01110: data file 11:'/u01/app/oracle/product/11.2.0.4/db_1/dbs/path_to_datafile.dbf' SQL> alter database datafile 11 offline drop; Database altered. SQL> alter database open;alter database open*ERROR at line 1:ORA-01147: SYSTEM tablespace file 11 is offlineORA-01110: data file 11:'/u01/app/oracle/product/11.2.0.4/db_1/dbs/path_to_datafile.dbf'
alert日志报错信息
Sun Oct 05 22:35:01 2025alter database openSun Oct 05 22:35:01 2025Errors in file /data/app/oracle/diag/rdbms/mtxdb1/mtxdb1/trace/mtxdb1_dbw0_5946.trc:ORA-01157: cannot identify/lock data file 11 - see DBWR trace fileORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/path_to_datafile.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Errors in file /data/app/oracle/diag/rdbms/mtxdb1/mtxdb1/trace/mtxdb1_ora_11264.trc:ORA-01157: cannot identify/lock data file 11 - see DBWR trace fileORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/path_to_datafile.dbf'ORA-1157 signalled during: alter database open...Sun Oct 05 22:35:25 2025alter database datafile 11 offline ORA-1145 signalled during: alter database datafile 11 offline ...alter database datafile 11 offline dropCompleted: alter database datafile 11 offline dropalter database openErrors in file /data/app/oracle/diag/rdbms/mtxdb1/mtxdb1/trace/mtxdb1_ora_11264.trc:ORA-01147: SYSTEM tablespace file 11 is offlineORA-01110: data file 11: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/path_to_datafile.dbf'ORA-1147 signalled during: alter database open...
[oracle@xifenfei tmp]$ cat 1.txt1@/data/app/oracle/oradata/mtxdb1/system01.dbf11@/tmp/11.dbf[oracle@xifenfei tmp]$ ./m_scn 1.txt -------------Is processing datafile:/tmp/11.dbf-------------1+0 records in1+0 records out1048576 bytes (1.0 MB) copied, 0.000835728 s, 1.3 GB/s [oracle@xifenfei tmp]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 8 11:27:32 2025 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> set numw 16SQL> col CHECKPOINT_TIME for a40SQL> set lines 150SQL> set pages 1000SQL> SELECT status, 2 to_char(checkpoint_time,'yyyy-mm-dd hh24:mi:ss') checkpoint_time,FUZZY,checkpoint_change#, 3 count(*) ROW_NUM 4 FROM v$datafile_header 5 GROUP BY status, checkpoint_change#, to_char(checkpoint_time,'yyyy-mm-dd hh24:mi:ss'),fuzzy 6 ORDER BY status, checkpoint_change#, checkpoint_time; STATUS CHECKPOINT_TIME FUZ CHECKPOINT_CHANGE# ROW_NUM------- ---------------------------------------- --- ------------------ ----------------OFFLINE 2025-10-02 06:50:06 NO 17328662858685 1ONLINE 2025-10-02 06:50:06 NO 17328662858685 10 SQL> alter database datafile 11 online; Database altered.
然后重建ctl,并尝试打开库
然后查询11号文件中涉及的对象情况
SQL> select distinct owner,segment_name,segment_type from dba_extents where file_id=11; OWNER SEGMENT_NAME SEGMENT_TYPE------------------------------ -------------------------------------- ------------------SYS SYSTEM ROLLBACKSYS I_COL1 INDEXSYS AUD$ TABLE SQL> select owner,segment_name from dba_segments where HEADER_FILE=11; no rows selected
. . exported "XFF020"."OTHERBILLDETAIL_DEL" 6.405 MB 126048 rows. . exported "XFF020"."OSSOLDOUT" 7.784 MB 281413 rowsORA-31693: Table data object "XFF020"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=159:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020"."MATERIELTRAN"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=159:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block ORA-39097: Data Pump job encountered unexpected error -607ORA-39065: unexpected master process exception in DISPATCHORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], [] ORA-31693: Table data object "XFF020"."ANALYSEREPORT" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=161:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020"."ANALYSEREPORT"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020"."ANALYSEREPORT" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=161:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block ORA-31693: Table data object "XFF020CW"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=160:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020CW"."MATERIELTRAN"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020CW"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=160:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block Job "SYS"."SYS_EXPORT_FULL_01" stopped due to fatal error at Wed Oct 8 11:59:29 2025 elapsed 0 00:18:48
OSSOLDOUT" 7.784 MB 281413 rowsORA-31693: Table data object "XFF020"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=159:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020"."MATERIELTRAN"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=159:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block ORA-39097: Data Pump job encountered unexpected error -607ORA-39065: unexpected master process exception in DISPATCHORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], [] ORA-31693: Table data object "XFF020"."ANALYSEREPORT" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=161:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020"."ANALYSEREPORT"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020"."ANALYSEREPORT" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=161:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block ORA-31693: Table data object "XFF020CW"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=160:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"XFF020CW"."MATERIELTRAN"] UPDATE "SYS"."SYS_EXPORT_FULL_01" SET processing_state = :1, processing_status = :2 WHERE process_order = :3 AND duplicate = 0ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPW$WORKER", line 7866ORA-31693: Table data object "XFF020CW"."MATERIELTRAN" failed to load/unload and is being skipped due to error:ORA-39068: invalid master table data in row with PROCESS_ORDER=160:1000001ORA-00607: Internal error occurred while making a change to a data blockORA-00600: internal error code, arguments: [kdBlkCheckError], [11], [3], [18018], [], [], [], [], [], [], [], []ORA-06512: at "SYS.KUPF$FILE", line 3720ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105ORA-06512: at "SYS.KUPW$WORKER", line 9721 ----- PL/SQL Call Stack ----- object line object handle number name0xef2fc508 21979 package body SYS.KUPW$WORKER0xef2fc508 9742 package body SYS.KUPW$WORKER0xef2fc508 3437 package body SYS.KUPW$WORKER0xef2fc508 10436 package body SYS.KUPW$WORKER0xef2fc508 1824 package body SYS.KUPW$WORKER0xef2feb20 2 anonymous block Job "SYS"."SYS_EXPORT_FULL_01" stopped due to fatal error at Wed Oct 8 11:59:29 2025 elapsed 0 00:18:48
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
