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

ORA-01110: data file 121: '/pfrx11/db02/pfarex11_temp_01.dbf' --

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

ORA-01110: data file 124: '/pfrx11/db03/pfarex11_temp_04.dbf' --

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.

select * from v$tempfile;

alter database tempfile '/pfrx11/db02/pfarex11_temp_01.dbf' drop;

alter database tempfile '/pfrx11/db02/pfarex11_temp_03.dbf' drop;

select file_name,status from dba_temp_files;

ALTER DATABASE TEMPFILE ‘/patr11/db01/ts_temp_01.dbf’ online;

ALTER TABLESPACE TEMP ADD TEMPFILE '/pfrx11/db02/pfrx11_temp_03.dbf' SIZE 32000M REUSE AUTOEXTEND OFF;

ITPub博客

Get the below error after duplicating database