Re: HELP HELP

[Quoted] A good starting point is to execute sql command "alter system backup controlfile to trace. The sql file it builds is useful in opening the new data base after you have copied the files. It is easy to identify all of the files to copy: Select name from v$datafile; select name from v$controlfile; select member from v$logfile; Then too you will want an init<sid>.ora parameter file. You might look up the white paper on copying a database on Oracle's website. There is a little editing of the trace file to make it work on the new environment. You probably want to rename the instance and the directory paths are likely to be different. THe init<sid>.ora file needs to correctly point to the controlfiles whereever you move them to, and it must correctly identify the db_name. The executable files are probably under $ORACLE_HOME depending on whether you have a standard OFA installation.

questions, comments, & corrections welcome -Norm

In article <dkvy5.4273$vZ.261252_at_news20.bellglobal.com>,   "Simon" <simonmailly_at_sympatico.ca> wrote:
> how can i copy the entire workspace of machine. i want to grab the
> workspace of a machine and recreate this one on another machine. is i
> possible to generate a script to make this. How can i make . i dont
> necesarly want the date but i want all the structure
>
> je dois donc reproduire un environnement sur
> notre serveur Oracle. Il fait aller chercher l'environnement sur un
 serveur
> par PcAnuwhere et le ramener ici. Peux-tu m'aider?
>
> please send response to simonmailly_at_sympatico.ca
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CEST