ORA-19690 ORA-19870 during rman recovery
(Doc ID 1424933.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.
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
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>'
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 |