Skip to Content
avatar image
Former Member

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 12, 2015 at 12:19 AM

    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>

    It says unable to open the file `C:\ORACLE\DER\SAPDATA1\SYSTEM_1\SYSTEM.DATA1`

    Is this file present at the OS level?

    Instead of running the script like that follow this:

    Create a file called ControlDER.sql at C:\ORACLE\DER

    Add the control file script to ControlDER.sql and save it.

    Connect to SQL

    SQL > @C:\ORACLE\DER\ControlDER.sql

    Cheers

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 03:25 AM

    Hi Vitaliy,

    Here we need to look for few more things,firstly check for the file SYSTEM.DATA1 at OS level and run control<SID>.sql command as like suggested by RB with one more major modification in it.

    Install new Oracle DB (SID: DEC)

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

    As per this your new SID to restore the system would be DEC instead of DER,so modify the control<SID>.sql row (CREATE CONTROLFILE SET DATABASE "DER" RESETLOGS  ARCHIVELOG) with ( CREATE CONTROLFILE SET DATABASE "DEC" RESETLOGS  ARCHIVELOG ).


    Addition to it modify old server SID i.e DER with new SID i.e DEC in your sql script.


    Hope this will help you.


    Regards,

    Gaurav




    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vitaly,

      As suggested by Regan & Gaurav, Do modify the control file you have backed up of DER and then modify it to New SID "DEC".

      If the Control file of DER is not available then you can create one use " alter database backup controlfile to trace".

      And remove out all the newly created data files from this trace file after backup and modify the trace file as per the instructions given by Gaurav for the "CREATE CONTROLFILE SET DATABASE "DEC" RESETLOGS  ARCHIVELOG".


      and then run the controlfile.sql using SQL with database in  STARTUP NOMOUNT. Let us know the outcome.


      Regards,

      Ram


  • avatar image
    Former Member
    Jan 12, 2015 at 11:38 AM

    I have compressed offline backup by using brtools (tr. DB13 in SAP) «SYSTEM.DATA1K and other files to». How I cane decompress this file using brtools? After, I can copy this file SYSTEM.DATA1 in directory «C:\ORACLE\DER\SAPDATA1\SYSTEM_1»

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Srinivasan Vinayagam

      Hi Srinivasan Vinayagam,

      I turn on in «initSID.sap» parameter:

      uncompress_cmd = “c:\usr\sap\PER\SYS\exe\uc\NTAMD64\uncompress –c $ >$”

      In cmd I write:

      "Drive:\usr\sap\SID\SYS\exe\uc\NTAMD64\uncompress -c  Drive:\location of SYSTEM.DATA1.K”

      And I see next message:

      The filename, directory name, or volume label syntax is incorrect.

      What I do wrong?


      Regards, Vitaliy