Re: Question about OLD system

From: Pete's (empete2000_at_yahoo.com)
Date: 08/26/04 

Date: 26 Aug 2004 06:09:23 -0700

Lee Johnson <holeejo@bellsouth.net> wrote in message news:<Xns9550A6DD1FE28holeejobellsouthnet@216.77.188.18>...
> Gang,
> A friend has a Sparcstation 20 running SunOS 4.1.3 and some version of
> Oracle. One of his drives crashed and we finally found a drive to replace
> it with. After restoring his dump backup when it boots we get the
> following message from Oracle:
>
> ORA-00214: control file '/pf/oracle/dbs/ctrl2owgc3d1.ctl' version 2285
> inconsistant with file '/pe/oracle/dbs/ctrl1owgc3d1.ctl' version 2166
> attempting to shut down instance ..... Oracle instance shut down.
>
> Partition /pe is on the replaced drive while /pf is not. What do I do???
>
> Thanks
> holeejo@bellsouth.net

You never mentioned what version of Oracle it was. Based on the
version of the OS, I assume that you're on v6 or v7. If so, I'm not
sure of what the exact steps would be. Were any of the datafiles on
the same filesystem as the controlfile? Do you have all of the
archive files from when the system crashed. Was the database in
archive log mode? If yes to the archive questions, then you should be
able to do the following:

1. startup mount
2. recover database automatic

Oracle should start asking where the archive files are, i.e. specific
archive files. You should be able to answer: auto, yes, no or
cancel. Once finished applying archives, you should do the following:

1. shutdown immediate
2. startup

HTH,
Pete's

Relevant Pages