Re: Creating Database instance

Al Williams wrote:

> 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!!

If I understand correctly what you are doing this is no way to create an Oracle instance. At least not functioning one.

Create your Oracle instance from scratch and then import the data.

Daniel A. Morgan Received on Thu Jun 07 2001 - 01:05:48 CDT