-
Sync Test DB & Prod DB
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
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Yuck. I'd just restore it from backup or clone in place.
Jeff Hunter
-
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
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
PHP Code:
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.
Jeff Hunter
-
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
-
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
Try rman
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|