Problém
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio ORA-39001: invalid argument value ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 1025: '+DATA/obsp/tempfile/temp.271.847014745' ORA-00942: table or view does not exist Tue Oct 20 17:41:06 2015 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j000_86339.trc: ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 1025: '+DATA/orcl/tempfile/temp.271.847014745'
Řešení
ASMCMD> pwd +data/orcl/tempfile ASMCMD> ls -la WARNING:option 'a' is deprecated for 'ls' please use 'absolutepath' Type Redund Striped Time Sys Name TEMPFILE MIRROR COARSE OCT 20 17:00:00 Y none => TEMP.271.847014745 SYS@orcl1> select file_name from dba_temp_files; select file_name from dba_temp_files * ERROR at line 1: ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 1025: '+DATA/orcl/tempfile/temp.271.847014745' SYS@orcl1> alter system check datafiles; System altered. Alert.log ---------- Tue Oct 20 17:49:57 2015 Read of datafile '+DATA/orcl/tempfile/temp.271.847014745' (fno 1025) header failed with ORA-01203 Rereading datafile 1025 header from mirror side 'HDD_E0_S04_1197721987P1' failed with ORA-01203 Rereading datafile 1025 header from mirror side 'HDD_E1_S11_1197718751P1' failed with ORA-01203 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_dbw0_71159.trc: ORA-01186: file 1025 failed verification tests ORA-01122: database file 1025 failed verification check ORA-01110: data file 1025: '+DATA/orcl/tempfile/temp.271.847014745' ORA-01203: wrong incarnation of this file - wrong creation SCN File 1025 not verified due to error ORA-01122 Recreate -------- SYS@orcl1> ALTER TABLESPACE USER_TEMP ADD TEMPFILE '+DATA' SIZE 10G; Tablespace altered. SYS@orcl1> select file_name from dba_temp_files; select file_name from dba_temp_files * ERROR at line 1: ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 1025: '+DATA/orcl/tempfile/temp.271.847014745' SYS@orcl1> ALTER DATABASE TEMPFILE '+DATA/orcl/tempfile/temp.271.847014745' DROP; Database altered. SYS@orcl1> select file_name from dba_temp_files; FILE_NAME -------------------------------------------------------------------------------- +DATA/orcl/tempfile/user_temp.557.893613303
MOS: OERR: ORA-1186 “file %s failed verification tests” Reference Note (Doc ID 18759.1)