Re: Restoring & recovering in NOARCHIVELOG

On Fri, 25 Jul 2003 23:58:13 GMT, Jim Kennedy <kennedy- down_with_spammers_at_no_spam.comcast.net> wrote:

>
> "Quarkman" <quarkman_at_myrealbox.com> wrote in message
> news:oprsvxhqmhr9lm4d_at_haydn...
>> On Fri, 25 Jul 2003 14:35:45 GMT, Jim Kennedy <kennedy-
>> down_with_spammers_at_no_spam.comcast.net> wrote:
>>
>> > While this is true why not just put the thing in archive log mode. It
> is
>> > easier than doing all this.(posting on the group etc.)
>> > Jim
>> >
>>
>> Because not everybody can, or needs to, invest in the performance
>> problems
>> and disk resources which are associated with being in archivelog mode.
>>
>> If the database has the capacity to be completely recovered even when
>> not
>> in archivelog mode (which it does) then people should know about that so
>> they can make informed choices.
>>
>> But if the point is 'if your data is so valuable that you want to be
>> able
>> to completely recover it under all hardware failure circumstances, why
>> not
>> be in archivelog mode?', then I agree. It's the only *guaranteed* way of
>> doing it.
>>
>> ~QM
>
> Oh come on. Disk drives are cheap

Depends on your disk drives. The canard that disk space is cheap is just that: a lie.

> and if the data is worth less than the
> disk drives why back it up? I don't have performance issues with keeping
> all my databases in archivelog mode.

Then you are lucky. You have to re-think your online redo log placement so that archiver is not reading from the same disk as LGWR is writing to. You have to worry about LGWR hanging because ARCH can't write the next redo log... There are many performance issues that need to be considered. Can they not be solved?? Of course they can. Would you be an idiot to pretend they don't exist as issues? Yup.

> Remember keeping the database
> available when needed is part of performance and if it is down (when
> needed)
> then performance is 0.

Entirely agree. Which is why it's impportant to know that you can restore one file and recover it from the online logs, even though you're not in archivelog mode, and not have to restore the entire database.

~QM Received on Sat Jul 26 2003 - 04:29:09 CDT