Re: Need help copying one oracle instance into another in Unix

Is the clone going to be on a different Unix server?

If so and if the different Unix server is the same version of Unix , then you could just do a 'cold backup recover' . This is just copying (while the database is shutdown) all datafiles (tablespace files, redo logs, control files, init.ora) from the current machine to the new machine. You could use the same SID too. You might need to rename tablespace files and redo logs.

But, if the clone is going to be on the same Unix server, you will need to rename the SID (db_name) and datafiles. You would still need to copy all the datafiles to a new location, but you also need to rename the SID / database to a new name. Unfortunately, this information is stored in the controlfile and you will have to recreate the controlfile. You would also need to rename all datafiles and redo logs. Also, the controlfile locations need to be modified in the init.ora. There are really good instructions in Metalink. I cannot remember all the steps.

Also, if the clone is going to be on the same Unix server, you could just export/import the database into a new 'empty' database. You would have to create all the tablespaces before attempting the import or you will probably destroy your current database :) . This option will be probably a lot more work because there will undoubtedly be import errors for something ... invalid views, plsql, etc. .

"Jeff Holakowski" <jholakowski_at_nielsenco.com> wrote in message news:7493f3fd.0206100703.280af8f0_at_posting.google.com...
> I'm a bit new to Oracle and Unix and have limited experience working
> with both. I have multiple Oracle (8.1.6) database instances running
> on the same HPUX 11.0 server and I would like to get all of the data
> from one instance cloned to another. Can someone help me with the
> simplest way to accomplish this? Any help at all would be appreciated.
Received on Wed Jun 12 2002 - 07:03:00 CEST