Restore offline Backup

[Former Member]

Hi,

We are using Win 2003, Oracle 10G on EP 7.0

I tried to upgrade SPS10 to SPS11 on EP server but deployment is stuck.

I want to restore the offline backup on same E portal server as J2EE engine is unable to start and stack deployment is stuck.

I tried out everything but I am unable to start the J2EE and now I decided to restore the offline backup.

I have the backup of control files, log files & data files of oracle. Also, I have the backup of usr directory and saptrace, sapreorg, sapbackup, sapcheck and saparch.

If I replace the existing files/folders with this backup files then will I be able to start the system or is there any possibility to face any problems?

Thanks,

Rajesh

[Former Member · Accepted solution]

Hi Rajesh,

Shutting down all the Oracle and SAP services and restoring your <drive>:/oracle/<SID> directory and your <drive>:/usr/sap directory you will be able to start your portal at the point where you did your backup.

Since this is just a SPS, I do not see why you can face a problem restoring the file systems.

Waht I'd do is delete the the entire directory instead of replance files, just to have something cleaner.

Zareh

[markus_doehr2 · Accepted solution]

> Since this is just a SPS, I do not see why you can face a problem restoring the file systems.

So if you think this is "just" an SP - what kind of scenario can you imagine, that it doesn't work? The problem is, that the deployed components on the filesystem are newer than those in the database if the backup is not taken at the same time.

Markus

[Former Member · Accepted solution]

Markus,

What I meant was that restoring <drive>:/oracle/<SID> directory and your <drive>:/usr/sap from an offline backup will work.

Rajesh mentioned that:

"I have the backup of control files, log files & data files of oracle. Also, I have the backup of usr directory and saptrace, sapreorg, sapbackup, sapcheck and saparch."

I assume that it is a full offline backup of the server.

Other scenario that I was imagining was an upgrade, where it could be a little bit different that was just because I am doing one now.

Anyway if there is full offline backup, restoring <drive>:/oracle/<SID> directory and your <drive>:/usr/sap will take the system to state it was before the backup.

Zareh

[markus_doehr2 · Accepted solution]

yes - true - if the backups were taken both (means filesystem + database) before - yes.

Markus

[Former Member · Accepted solution]

Hi Markus,

Sorry i am a little confused with this topic, when you say:

filesystem is:

/oracle/SID/

/usr/

and database is: all the datafiles

Since we have ECC 6.0 (only ABAP) and BI / EP (ABAP + Java) i was thinking that the backups / restore strategy was similar in both worlds. But it appears that to do a restore in ABAP + Java enviroments you always need:

/oracle/SID/*

/usr/*

+

All datafiles.

Even if you only lost a datafile for example. As you explain is all about the synchronization between datafiles and database.

Best Regards,

Erick Ilarraza

[markus_doehr2 · Accepted solution]

Sorry for confusion - with "filesystem" I mean "/usr" (or /usr/sap/), not the filesystem the database file reside on.

So to be in sync you need a backup of the database and /usr (/usr/sap) at the same time to be able to recover nicely.

Markus

[Former Member · Accepted solution]

Ok!

Thanks a lot for your reply Markus.

Best Regards,

Erick Ilarraza

[Former Member · Accepted solution]

Hi Markus, Zareh & Erick,

Thank you for your time & reply.

We have the EP [AS JAVA] & I have the backup of

/oracle/SID/*

/usr/*

+

All datafiles.

I donu2019t have the backup of OS file system (in my case system state backup of windows), I want to just confirm that If I replace the existing files with this backup files then will I be able to start the system or is there any possibility to face any problems?

Also, please confirm that if I delete this folders or files inside the folders and restore them form backup am I able to start the system?

Thanks,

Rajesh

[markus_doehr2]

Java instance backups are different than ABAP instances. For ABAP it's enough to backup the database. For Java backups you need to consistently backup the database AND the filesystem. They both need to be in sync.

If you now restore your database backup and you have not backed up the filesystem, the system will most likely not be able to start.

Markus