Can i restore the system via FS restore

[Former Member]

Hi Techies,

As per the below link i am unable to apply patches on ECC 6.0 system. As is enter Txn:spam is throwing dumps.

http://scn.sap.com/thread/3454034

As we no backup of database on the system. We have File system backup of entire system. Is it possible to restore the system with available FS backup.

Please suggest..

Regards,

Sandeep Singh

[Reagan]

I cannot say whether restoring the file system backup will help as I don't know what is included in the file system backup.

I suggest you to restore the database from a database backup taken before the patching.

Start the database and SAP

Regards

RB

[Former Member]

Hi RB,

We have no database backup, i got stuck while applying the SPAM patch.

Have no other option to restore the FS another option is to rebuild the system

Rds/.

SS

[Reagan]

If this is a production system then I am surprised why you don't have backups for the database.

If this is a test system then restore the production database to the test system and perform the post refresh operations.

Regards

RB

[Former Member]

Hi RB,

This the only box used as IDS by functional team. No other system in our set up.

Rds/-

SS

[Former Member]

Hi Marius,

The database was open during this time, there was no transactions as we are restoring a backup that that took place in weekend(sunday).

Rds/-

SS

[former_member206552]

The file system backup (if the all the files systems was included) is like an offline backup being restore and requires the database to be down,

you can try to restore it and hope it comes up, but the files headers will be diffrent etc.

are you using snapshots ?

http://www.oracle.com/technetwork/articles/systems-hardware-architecture/cloning-db-using-snapshot-v...

[Former Member]

Hi Marius,

Is it possible for DB2 database too ?

Rds/-

SS

[former_member206552]

Hi SS,

yes it is, here is a doc on how to set it up

http://scn.sap.com/docs/DOC-14368

Best Regards

Marius

[former_member188883]

Hi Sandeep ,

First check what is the content of the FS backup taken on weekend.

If it involves all the files systems which is visible using df -k command, then you can attempt to restore the backup.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

We are planning to restore the below FS.

/usr/sap
/usr/sap/SID
/usr/sap/SID/ASCS00
/apps/trans
/usr/sap/SID/DVEBMGS02

/apps/SID

/db2/db2ids

/db2/SID/log_dir

/db2/SID/db2dump

/db2/SID/sapdata1

/db2/SID/sapdata2

/db2/SID/sapdata3

/db2/SID/sapdata4

/db2/SID/sapdata5

/db2/SID/sapdata6

/db2/SID/sapdata7

Rds/-

SS

[former_member188883]

Hi Sandeep,

FS looks ok to be restored.

Additionally do you have any database backup after the date of FS backup ?

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

We have no Database backup except the FS backup as this was IDS system with space constraints we had no backup of the present system.

Rgds/-

SS

[Former Member]

MY OS is RHEL and DB: DB2

Rds,

SS

[former_member206552]

Hi SS,

if the database was open and active during this time, no then you will not be able to use this backup.

for a file system backup to work and be consistent the database needs to be down

Best Regards

Marius