Skip to Content

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

Restore DB on the database on the new server

Hello!

I have only full offline backup SAP system (SID: DER) and I need to restore this backup on new server.

What I wont:

Install new Windows

Install new DB

Restore my old DB (SID: DER)

Install SAP system

My old system:

Windows Server 2012

Oracle 11g

SAP ERP R3 (NetWeaver 7.02)

My new system, have the same parameters.

What have i done:

Install Windows

Install new Oracle DB (SID: DEC)

And now I try restore old DB (SID: DER) use offline backup

I took on another SAP system (SID: DEC) structure:

SQL> alter database backup controlfile to trace

Created structure (sql scripts) I copied on new server (SID:DEC)

On new server, I do next:

SQL>connect /as sysdba
SQL> STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DER" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 255
    MAXLOGMEMBERS 3
    MAXDATAFILES 1000
    MAXINSTANCES 50
    MAXLOGHISTORY 1168
LOGFILE
  GROUP 1 (
    'C:\ORACLE\DER\ORIGLOGA\LOG_G11M1.DBF',
    'C:\ORACLE\DER\MIRRLOGA\LOG_G11M2.DBF'
  ) SIZE 200M BLOCKSIZE 512,
  GROUP 2 (
    'C:\ORACLE\DER\ORIGLOGB\LOG_G12M1.DBF',
    'C:\ORACLE\DER\MIRRLOGB\LOG_G12M2.DBF'
  ) SIZE 200M BLOCKSIZE 512,
  GROUP 3 (
    'C:\ORACLE\DER\ORIGLOGA\LOG_G13M1.DBF',
    'C:\ORACLE\DER\MIRRLOGA\LOG_G13M2.DBF'
  ) SIZE 200M BLOCKSIZE 512,
  GROUP 4 (
    'C:\ORACLE\DER\ORIGLOGB\LOG_G14M1.DBF',
    'C:\ORACLE\DER\MIRRLOGB\LOG_G14M2.DBF'
  ) SIZE 200M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  'C:\ORACLE\DER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
  'C:\ORACLE\DER\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',
  'C:\ORACLE\DER\SAPDATA1\UNDO_1\UNDO.DATA1',
  'C:\ORACLE\DER\SAPDATA2\SR3_1\SR3.DATA1',
  'C:\ORACLE\DER\SAPDATA2\SR3_2\SR3.DATA2',
  'C:\ORACLE\DER\SAPDATA2\SR3_3\SR3.DATA3',
  'C:\ORACLE\DER\SAPDATA3\SR3731_1\SR3731.DATA1',
  'C:\ORACLE\DER\SAPDATA3\SR3731_2\SR3731.DATA2',
  'C:\ORACLE\DER\SAPDATA4\SR3USR_1\SR3USR.DATA1'
CHARACTER SET UTF8
;
 
CREATE CONTROLFILE SET DATABASE "DER" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE FAILED
ORA-01565: ERROR IN IDENTIFYING FILE
`C:\ORACLE\DER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1`
ORA-27041: unable to open file;
OSD-04992: unable to open file
O/S- ERROS: <OS 2> 
 

What I do wrong? What I shood do?

Please help me.

Thanks in advance!

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