on 08-31-2011 4:23 AM
HI All,
I am new to SAP.As a part of archiving project,we recently archived the entire SAP database using a tool.When we started archiving we stopped the SAP and all the jobs which are running to make sure that all the tables are stagnant.This is due to the fact that once we archive, we do a row count on the Oracle(SAP) and archived tales to make sure every thing is archived.
But unfortunately, As we archiving the oracle database(SAP) got restarted as there was a backup job which ran and restarted the server.Now when we completed the full archiving and did a row count comparision we found that the below tables have different counts from the Oracle(SAP) i.e source.I think that these tables are SAP metadata and when system got restarted due to the back p job, these tables might have been updated.
Please see the list of tables below and let me know whether these tables contain any Data which might e useful to the customer or is it just some metadata used by SAP and nothing else...
DBABARL
DBAML
DBATL
DBSNP
DDLOG
MONI
PAHI
SDBAD
SDBAH
SGOSHIST
SNAP
TBTCO
TBTCP
TSP01
TSP02
TSPEVDEV
TSPEVJOB
TST01
TXMILOGRAW
UTAB
VARI
Thanks in Advance
Hi
I understand that during the archiving, a process started the SAP system. Then, the SAP system was stand online a period of time during your archiving process. Under this circumstance, I strongly assume that the SAP standard good house keeping jobs updated those tables.
You can find the information on the note 16083 - Standard jobs, reorganization jobs.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Please see the list of tables below and let me know whether these tables contain any Data which might e useful to the customer or is it just some metadata used by SAP and nothing else...
Well - you can check the content of the tables in SE11 and SE16. Whether the data is used or not depends on the customizing of the system and the applications/modules used. Whether this is "only" metadata can only be determined by the customer himself.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.