Re: .ORA files -- can one import from them???

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 27 Jan 1999 15:02:47 -0800
Message-ID: <36AF9B17.3FB5A6A1@us.oracle.com>

Brian

If the original database is completely fried, the only approach I know of is to ask Support to do it for you. They have tools that can get the data out, but how useful it will be is another issue. Remember your datafile will have both committed and uncommitted data in it. Realistically speaking, it's far better to determine the cause of the PMON error and fix it.

HTH Pete

"Brian R. Aust" wrote:

> Our Oracle Instance got fried last night, and we keep getting the
> ORA-00472 PMON Process Terminated With Error.
>
> We really need to access the tables in a certain schema of that instance,
> which is held in a file called "pdl.ora".
>
> If I try to link this .ora file in with a different Oracle server, it
> yells that the file isn't part of the database and fails verification
> check.
>
> We cannot start up our original oracle instance -- is there ANY WAY to
> import or otherwise access those data tables in that offline .ORA file in
> another Oracle instance?? With an IMPORT function or something like
> that??
>
> I've tried renaming the datafiles, and I've tried recovering datafiles,
> but if I try to slip in that .ORA file I need, it yells that it fails
> verification.
>
> What should I do??
>
> Thanks much,
> Brian Aust

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Jan 27 1999 - 17:02:47 CST