Re: Hot Backups
Date: 1996/01/08
Message-ID: <4crsvp$spq_at_slider.bme.ri.ccf.org>#1/1
In article <ngreene.820922498_at_houws001.shl.com>, ngreene_at_locws140049.shl.com (Neil Greene) says:
>
>Jon Goldberg <jgoldberg_at_dbintellect.com> writes:
>
>>Hi,
>> Has anyone experenced the following:
>>While running hot backups with a tablespace in begin backup mode had
>>Oracle crash or shutdown in abort mode?!? When Oracle comes back up it
>>requires Media Recovery. To me this is a BUG. Oracle does not have that
>>documented. Why should Oracle care since all begin backup does is put a
>>rom in the v$ tables and a marker in the redo log.
>
>Ummmm, not sure about that. I think I remember reading in the Admin book that
>media recovery may be required just in this case. But, when you perform the
>media recovery, you will realize that things are pretty quick and/or fairly
>automatic. I have tested just this case several times and if I remember
>correctly, I think I recall someone from Oracle telling me that this type of
>media recovery only updates the file headers. Could someone elaborate?
>--
>Neil Greene
We've encountered this problem on our OpenVMS platform several times. Any more, I just perform a media recovery on the entire database and in a matter of a few seconds it's done and the database is O.K. Seems by the speed of the recovery that just some header information somewhere might be getting reset?
------------------------------------+------------------------------------ Doug Halke | I may not know much about art, halked_at_cesmtp.ccf.org | but I know what I like! ------------------------------------+------------------------------------CCF and I don't speak for each other.
Received on Mon Jan 08 1996 - 00:00:00 CET