Shulou(Shulou.com)05/31 Report--

Editor to share with you the Oracle database clone temp file due to path changes can not find the problem how to do, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

After the Oracle database is cloned, the temp file cannot be found due to path change. The following error occurs

Errors in filexxxx.trc:

ORA-01157: cannot identify/lock data file xxx-see DBWR trace file

ORA-01110: data file 201: 'xxx/temp01.dbf'

Partial trace files:

DDE: Problem Key 'ORA 1110' was flood controlled (0x5) (no incident)

ORA-01110: data file 201: 'xxx/temp01.dbf'

ORA-01157: cannot identify/lock data file xxx-see DBWR trace file

ORA-01110: data file 201: 'xxx/temp01.dbf'

Dump of memory from 0x0000000126DCFA78 to 0x0000000126DCFDEA

126DCFA70 48544957 53574D20 [WITH MWS]

126DCFA80 20534120 45532820 5443454C 574F5220 [AS (SELECT ROW]

126DCFA90 204D554E 2C786469 4E495720 5F574F44 [NUM idx, WINDOW_]

126DCFAA0 454D414E 454E202C 535F5458 54524154 [NAME, NEXT_START]

126DCFAB0 5441445F 64732045 2020202C 20202020 [_ DATE sd,]

Treatment method:

1. Select * from dba_temp_files; will also report an error that the data file cannot be found.

You can query select * from v$tempfile

2. View the file through v$tempfile, start the database to mount state, alter database rename file''to''; modify the path.

3. Reopening the database will automatically create temporary data files.

These are all the contents of this article, "what to do if the temp file cannot find a problem due to path change after Oracle database cloning?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.