Re: Restoring & recovering in NOARCHIVELOG

From: Quarkman <quarkman_at_myrealbox.com>
Date: Sat, 26 Jul 2003 07:18:52 +1000
Message-ID: <oprsvxhqmhr9lm4d@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 Received on Fri Jul 25 2003 - 16:18:52 CDT