Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Database instance
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...
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...Received on Thu Jun 07 2001 - 03:35:39 CDT
> 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!!
>