Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: How to CLONE a database.

REPOST: Re: How to CLONE a database.

From: Andrej <andrej611_at_wp.pl>
Date: Sun, 27 Jan 2002 10:15:28 +0100
Message-ID: <0$--$%%%_$%-%%_%_$@news.noc.cabal.int>


Thanks.

The problem is I need to run the instances on THE SAME machine ...

The solution would work if I had a spare server. But I do not.

Użytkownik "Ban Spam" <ban-spam_at_operamail.com> napisał w wiadomości news:Xns91A29C377EF7BSunnySD_at_24.0.3.73...
> "Andrej" <andrej611_at_wp.pl> wrote in
> news:a2vc2m$7ms$1_at_korweta.task.gda.pl:
>
> > Hello,
> >
> > I need to make a runnable copy of production database.
> >
> > I would like to clone a production database. Then I could run a clone
> > of database for development/testing purposes.
> >
> > The perfect way would be just to copy a datafiles and trick control
> > files somehow.
> >
> > The full import/export does not work with my forms application.
> >
> > Please, share your experiences - how to make a perfect runnable copy of
> > an Oracle database ?
> >
> > Platform = Unix (aix), Oracle = 8.1.7.
> >
> > TIA,
> > Andrej
> >
> >
>
> I'm running on Solaris, but this should work for you.
> When my production DB is down for cold backups, I
> launch a script which contains a bunch of "rcp" commands;
> one rcp command for each file in the DB including control
> files. The destination for each file is into the same
> directory location as the production system. After all
> the rcp commands complete, you simply start up both DBs.
>
>
> HTH & YMMV
>
>
> HAND!
>

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 03:15:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US