Re: How to restore a controlfile ?

Hi,

check your initsid.ora file and the first file in that CONTROL_FILES parameters
would be used for the reading though it writes to all files.

so the first entry should be correct with location and path.

then restart the instance

vimal.

Xavier Gabalda <xgabalda_at_vincle.es> wrote in article <77ff4v$jf6$1_at_diana.bcn.ibernet.es>...
> 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:52:07 CST