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

On 22 May 2003 11:50:40 -0700, zzesers2002_at_yahoo.com (Zzesers) wrote:

>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

I don't think this is a documented procedure. As at least in Oracle 8, the version number is included in the header of most files, and that might still apply to Oracle 9, you are, without using the published migration procedure, very likely to create havoc and turn your database into something unsupported. Which might not be a problem for you of course, because you don't have a support contract, or don't mind changing job.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 22 2003 - 15:15:57 CDT