Re: Why is a backup of the controlfiles needed

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 26 Aug 2004 15:41:28 GMT
Message-ID: <IwnXc.12482$S35.9178@newssvr29.news.prodigy.com>

Rene Nyffenegger wrote:

> In article <xfnXc.12475$1Y4.7457_at_newssvr29.news.prodigy.com>, Mark Bole wrote:
>

>>Albert Albani wrote:
>>
>>
>>>I don't understand why backups of controlfiles are needed in an
>>>archivelog hotbackuped environment. The controlfiles should be multiplexed,
>>>so if one failes, there is always a good one around that can be copied.
>>>
>>>Is there a scenario in which a backup of a controlfile is truly needed?
>>>
>>>Thanks
>>>Albert
>>
>>They may be multiplexed, but they're still all on the same server. What 
>>if your server dies?

>
>
>
> Then again, the online redo logs are on the same server as well. And I'd think
> it would be disasterous, if they were gone forever, if my server (hw) died.
>
> Rene
>
>

Actually, you are not supposed to ever back up your on-line redo logs. In an incomplete recovery situation (server crash) you would open your database resetlogs on the new server.

--Mark Bole Received on Thu Aug 26 2004 - 10:41:28 CDT