Skip to Content
Aug 19, 2009 at 09:16 PM

System Copy/ Oracle Backup/Restore as part of migrating from 32 to 64-bit


Source system (I386): R3E47 Ext Set 2.00 SAP_BASIS 620 Kernel 640 Windows 2000, Oracle, non-unicode

Target system (x86-64/AMD64): R3E47 Ext Set 2.00 SAP_BASIS 620 Kernel 640 Windows 2000 Oracle, non-unicode

Am using method System Copy/ Oracle Backup/Restore to migrate from 32 to 64 bit (HOM System Copy).

Actions on source system:

a) Upgrade from to Oracle

b) Used ora_br_copy.bat to generate CONTROL.SQL and init<sid>.ora

c) Switched logfiles

d) Performed offline backup

Actions on target system:

a) Installed Oracle and patched it to

b) Used CD 51033746 "6.20/6.40 based products Installation Master (Edition May 2008)" to install the CI

c) Started installation of the DB instance selecting System Copy/ Oracle Backup/Restore (same <SID> for source and target systems)

Relevant input parameters used:

Database schema: SAPR3

Database character set: US7ASCII

d) When SAPINST stopped to allow for restoring of datafiles, logs and init<sid.ora>:

- copied datafiles and logs to the usual place

- copied CONTROL.SQL (edited to include utilrp.sql and utlrp.sql for the migration from 32 to 64) to the DB-instance intallation . directory.

- copied generated init<SID>.ora to the <ORACLE_HOME>\database

e) Resumed SAPINST.

David Byrne in a previous post suggested: "check your oracle alert file in case there are errors there you may need to update the word size for the 64bit install. Errors like this in the oracle alert file would suggest that.,


ORA-06544: PL/SQL: internal error, arguments: [ORA-06544: PL/SQL: internal error, arguments: 56319], [, ], [, ], [, ], [


Well, I am getting ORA-06553: PLS-801: internal error [56319] but then my edited CONTROL.SQL (which is mainly a CREATE CONTROLFILE as it would be obtained with a ...BACKUP CONTROLFILE TO TRACE) includes at the end this:

shutdown immediate

startup upgrade

spool utlirp.log


spool off

Shutdown immediate


Spool utlrp.log


Spool off


which is supposed to do just that... (I think)

Help, anyone? 😉