Re: Copy of an Oracle db

"versicolor" <versi_at_cyberjunkie.dk> wrote in message news:3c6cd066$0$89094$edfadb0f_at_dspool01.news.tele.dk...
> Hi ppl.
> Is there anyone who can tell me how i make a copy of an oracle DB ??
> Im going to upgrade a DB but whant a copy i can use while im upgrading the
> one i got, or to use if something goes terrible wrong.

You've already got these HC answers.
They're correct but were you able to follow them?

-It is quite simply, really.
In this example I assume that you have made the Oracle installation in normal (suggested) directories.

1. You just run down your database, from the 'services' for example.
2. Copy the following directory structures to another place: C:\oracle\admin\ORCL (pfile (Init.ora) etc. ) C:\oracle\ora81\network\ADMIN (Listener & sqlnet configuration) C:\oracle\ora81\database (Password file) C:\oracle\oradata\ORCL (The actual database files - BIG)

That's it.

I do it all the time. This is THE MOST effective way of doing backup & thansfer etc.

Just remember that you CANNOT easily copy database files to another version of Oracle. Like from 8.1.6. to 8.1.7. (You get internal errors everywhere, it takes long time & a lot of knowledge to fix that.)

Regards,
 Pasi Parkkonen,
 EigenDBA Received on Wed Feb 20 2002 - 13:04:36 CET