Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Database instance
Just be advised, that although cloning a database in this manner works fine, and is much faster than Daniel A. Morgan's advice to build from scratch and import, it results in a newly name database "B" but the DBID is still the same. If you try to back both of these up from an RMAN catalog, you will have trouble.
Kerry
"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 Fri Jun 08 2001 - 21:17:58 CDT