This morning, when i went at office, I saw that backup didn't work this night (since 3 days). When I search why it didn't work in the log file, I read in it an error ora-01187 and ora-01110. They mean that a datafile called TOTO_TEMP2.ORA failed verification tests.
But unfortunatelly, I don't find the reason of this problem.
The files is on the disk, at the good folder, with the good name.
Can anyone help me.
Can I create a new tablespace which could replace this one. If yes, could you explain me risks there are to move users from one tablespace to the new tablespace. How can I drop the "bad tablespace" ?
I've already try to shutdown and restart the DB but nothing ....
The db has 50 M of SGA, archive log Mode is not activate, the instance has been created in 8.1.5 version, the db block size is set to 2048, the parameter mts_server in the init is set to 1, and time_Statistic is set to TRUE.
The OS i'm using is NT4.0 with sp4 SPack. I've remarqued that when I execute this request :
select * from v$datafile;
the tablespace with the file which is bad does't appear.
Oracle Docs says you have to issue ALTER DATABASE CHECK.
But I'm not sure if this can solve the problem. Was your database restored from backup datafile?
Is this a datafile of a TEMPORARY TABLESPACE, if it is, then you can recreate this. Issue the command to verify:
select file_name, status from dba_data_files
ORA-01187 cannot read from file string because it failed verification tests
Cause: The datafile did not pass the checks to insure it is part of the database. Reads are not allowed until it is verified.
Action: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES
I think your datafile is corrupted.
You can make new users and new tablespace but if those users have created any objects in the corrupt tablespace, I am afraid, I dont think they can be recovered.
You can drop the bad tablespace after taking it offline.