Dafydd wrote:
>
> Hello,
>
> I am a UNIX sysadmin who knows very little about Oracle DBA. (It's
> someone else's job.) Recently we had a problem whose solution was to do
> a complete restore from tape, thus losing that day's data. I would like
> to offer the problem to this group to see if a better solution could have
> been found.
>
> Our databases are kept on different drives from the log files and the
> control files. The drive holding the control files failed, was
> replaced, and restored from tape. So, now the control files are "a day
> older" than the rest of the databases. In general terms, how could we
> resynchronize the controls, ie. bring them up to date?
>
> Thanks,
> David
> --
> David Barr | A competent and self-confident person
> dafydd_at_pacbell.net | is incapable of jealously in anything.
> San Jose, CA | Jealousy is invariably a symptom of
> USA | neurotic insecurity. --Lazarus Long
If you were running your database instance in Archivelog mode, you could
have restored the old control files, and recovered the database
(actually the control files) up to the point of failure by using the
'recover database until cancel using backup controlfile' command.
--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Tue Dec 17 1996 - 00:00:00 CST
