Re: Simple archivelog question

Charlie Edwards wrote:

> 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

Take a look at v$archive.

If on UNIX ... ps -ef | grep and look for the archiving process

Daniel Morgan Received on Wed Oct 02 2002 - 13:29:34 CDT