Re: sync of control files

From: Pat Minnis <pminnis_at_indianaonline.net>
Date: 2000/02/06
Message-ID: <Vdqn4.291$cN1.24721@news.goodnet.com>#1/1

Shutdown the database
Make a backup copy of all your control files Copy '/db0/dbs/ctrl1dbs1.ctl' to replace '/home/oracle/dbs/ctrl2dbs2.ctl' and any other control files on your restored filesystem. Try to startup the database.

"chad" <chadopp_at_pacbell.net> wrote in message news:389E1EF5.162C9DC7_at_pacbell.net...
> Hi,
>
> We are running Solaris 2.5.1 with Oracle7. Our oracle
> has a dedicated raid disk. I did a complete restore of
> our solaris system boot disk. Now when I attempt to
> start oracle I get an ORA-00214: control file
> '/db0/dbs/ctrl1dbs1.ctl' version 3237 inconsistent with
> file '/home/oracle/dbs/ctrl2dbs2.ctl'. /home is part of
> the unix file system that I restored. /db0 is the
> dedicated raid that oracle runs on. I compared these 2
> files and the time stamp is different. How do I sync
> these up? I have several control files with the same
> error. I know that when it was running properly these
> files always had the same time stamp. What is the best
> way to solve this problem.
>
> Thanks for any help.
>
Received on Sun Feb 06 2000 - 00:00:00 CST