Sync Test DB & Prod DB

[Ablakios]

Hey Gang,
What's the way and easy way to refresh or synchronize a large production database and Test database.
Export/import will take a long time. Any suggestion?
Thanks

[marist89]

Yuck. I'd just restore it from backup or clone in place.

[Ablakios]

hey jeff
good to get you online. It has been a long time. Any way could you send me the steps in cloning it in place?
Thanks

[marist89]

on local host:
   switch logfile;
   For each tablespace
      put tablespace in backup mode;
      rcp files to remote host;
      end backup mode;
   End;

   switch logfile;
   rcp archived redo logs to remote host;

on remote host:
   recreate controlfile
   recover database until cancel using backup controlfile. 

[KenEwald]

Here's something you might be interested in... I hear this is really good stuff for cloning.

May 6, 2005 - Babboo Software announced that it has launched the first ever FREE version of its award winning technology XClone. Although the free version has certain advanced features disabled, the core features are enabled and free to use and distribute to others. In addition, Babboo has gone one step further and is offering free e-mail support.

babboo.com

[Ablakios]

Jeff
Thanks as always.

[ogehlert]

Hi,

if you are alrweady using rman to backup your database, it get down to this:

On prod:
rman target / auxiliary sys@test
duplicate target database;


Have a look at the rman-docs. Quite helpful and duplicate runs also fine when using netbackup..

HTH

Oliver