SAP file system restoration on same server

[Former Member]

Hi all i have the followig problem:

We have experienced a hardware problem in a raid 5 disk enclosure and lost all the sap file systems, i have see a similiar threat i hope somebody can give me some tips to resolve this problem.

I need to restore the file system from a recent backup, the backup is a exact copy of all the file system do it with tar.

The solutions i think i need is in this threat http://scn.sap.com/message/8547835#8547835, but i'm not confident enough to do this without some guidelines.

Thanks in advance for all the help.

Regards,

Amaury

[former_member188883 · Accepted solution]

Hi Amaury,

Hope the system which has problem is not a production system.

In case it is a non Production system you may do the following

1) Restore all the files from the backup using overwrite option

2) As the restoration will be done on the same host from where backup was taken, you may simply start the database using

    SQL> startup

   Incase an error comes look for the details in alert_SID.log file

   Based on the error message relevant action can be performed

3) Once the database is started, start the listener

4) Check connection to database using R3trans -d

5) Check the return code of step 4. It should be 000

6) Start the SAP system using startsap r3

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

yes it was our production system, your guideline change in someway in this sceneario?

regards,

amaury

[former_member188883 · Accepted solution]

Hi Amaury,

In case its production the process is same. Only concern will be data loss as the backup is older.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

hopefully there will be only a day of data loss, the last offline full backup was 1 day before de failure.

thanks for the steps.

regards,

amaury

[former_member188883 · Accepted solution]

Hi Amaury,

Request you to close the thread incase your query has been answered.

Regards,

Deepak Kori

[Former Member · Accepted solution]

This message was moderated.