Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

data refresh with Oracle 10g data pump

 3 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Duane
Basic Member
Posts: 17
Basic Member
8/12/2009 8:20 PM
    Suddenly our Oracle resources are very thin and we are trying to figure out how to refresh Lawson production data to test. We want to use the Oracle 10g data pump. Any tips or suggestions which may be Lawson specific? We are on 9.0.1 LSF and 9.0.1 Apps. Both test and prod databases are on the same server, along with test and prod environments.  

    Any input would be greatly appreciated.
    Shasidhar Vemireddy
    Basic Member
    Posts: 14
    Basic Member
    8/18/2009 2:38 PM
      Duane,

      I am in the same boat as you. I have lot of DBa here and they recommended not to use Oracle 10g data pump. We were trying to use so that we could obfuscate data from prod to dev/test due to GLBA issues. The data pump in 11g is a much better option.
      Travis Cox
      Basic Member
      Posts: 4
      Basic Member
      9/8/2009 6:52 PM
        We just finished our re-implementation of LSF9.01 (went from 803 to 901 and changed HR and GL structures)

        I used Oracle 10gR2 datapump to refresh the data on the test boxes over 200 times during the life of the project. (still use it, now that we are live, just not quite so often)

        Our db is approx 250GB is size and the datapump finishes in approx 5 hours.

        The 5 hours includes dumping the prod db and copying to the test server, and the datapump import etc. I dump all 3 schemas (gen,logan,prodline).

        I have the whole process scripted and combined with some rsynch stuff to copy all the lawson code, print files, ldap stuff, was stuff to the dev server.

        Happy to share
        Duane
        Basic Member
        Posts: 17
        Basic Member
        9/16/2009 9:44 AM
          Hi Travis - thanks for your feedback. Primarily, the DBA is interested in the Data Pump parameters used just to refresh the prodline data to our test database. I don't think he is using a dump and import strategy, rather a direct link export/import? Does this make sense? If you have time for me to introduce my DBA to you, maybe he can get a few pointers from you? Thanks!