ORA-01122: database file 1001 failed verification check

[Ablakios]

Hi Gurus
Could you please help solve this issue?

Errors in file /opt/app/oracle/admin/HMPROD/bdump/hmprod_dbw0_28567

.trc:

ORA-01186: file 1001 failed verification tests

ORA-01122: database file 1001 failed verification check

ORA-01110: data file 1001: '/opt/app/oradata01/HMPROD/dbf/temp_01.dbf

'

ORA-01203: wrong incarnation of this file - wrong creation SCN

Wed Oct 7 16:05:53 2009

File 1001 not verified due to error ORA-01122

Wed Oct 7 16:05:53 2009

Dictionary check complete

Wed Oct 7 16:05:53 2009

SMON: enabling tx recovery

Wed Oct 7 16:05:53 2009

Cannot re-create tempfile /opt/app/oradata01/HMPROD/dbf/temp_01.dbf,

the same name file exists

Thanks

[Rayyah]

Offline the file 1001 ,open database and Drop and recreate the temp tablespace ,if its is true temporary tablespace just drop the tempfile..

[Ablakios]

thanks will try and advise

[gandolf989]

Did you just clone that database? If so you need to delete the temp files in the database clone before you clone. Otherwise you need to drop and recreate the temp tablespaces after you clone. In my testing of cloning via RMAN, I found that I does not take much more time to just delete all of the datafiles before I do the clone.

[Ablakios]

Thanks for the advise

[mahajanakhil198]

are cloning and database transportation the same things?

[davey23uk]

Originally Posted by mahajanakhil198

are cloning and database transportation the same things?

of course not

[mahajanakhil198]

except that we have to make the source database read only, what are the other differences? In essence, i have not found any.