Re: Simple archivelog question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 3 Oct 2002 22:08:09 +1000
Message-ID: <nfWm9.45382$g9.129750@newsfeeds.bigpond.com>

Hi Charlie,

OK, this is what I would do.

Go up to the DBA, big smile on your face and chat about the weather, the sport on the weekend, what a great new album Bowie has recently released, how fit and healthy he/she looks and then just nonchalantly ask, "... and ummm, is the database in archivelog or noarchivelog mode at the moment" ?

If he/she replies archivelog mode then congratulate him/she on their quality of work and buy them a donut.

If the reply is noarchivelog mode then look them dead in the eye and ask "Why" ? Then sit back and listen real carefully for it had better be good ...

Cheers

Richard
"Charlie Edwards" <charlie3101_at_hotmail.com> wrote in message news:217ac5a8.0210020855.775df0a2_at_posting.google.com...
> I'm not a DBA, so I tend to not worry about the intricacies of backup
> and recovery, leaving that to those more qualified.
>
> However, I rather suspect that my database is not in archivelog mode.
>
> How can I tell (bearing in mind I don't have access to V$DATABASE :-()
> whether this is the case? The background processes in V$SESSION
> perhaps?
>
> These days, is there a good reason for _not_ running in archivelog
> mode?
>
> Thanks,
>
> CE
Received on Thu Oct 03 2002 - 07:08:09 CDT