My Oracle Support Banner

ORA-19690 ORA-19870 during rman recovery (Doc ID 1424933.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***

Symptoms

Need to abort an 11g upgrade by restoring the database from the 10g backup taken before the upgrade.

The datafiles have been restored completed successfully in 10g but recovery is failing with the following errors:

ORA-19870: error reading backup <backuppiece_name>
ORA-19690: backup piece release 10.2.0.4.0 incompatible with Oracle release 10.2.0.0.0


When database's pfile compatible parameter is set to 10.2.0.4, the above errors for archivelogs are reported.

When the compatible is set to 10.2.0, the following errors for control file are reported:

SQL> startup mount
ORACLE instance started.

Total System Global Area 4865392640 bytes
Fixed Size                  2090528 bytes
Variable Size            2701134304 bytes
Database Buffers         2147483648 bytes
Redo Buffers               14684160 bytes
ORA-00201: control file version 10.2.0.4.0 incompatible with ORACLE version
10.2.0.0.0
ORA-00202: control file:
'<+asm disk path>/<controlfile_name>'


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.