Re: HELP HELP
Date: Fri, 22 Sep 2000 23:14:18 +1000
Message-ID: <39cb4ca6_at_news.iprimus.com.au>
Lord... In the first place, I don't think he particularly wants a clone of his database (since he specifically mentions wanting the structure and not the data -and I take that to mean he wants a recipe for reconstructing the database like an INDEXFILE script).
In the second place, whilst the recommendation to go and look at Oracle's white papers is always sound, what you actually describe is a pretty wishy-washy rag-bag of cloning instructions. It's not that anything you say is particularly wrong, just that it's all oevr the place and doesn't go far enough in some key areas. The full schmozzle is on the Backup and Recovery page of my web site, and I'm sure even it could be improved on (but since it gets tested on every Backup and Recovery course I run, I know it works).
Regards
HJR
-- -------------------------------------------------------------------------- Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000 -------------------------------------------------------------------------- <nwaldie_at_my-deja.com> wrote in message news:8qe2bf$uvk$1_at_nnrp1.deja.com...Received on Fri Sep 22 2000 - 15:14:18 CEST
> 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.