H/W Architecture : SPARCH
OS : HP UX
Oracle DB : 11gR2 Enterprise Edtion
We are planning to implement the DR for 10 SAP Servers using Oracle Golden Gate over different h/w and OS platform. Size of each database is more than 80GB.
1. Performing initial load using the OGG process will not be suitable, as migrating data and online changes simultaneously over large distance doesn't seems to be the feasible solution.
2. Another way is to get the total export of the SAP System and import the same at remote location. This is again not feasible as it would incur the downtime.
3. I am not yet aware of SAP installation, but quite sure that installation create it own schema "sapsr3" with its default data. Here again if I install oracle separately will i be able to achieve purpose.
Can you please suggest an alternative process to sync the databases initially without any downtime. And also put some focus on SAP System with Oracle Golden Gate.
Thnks & Rgds,
I think you've made a mistake at the top of your post. It is impossible to run HP-UK on SPARC...
Your options for the initial population as far as I see it are:
1) Let GG do it.
3) Database duplication.
I would suggest option 3 would be the quickest.
I can't give you specific details about SAP and GG because I don't work with either.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 0 guests