Re: recovery question

From: Joel Garry <joel-garry_at_home.com>
Date: 18 Feb 2003 14:41:08 -0800
Message-ID: <91884734.0302181441.4cd47429@posting.google.com>

"Ronald" <journey_at_rockdog.demon.nl> wrote in message news:<LPr4a.400$54.6491_at_news1.nokia.com>...
> I have deleted oracle816 instance, i though backup was succesful before
> deleting it.
>
> Now it's been upgraded to 817 and instance has been recreated but export
> file is too old. I do have copies of all
> datafiles and archive files of most recent situation in old 816 instance. Is
> there a way of recovering this data into the 817 instance ?
>
> Thanks
>
> Ronald

This is kind of worrisome, did you really have to recreate the instance for a minor point upgrade? See the Oracle Migration Guide for instructions on manually upgrading/downgrading the database, it's just a SQL script like $ORACLE_HOME/rdbms/admin/c0801060.sql. Did you change the locations of the datafiles? Do you have the controlfiles?

--
@home.com is bogus.
Just <a href="http://www.pseudodictionary.com/bloogle">bloogling</a>
through the drog.

Received on Tue Feb 18 2003 - 16:41:08 CST