Skip to Content
avatar image
Former Member

backup restore

Dear All,

I have installed new system SAP ECC 6.0. I want to restore other system backup.

Anybody know the restore backup .

regards

kiruba

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Dec 17, 2009 at 03:31 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      I guess the restore done has some problems or your Backup has some problems.

      Please check all the logs file such as alertlog,recovery,backup,etc.,

      Regards,

      Yoganand.V

  • avatar image
    Former Member
    Dec 18, 2009 at 05:29 AM

    Go through www.service.sap.com/systemcopy (using backup restore method).

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2009 at 08:18 AM

    Have you recovered your database using archivelogs before starting DB(if you restored online backup)?

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 19, 2009 at 01:18 AM

    Hi,

    Did you restore from an online backup or offline backup ? If it is an online backup, please restore the archivelogs and recover the database using the same, before opening.

    Regards,

    Sanujit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear All,

      Thanks to all

      *****************************

      SQL> startup

      ORACLE instance started.

      Total System Global Area 608174080 bytes

      Fixed Size 1262272 bytes

      Variable Size 314576192 bytes

      Database Buffers 289406976 bytes

      Redo Buffers 2928640 bytes

      Database mounted.

      ORA-01122: database file 1 failed verification check

      ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

      ORA-01203: wrong incarnation of this file - wrong creation SCN

      ****************************************

      this issue resolved by myself.

      solution :

      I restored archive also and afterwards I have another message when i gave the command startup, message is ORA-01589:must use RESETLOGS and NORESETLOGS option for database open

      for this message need to give command ALTER DATABASE OPEN RESETLOGS;

      Then after shutdown databse and startup again.

      ________________

      Now I am facing an error in startsap.

      the error is

      /usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12

      DB startup failed

      Regarding this issue I have followed belos SAP notes.

      SAP notes : 50088 and 400241

      still I am not able to resolve, Kindly guide me ..

      Regards

      kiruba.

  • avatar image
    Former Member
    Dec 19, 2009 at 06:36 AM
    this issue resolved by myself. 
    solution :
    I restored archive also and afterwards I have another message when i gave the command startup, message is ORA-01589:must use RESETLOGS and NORESETLOGS option for database open
    
    
    for this message need to give command ALTER DATABASE OPEN RESETLOGS;
    
    Then after shutdown databse and startup again.

    This is not an issue or bug as you haven't followed the normal recovery process after restore, so you might struggled.

    If you are running on Windows just follow Sap note 50088

    If your OS is *NIX, then follow 400241

    Delete all the OPS$ users which are showing with source SID and recreate new OPS$ users based on new SID

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Peter Dzurov

      Dear All,

      Thank you very much for your guidence.

      Solution :

      I hava execute the following command and after start the sap, its working fine.

      brconnect -u system/<system passwd> -f chpass -o SAPPRD -p <sapser passwd >

      Regards

      kiruba.

  • avatar image
    Former Member
    Dec 20, 2009 at 09:45 AM

    Thanks to all

    Add comment
    10|10000 characters needed characters exceeded