Re: Recovery FAilure!!!
Date: 1995/06/18
Message-ID: <3s2d17$1qt_at_server.icon-stl.net>#1/1
In article <DADtq2.17D_at_blaze.trentu.ca>,
gmccalman_at_ivory.trentu.ca (Grace McCalman, Box 524, Trent University,
Peterborough, (705)740-2337) wrote:
>Enter message text; type CTRL/Z when done.
>
>Hi there,
>I guess you missed the last notice so I sent it again.
>I have a problem.
>( this e-mail is really being accessed from South America too!!!)
>
>I have a database that is dated Jun 17th. However , the disk with the control
and redo log files crashed and could not be recovered.
>
>So now I have have a database that is more recent than my control and redo
>log files.
You may be SOL. I understand that there are techniques for recreating the control file (I have never used them, but I understand that it is possible). But, if you lost your log files then your stuck. You will have to recreate the database from scratch. A recent full export would be quite useful right about now.
BTW: as a general rule you ALWAYS backip your control file and you should replicate the control file to one or two other disks, if possible. (use the ALTER DATABASE command to add control file duplicates.)
John Kline | .sig under construction jtkline_at_icon-stl.net | Received on Sun Jun 18 1995 - 00:00:00 CEST