RMAN Duplicate Fails To Create Tempfiles With Errors ORA-01186/ORA-01122/ORA-01206/ORA-01203
(Doc ID 374934.1)
Last updated on FEBRUARY 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.4 [Release 10.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
In this example db name is AUX
During RMAN Duplication, we see below errors in the auxiliary instance while creating tempfiles:
ORA-01122: database file 1025 failed verification check
ORA-01110: data file 1025: '/<path>/temp_01.dbf'
ORA-01206: file is not part of this database - wrong database id
File 1025 not verified due to error ORA-01122
or
ORA-01122: database file 1025 failed verification check
ORA-01110: data file 1025: '/<path>/temp_01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN
File 1025 not verified due to error ORA-01122
The duplicate operation will not fail. The above errors only affect creation of tempfiles in the auxiliary instance.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |