Re: How to CLONE a database.

"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 Sat Jan 26 2002 - 17:21:25 CST