Refreshing Dev Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Refreshing Dev Database

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Refreshing Dev Database

    Hi,
    What is the best way to refresh the Development database from the production database (24/7). No downtime is accepted.

  2. #2
    Join Date
    May 2001
    Posts
    736
    How about setting up a replication

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You must be having a hotbackup somehwere..just restore it..simplest way to do this thing

    regards
    Hrishy

  4. #4
    Join Date
    Sep 2002
    Posts
    376
    Archives can be applied to new database ???

  5. #5
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Indeed they can.

    You don't mention RMAN so I assume you're not using it? If so, see this .

    If you do use RMAN to backup, then see

    this

  6. #6
    Join Date
    Sep 2003
    Posts
    19
    How big is the production database? If you have space for placing export dump files , export import should help or else restore from hot backup and apply archives.
    Preeti

  7. #7
    Join Date
    Sep 2002
    Posts
    376
    hacketta1,

    Thx for the links..
    Is the same thing applies, if i am creating d/b on different machine ???

    Preeti,
    The data is huge...more than 50gb. Exp/Imp is ruled out.

  8. #8
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    You're not using RMAN for this right?

    Yes, it's still the same, except you'll obviously have to copy your hotbackup, init.ora, archive logs etc. from one host to another. If the other host has a different directory structure then no problems here; you just edit the create controlfile script so the path for each file reflects the new directory.

Posting Permissions

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



Click Here to Expand Forum to Full Width