Re: Oracle8i reinstallation

"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 Received on Wed Sep 26 2001 - 01:21:14 CDT