Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

clarification - DB restore - Database version

Hi,

We have a requirement for a system refresh from production to quality.

Quality system Oracle version : 11:2:0:3:0

Production system Oracle version : 11.2.0.4.0

SQL> SELECT * FROM v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


SQL> SELECT * FROM v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

I believe we cannot do a DB restore with this version mismatch, Can anyone clarify this.

Remaining everything is fine, SAP, Kernel and DB client and everything is same except the oracle version.

If I have to go for Oracle version upgrade, I believe I have to download the below marked file. Can someone clarify this,

As a alternative and last option, I am planning for Homogeneous system copy using SWPM, If the DB restore would not work.

Please share your inputs

Thanks, Ganesh

Former Member
replied

To do a system copy (backup and restore) you need to have both the databases at the same patch level which is 11.2.0.4.0. To upgrade the database from 11.2.0.3 to 11.2.0.4 you need to follow the database upgrade procedure which is installing 11.2.0.4 on a new filesystem and upgrading the database to 11.2.0.4.0 using DBUA. Check the Oracle upgrade guide for more information.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question