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

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

Re: Oracle8i reinstallation

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 26 Sep 2001 05:49:52 +0200
Message-ID: <tr2mi45vo447d8@news.demon.nl>

"K. C." <the_ada_at_hotmail.com> wrote in message news:be879ba7.0109251657.50a3f343_at_posting.google.com...
> 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

If you reinstall without creating a database, and you simply recreate the instance using oradim, you won't need to restore *any* database file, providing you still have sitting the correct controlfiles at their correct locations.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 25 2001 - 22:49:52 CDT

Original text of this message

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