Data Integrity Check

[Former Member]

Hi All,

We have made a copy of our PRD for the purpose of our DR before getting them linked with Dataguard. We have some minor issues but got them resolved. My question is, what are the data integrity check that i can do to make sure the data in DR is same as PRD. I tried checking balances of few GL accounts, some are OK but some are not, since transactions happened after copy in PRD for some accounts changed the data in tables. What's the way guys. Thanks

[Former Member · Accepted solution]

Probably you can check the status of transport requests. If you have list of transport requests which were transported before System copy. Then you can compare them and probably it will give you certain idea.

Thanks and Regards,

Kedar

Edited by: Kedar Malekar on May 29, 2010 9:24 AM