Re: create new oracle using copies of dbf files

On Jun 20, 12:06 pm, rich <rschn..._at_nsf.gov> wrote:
> All, I have the dbf files, ctl files, etc... from an old good instance
> of Oracle. Is there a simple way to start up a new instance of oracle
> on a completely new and different platform which would be able to
> access the Trigger PL/SQL code that is in the SYSTEM table space? Can
> I create a new instance that just gets me that pl/sql access. I don't
> care about tables or data at all.
>
> Rich S.

If by "different platform" you mean different hardware or operating system, the answer is no. If you simply mean a new box, then maybe. Steve Howard is likely right, but there are ways out of some of the binds that can tie you down in an fuzzy situation. An experienced DBA might be able to help on site.

In a nutshell, you would act as though you lost the controlfile, and create it (like metalink Note:1014504.6, startup mount, alter database backup controlfile to trace, then edit the resulting controlfile), or if you can't mount or backup to trace or type in a good controlfile manually, recover database using backup controfile until cancel, immediately cancel, then open resetlogs.

It's worth a try, anyways. If you get stuck, ask here, being _very_ specific about what you've done (cut and paste what you see), versions of everything etc.

jg

--
@home.com is bogus.
"I got a 'D' in speech at college, and if I had to speak in public,
I'd be drenched in sweat." - Harvey Levine, inducted into California
bar's Trial Lawyer Hall of Fame