Skip to Content
0
Nov 22, 2010 at 10:59 AM

BI Refresh of QAS from PRD for an MCOD Database

46 Views

Hi All,

We are currently trying to refesh our BI QAS system with a copy from BI PRD.

Our environment is as follows:

BI DEV - BI 7, Windows 2003 x64, Oracle 10.2

BI QAS - BI 7, Windows 2003 x64, Oracle RAC 10.2

BI PRD - BI 7, Windows 2003 x64, Oracle RAC 10.2

Our Oracle RAC databases are MCOD and also contain Solution Manager, ECC6 and SRM.

We want to refresh the BI QAS with a copy of BI PRD, I have run a client Copy Export (scc8) with option sap_all and imported this into BI QAS (we have to use this mentod as the remote Client Copy will not work due to geopgraphical locations and network performance), the import works fine and the post processing via scc7 has all completed sucessfully, but the cubes etc and data do not change.

I have seen in messages in Forums etc that the only alternative is to use a System Copy but this is not really an option as we do not want to re-fresh all of Solution Manager, SRM, ECC and BI by refreshing our MCOD database.

Any options/ideas would be greatly appreciated.

Thanks

Simon.