Re: How to CLONE a database.

look at

http://asktom.oracle.com/pls/ask/f?p=4950:8:316588::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:575623107841,%7Bclone%7D

everything should be explained there

"Andrej" <andrej611_at_wp.pl> schrieb im Newsbeitrag news:a30gfj$h5o$1_at_korweta.task.gda.pl...
> 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!
> >
>
>
Received on Sun Jan 27 2002 - 03:39:03 CST