Re: control file problems

OK,

I have tested a solution for your problem :

1. su - oracle (Verifiy the $ORACLE_HOME and $ORACLE_SID are OK and $TWO_TASK is not set
2. Copy the control file 1 over 2
3. Copy 1st redo log over the second
4. svrmgrl (in svrmgrl)
5. connect internal
6. startup mount
7. recover database until cancel
8. alter database open resetlogs

This step are working on my system, when I reproduce your failure. Warning I have do a "clean" shutdown before not a shutdown abort.

Hope this help.

Philippe

"Gregory P. Schin" <gps_at_lucent.com> a écrit dans le message news: 385AB700.377BEAD3_at_lucent.com...
> Hi,
>
> I am fairly experienced with Informix but have very little Oracle
> experience. I was recently asked to setup an Oracle database. The
> installation went fine and the system worked fine after the
> installation. I was able to use sqlplus ok.
>
> During the install I placed the control files and redologs on 3
> different disk/file systems. I had to reconfigure the disks and unmount
> /kedata1 and /kedata2 (with oracle off) but then when I rebooted oracle
> turned on automatically (without /kedata2 and /kedata3 mounted).
>
> Now that I have everything back together - the sytem gives me this error
> on a dbstart:
>
> $ dbstart
>
> Oracle Server Manager Release 3.0.4.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
> PL/SQL Release 8.0.4.0.0 - Production
>
> SVRMGR> Connected.
> SVRMGR> ORACLE instance started.
> Total System Global Area 4847808 bytes
> Fixed Size 47296 bytes
> Variable Size 4317184 bytes
> Database Buffers 409600 bytes
> Redo Buffers 73728 bytes
> ORA-00214: controlfile '/kedata1/oradata/A/control01.ctl' version 746
> inconsistent with file '/kedata2/oradata/A/control02.ctl' version 726
> SVRMGR>
> Server Manager complete.
>
> Database "A" warm started.
>
> I tried copying /kedata1/oradata/A/control01.ctl over
> /kedata2/oradata/A/control02.ctl and then I get an error about the
> redologs.
>
> What is the easiest way - short of re-installing to fix this?
>
> $ ls -l /kedata?/oradata/A
> /kedata1/oradata/A:
> total 253968
> -rw-r----- 1 oracle dba 1431552 Dec 16 15:46 control01.ctl
> -rw-r----- 1 oracle dba 15730688 Dec 15 16:49 rbs01.dbf
> -rw-r----- 1 oracle dba 512512 Dec 16 15:46 redoA01.log
> -rw-r----- 1 oracle dba 83888128 Dec 15 16:49 system01.dbf
> -rw-r----- 1 oracle dba 1050624 Dec 15 16:49 temp01.dbf
> -rw-r----- 1 oracle dba 26216448 Dec 15 16:49 tools01.dbf
> -rw-r----- 1 oracle dba 1050624 Dec 15 16:49 users01.dbf
>
> /kedata2/oradata/A:
> total 3844
> -rw-r----- 1 oracle dba 1431552 Dec 16 15:41 control02.ctl
> -rw-r----- 1 oracle dba 512512 Dec 16 15:41 redoA02.log
>
> /kedata3/oradata/A:
> total 3840
> -rw-r----- 1 oracle dba 1431552 Dec 8 14:25 control03.ctl
> -rw-r----- 1 oracle dba 512512 Dec 15 13:57 redoA03.log
>
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Sat Dec 18 1999 - 04:28:48 CST