Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle8i reinstallation

Re: Oracle8i reinstallation

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 26 Sep 2001 02:37:08 -0700
Message-ID: <a20d28ee.0109260137.1d81aa19@posting.google.com>

Paul Drake <paled_at_home.com> wrote in message news:<3BB173C4.35B8338E_at_home.com>...
> "K. C." wrote:
> >
> > I've installed Oracle8i on WinNT running Microsoft cluster. The
> > database engine itself is located on the local drive of the server and
> > the datafiles, control files...etc are located on the SAN. Due to
> > some reason, I have to reinstall the database engine. I've backed up
> > all the datafiles, control files...etc. My question is, after I
> > reinstalled the database engine, can I simply restore all the
> > datafiles and control files to the original locations and then create
> > tablespaces that point to these datafiles? For example, right now I
> > have a tablespace called TS_1 and the datafile is G:\ORACLE\TS_1.DAT.
> > After I reinstalled the database, can I create TS_1 in the new
> > database and point it to G:\ORACLE\TS_1.DAT again? If not, what is
> > the easiet way to restore everything?
> >
> > Please help. Thanks in advance.
> >
> > KC
>
> KC,
>
> If you've ever glanced at Cary Milsap's OFA paper (you can find it at
> OraPub)
> the purpose of having Oracle Binaries on a separate mount point (or
> directory)
> e.g. %ORACLE_BASE%=D:\Oracle,
> %ORACLE_HOME0%=D:\Oracle\Ora73
> %ORACLE_HOME1%=D:\Oracle\Ora81
> %ORACLE_HOME2%=D:\Oracle\Ora90
> from the database configuration files
> %ORACLE_BASE%\Admin\<db_name>
> and from the data files
> <drive>\Oradata\<db_name>
>
> is so that you can change the binaries completely separately from the
> datafiles and configuration files.
>
> As Sybrand mentioned, once you have re-installed the binaries, provided
> that all files are in their previous locations, including:
>
> file type file name path
> password pwd%ORACLE_SID%.ora %ORACLE_HOME%\Database
> initialization init%ORACLE_SID%.ora %ORACLE_BASE%\Admin\pfile\
> control control01.ctl, etc. <drive>\Oradata\<db_name>
> log & data <tablespace_name>nn.dbf <drive>\Oradata\<db_name>
>
> by re-creating the service, e.g.
>
> C:\> oradim - NEW -SID %ORACLE_SID% -INTPWD mygnupword - STARTMODE a
> -PFILE D:\Oracle\Admin\<db_name>\pfile\init%ORACLE_SID%.ora
>
> and re-creating the listener service
>
> C:\> lsnrctl start listener
>
> your should be able to start the instance without manual recovery.
>
> hth,
>
> Paul

Paul,

I don't know whether you should give everything away. After all, this is a perfect question for an OCP-exam!

Lol,

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 26 2001 - 04:37:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US