Re: open with migrate??

From: nirav <shivam71_at_gmail.com>
Date: 13 Dec 2005 07:00:40 -0800
Message-ID: <1134486040.043423.126040@f14g2000cwb.googlegroups.com>

What I feel is that:

It is needed to determine what was the exact version of the database before the crash.

To get this info. , apart from asking the people, you should look in the alert log file.

for example, my log file has the entry:

"Starting up ORACLE RDBMS Version: 9.2.0.6.0."
It also has the date and time info like
"Tue Jun 14 18:07:45 2005" for all database startup and shutdowns..so
look for the date BEFORE the crash and check for version.

That will give you the target version and then you need to get your oracle software upgraded to that version. (You need to download the patch for that , or you may have it from last admin)

also as a reference , see oracle migration guide at : http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm

N. Received on Tue Dec 13 2005 - 09:00:40 CST