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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2015***

Symptoms

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: '/u01/oradata/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: '/u01/oradata/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.

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
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.