Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Unanswered: Selective Data Copy Advice Needed

    I have an oracle 9 db. I need to take a point in time copy to a new location and leave the original db running and in service for insert/update. At some later time I want to find out what has changed on the original db and export that data to the point in time copy. All of my tables/fields do not have time stamps. How can I do this?

    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Is the existing V9 DB running in archived mode?

    >At some later time I want to find out what has changed on the original db and export that data to the point in time copy.

    What occurs to the clone copy between now & "later"? DML?

    In wall clock time, quantify "later".
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2009
    Posts
    2

    answer to questions

    The existing v9 db is log shipping to a stand by db. I will setting up a new physical machine and want to move a point in time copy over for testing the application, this part is easy. After testing, I need to get the data over from the original db where transactions have continued, but I only want to bring over the delta since the point in time copy.

    As for how elapsed time, approximately 6 hours will have elapsed and a lot of records will have been updated or inserted. Not sure what a lot is, maybe a few hundred.

    thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    If you take a hot backup to clone onto new system, then you could do desired testing.
    After testing has been completed, start over & restore from hot backup again & then apply redo logs generated while testing was under way.

    With free advice you get what you paid for it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •