Re: How to restore a controlfile ?

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Tue, 12 Jan 1999 14:13:38 +0000
Message-ID: <369B5892.E09A13EF@capgemini.co.uk>

You appear to have two control files (check your init<SID>.ora) copy the good one (SYS1ORCL.ORA) to the damaged one (CTL1ORCL.ORA) while the database is shutdown - then startup the database

Regards

Alex

Xavier Gabalda wrote:

> Hi.
>
> I have I database with a damaged controlfile, so, I want to substitute it
> with a correct one.
>
> I have restored a good one from a backup tool ( not an oracle tool ).
>
> Then, I have copied CTL1ORCL.ORA to its correct location.
>
> When l open the database ( alter database "orcl" open ), I see the error
> 'ORA-01207' ( oracle detects an older version of CTL1ORCL.ORA file respect
> to 'SYS1ORCL.ORA file ).
>
> How can avoid this error. Must I to restore 'SYS1ORCL.ORA' file. ?
>
> Must I restore another files ?
>
> Thank you.
Received on Tue Jan 12 1999 - 08:13:38 CST