Enable auto archivelog mode

1. For oracle 9i:

SYS@test > alter system set log_archive_start=true scope=spfile;

System altered.

 

SYS@test > shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test > startup mount
ORACLE instance started.

Total System Global Area  143727516 bytes
Fixed Size                   453532 bytes
Variable Size             109051904 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.

 

SYS@test > select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

 

SYS@test > alter database archivelog;

Database altered.

SYS@test > select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

 

SYS@test > alter database open;

Database altered.

 

SYS@test > select name from v$archived_log;

no rows selected

SYS@test > alter system switch logfile;

System altered.

SYS@test > select name from v$archived_log;

NAME
---------------------------------------------
---------------------------------------------
D:\ORACLE\ORA92\RDBMS\ARC00052.001

 

SYS@test > alter system set log_archive_dest='D:\oracle\ora92\database\archive'
scope=both;

System altered.

 

SYS@test > alter system switch logfile;

System altered.

SYS@test > select name from v$archived_log;

NAME
----------------------------------------------------------
----------------------------------------------------
D:\ORACLE\ORA92\RDBMS\ARC00052.001
D:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00053.001