Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to restore a controlfile ?
Then I think you will have to restore the entire database and recover it from
archive logs (you do have archiving on???) unless anyone knows a differant way
(?).
Alex
Xavier Gabalda wrote:
> Hi.
>
> I would like it !.
> I dont have two controlfiles in the database. I only have one. I have a good
> version of it in the restored backup of last week.
>
> Thankt you. Alex.
>
> Alex Hudghton escribió en mensaje <369B5892.E09A13EF_at_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
> >
Received on Tue Jan 12 1999 - 10:33:53 CST