Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2011
    Posts
    2

    Unanswered: Setting up a training system (revert changes daily)

    We want to setup a training system, for one of our applications, which has the backend database as Oracle 10g. At the end of each day, we want to revert back all the changes that were done that day, so that system is brought back to its original form, for the training, next day. I looked through the option of Flashback, but was wondering if there is an easier and quicker method of doing this.

    Thanks,
    Juwin

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Realize that dbca simply does an RMAN restoration to "create" the starter database.
    Without testing various alternative, I can't predict which would be faster or fastest.
    Is speed or duration really an issue.
    If a script was 100% reliable but took 12 hours, why would that be a problem?
    If the script were launched at 6PM would have the DB ready for use the next day.
    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
    Feb 2011
    Posts
    2

    Looking for something like EWF in Windows XPE

    Windows XPE has a really cool feature, Enhanced Write Filter (EWF), which creates an overlay over the disk (if using RAM option), which doesn't allow commit onto the disk, so that the data on disk is not changed. So, everytime you restart the system, you are back to what you had setup earlier. This allows testers to do whatever they want on the system, without fear of loosing the system.

    I was hoping to find something like that in Oracle, which will make the changes to be stored in a different space (may be a different file), which can just be deleted at the end of day, so that the day's changes are wiped out. Ofcourse no table structure changes may be done during the day.

    Thanks,
    Juwin

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Ofcourse no table structure changes may be done during the day.
    Only use GLOBAL TEMPORARY TABLEs
    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.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    If you have an enterprise license "FLASHBACK DATABASE" is probably the quickest way to do this.

  6. #6
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    I would consider VMWARE

Posting Permissions

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