on 12-14-2011 9:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
Hi Raghav,
For Undo table management refer link below,
http://docs.oracle.com/cd/B19306_01/server.102/b14196/storage003.htm
Regards,
Deepak Kori
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.