Re: Creating Database instance

Don't forget to change the paths to the new datafiles too, otherwise you will end up with A and B attempting to share the same files (which wont work out
for each!).

I usually change the Controlfile line to :-

CREATE CONTROLFILE REUSE SET DATABASE "BAGPUSS" RESETLOGS NOARCHIVELOG And remove the 'recover database' line too.

And take backups first please.

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3b1f3cff$1_at_news.iprimus.com.au...
> Not entirely certain you know precisely what you are doing, but I'll give
 it
> a whirl, on the grounds that it may be just my misunderstanding of what
 you
> write...
>
> 1. I think you've shutdown database A and copied all datafiles and redo
> logs to machine B
> 2. You've copied the initA.ora and edited it to be an initB.ora
> 3. You now want to clone the controlfile from A to B.
>
> If so, then in A, issue the command 'alter database backup controlfile to
> trace'. Find your A's background_dump_dest, and in there will be the
> resulting trace file. Find it, and transfer it to machine B.
>
> Now on machine B, edit the tracefile. Strip out the rubbish at the top so
> that the first line reads 'startup nomount'.
> Now add a line that reads 'connect / as sysdba' (or however you ordinarily
> connect as a privileged User)
> Then add to the 'startup nomount' line the words 'pfile=<path and filename
> of the initB.ora>
>
> Fire up Server Manager (or SQLPlus if you insist). Then type
> @nameoftracefilehere.
>
> That should cause the trace script to run, create the required
 controlfiles
> wherever initB.ora is requesting them, and open the database.
>
> If all that fails, you may want to re-think how you clone a database, and
 I
> can help you with that if you mail me.
>
> Regards
> HJR
> --
> =============================!!=============================
> The views expressed are my own only, and definitely NOT those of Oracle
> Corporation
> =============================!!=============================
>
>
> "Al Williams" <awillia_at_uvi.edu> wrote in message
> news:3B1E95B8.FB9C2B0B_at_uvi.edu...
> > Hello All,
> >
> > I am now setting up a second database instance (B) from a
> > preliminary instance (A) using Oracle 8i enterprise on AIX 4. 3.
> > 3.
> > I have copied the data to new file systems (from /A/dbs1 ...
> > /A/db10 to /B/dbs1 .. /B/dbs10). I have also established the 'B'
> > instance parameters in /usr/lbin/setsid as well as the
> > /$ORACLE_HOME/dbs/initB.ora, and the /$ORACLE_HOME/admin/B/*dump
> > files. I am now ready to rebuild the control files to initialize
> > the 'B' instance.
> > I know that new control files should be built using the original
> > instance 'A'. What sql commands must I run to accomplish this.
> > Can any one share some notes or possibly a sql script that I can
> > use.
> >
> > Also, another note, where are the archives for this group kept?
> >
> > Give Thanks!!
> >
>
>
Received on Thu Jun 14 2001 - 17:28:21 CDT