Data recovery from BSIS and BSAS tables

[Former Member]

Hi all,

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

How do I recover this data in SAP?

Please help!!!

Thanks,

Raghav

[stefan_koehler]

Hello Raghav,

two possibilities without a complete restore (in a standard SAP environment):

1) Flashback Query (but it only works if your UNDO tablespace still contains all the data - parameter undo_retention):

http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_flashback.htm#ADFNS01003

2) LogMiner

http://docs.oracle.com/cd/E11882_01/server.112/e22490/logminer.htm#i1005553

Regards

Stefan

[Former Member]

Stefan,

Thanks for ur reply...

anything we can do from SAP side?

As these tables are not archieved...

[stefan_koehler]

Hello Raghav,

i am not pretty sure, if the SAP schema user has the needed privileges for all that tasks.

You should do it in SQL*Plus on Oracle level.

Regards

Stefan

[Former Member]

Here two blogs with real life examples:

[Get me my data back! QUICK!|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/6494] [original link is broken] [original link is broken];

[How to get those accidentally deleted rows back (on Oracle)|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/9379] [original link is broken] [original link is broken];

Another way is to restore a backup of your prod system on another server, for example the qas system.

Cheers Michael

[former_member188883]

Hi Raghvendra,

Which SAP system of your landscape has got this problem > DEV/QAS/PRD ?

In case its QAS , best option is to restore production system backup on QAS

Another option to get contents of these tables is to use table export and import functionality available in database.

Recovery of table contents using abap code would not be feasible as these tables have links with other SAP tables which abap program will not be able to handle it.

Hope this is useful.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thanks for your reply!!!

Its in PRD...

Are there any BAPIs? and have a question that UNDO space is something that it holds the data any DML operations are performed.

I just wanted to know that how long the data is held in that UNDO space?

How is this UNDO space is reserved...

Thanks,

Raghav

[former_member188883]

Hi Raghav,

For Undo table management refer link below,

http://docs.oracle.com/cd/B19306_01/server.102/b14196/storage003.htm

Regards,

Deepak Kori

[stefan_koehler]

Hello Raghav,

the retention is controlled by the init parameter undo_retention.

In addition to that parameter the automatic undo algorithm depends on some other settings (AUTOEXTEND TBS and so on). The full algorithm is described in metalinknote #413732.1.

Regards

Stefan