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

Home -> Community -> Usenet -> c.d.o.server -> Re: Restore 8i Database to 9i using only the oradata ctl, dbf etc. files

Re: Restore 8i Database to 9i using only the oradata ctl, dbf etc. files

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 22 May 2003 16:07:29 -0500
Message-ID: <qseqcv4pnf7st688mobuf47fl3dniuosqj@4ax.com>

IIRC,the header information in 9i is very different from 8, I doubt that any attempt to directly use the datafiles, etc from the 8 would work...

"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote:

>hi from Paris
>
>if you have all the data files (including system), and eventually a control
>file, then you can do what I typically call like a direct upgrade: driving a
>8i database to 9i release....
>
>
>RTFM: Oracle 9i Migration
>
>
>
>
>
>"Zzesers" <zzesers2002_at_yahoo.com> a écrit dans le message de
>news:99584c0b.0305221050.43f527a5_at_posting.google.com...
>> Is there anyway to restore an 8i Oracle Database instance to a 9i
>> server using only the files located in the oradata directory (i.e., no
>> db dump or back is available)?
>>
>> If so, can someone point me in the right direction. I know if I
>> reinstalled an 8i instance, I could potentially warm start the
>> instance by putting all the files in the correct place, can I skip
>> that step and restore directly to 9i?
>>
>> Any help would be greatly appreciated.
>>
>> Thanks,
>> Patrick
>
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 22 2003 - 16:07:29 CDT

Original text of this message

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