Re: Hot Backups

ngreene_at_locws140049.shl.com (Neil Greene) wrote:

>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.

Actually begin backup freezes the header and the SCN numbers become out of sync. I believe media recovery is pretty painless as it does sync the SCN numbers.

It would be a bug without this functionality... (that is if you want to be sure your database is not corrupt).

>
>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
>Senior Oracle DBA / Unix System Administrator
>SHL Systemhouse, Inc. LA Outsourcing Center
><HREF=mailto:ngreene_at_shl.com>
>--
>Neil Greene
>Senior Oracle DBA / Unix System Administrator
>SHL Systemhouse, Inc. LA Outsourcing Center
><HREF=mailto:ngreene_at_shl.com>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt.

Anon. Received on Mon Jan 08 1996 - 00:00:00 CET