ORA-01187: cannot read from file nnn because it failed verification tests

Question:  This happened on Oracle 10.2.0.3 on linux, and I created a duplicate database using RMAN's duplicate utility, there wasn't any problem in duplicating the db; however i am not able to list my temp files in newly created db.

I checked files are physically available on the mentioned directory.  MOSC Note 18760.1 says to issue command ALTER DATABASE CHECK or open the database.

Database is already opened. Here I try this "alter database check" command:

What i am missing?

Answer:   First, MOSC is incorrect in this case and there is no "alter database check" command!

Here is the correct listing for ORA-01187:

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.

Since the TEMP tablespace was not be used at copy time, I would simple drop and recreate them.

MOSC note Note:18760.1 (dated 1999) and titled ?OERR: ORA 1187 cannot read from file because it failed verification test? is indeed incorrect:

ORA 1187 : cannot read from file <name> because it failed verification tests

Cause:  The datafile did not pass the checks to ensure it is part of the database.  Reading the file is not allowed until it is verified.

Action: Make the correct file available to database.  Then either open the database or execute ALTER DATABASE CHECK.