My Oracle Support Banner

RMAN Duplicate Fails To Create Tempfiles With Errors ORA-01186/ORA-01122/ORA-01206/ORA-01203 (Doc ID 374934.1)

Last updated on SEPTEMBER 20, 2019

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.
***Checked for relevance on 27-NOV-2015***

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-01186: file 1025 failed verification tests
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-01186: file 1025 failed verification tests
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.