Re: alter system archive log stop;

Tof wrote:
> Hi,
>
> I want to know how this run.
>
> I understand for this command is simaliry for the parameter
> log_archive_start =(true or false)
>
> I take this parameter to "true" in my init.ora
>
> i show this :
> SQL> show parameter log_archive_start
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ----------------
> log_archive_start boolean TRUE
> SQL> archive log list;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination USE_DB_RECOVERY_FILE_DEST
> Oldest online log sequence 10
> Next log sequence to archive 12
> Current log sequence 12
>
> I show it run : "Automatic archival Enabled"
>
> I want to stop this :
>
> SQL> alter system ARCHIVE log stop;
>
> System altered.
> SQL> alter system switch logfile;
>
> System altered.
>
> SQL> alter system switch logfile;
>
> System altered.
>
> SQL> archive log list;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination USE_DB_RECOVERY_FILE_DEST
> Oldest online log sequence 13
> Next log sequence to archive 15
> Current log sequence 15
> SQL>
>
> I don't understant, normaly, it finish the current archived but after it
> stop this. But in this situation, it continuous run.
>
> If " alter system archive log stop;" don't refer for this ?
> and how i can see where is this status ?
>
> Thanks
>
> Christophe

There is a difference between a database in archive log *mode* and an archive process *running*. You stopped the latter, and queried the former.

-- 
Regards,
Frank van Bortel