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

Last updated on APRIL 18, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms