Records in the tables BSIS and BSAS are deleted.How to recover?

[Former Member]

Hi all,

The records in the tables BSIS and BSAS are deleted due to adhoc circumstances in PRD.

How do I recover this data in SAP?

<< Moderator message - The answers in the forum are provided by volunteers. Please do not ask for help "urgently". >>

Please help!!!

Thanks,

Raghav

Edited by: Rob Burbank on Dec 14, 2011 9:49 AM

[madhu_vadlamani]

Hi Raghav,

Basis people will take back up either daily or weekly depend on the business. It can be file backup or the whole. Check with basis team.

Regards,

Madhu.

[Former Member]

Hi,

Retrive those records from backup.So,better u contact basis people.

RTVDLTRCD FROMFILE(xxx) TOFILELIB(yyy) - This Command is used to retrive the deleted records.

This would extract the deleted records in the FROMFILE and write them to the same named file in the library specified for TOFILELIB.

When a record is deleted in a data base file, the data values still exist, but the system places a special hex value in front of the record specifying that it is deleted. The Operating System prevents any access to a deleted record thru its normal interfaces.

[Former Member]

Hi Raghavendra,

Contact Basis guys and tell this information. They solve this issue by backup the previous day data

.This is the only choice you have.

[Former Member]

These tables are not archieved......any other solutions???

[Former Member]

Archiving of tables and database backups are very different concepts, not related to each other.

As already has been suggested, contact your SAP basis admin and your Oracle admin.

Let them try the suggestions you got in your Oracle thread:

[Former Member]

I think you should contact SAP. It will likely be a consulting issue, but they may be able to recreate the data from BSEG.

Rob