alter system archive log stop;

From: Tof <None_at_ForNotSpam>
Date: Tue, 01 Mar 2005 11:15:10 +0100
Message-ID: <42244261$0$840$8fcfb975@news.wanadoo.fr>

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 Received on Tue Mar 01 2005 - 04:15:10 CST