Enabling and disabling archivelog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 16 06:56:21 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.

SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup mount;
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
Database mounted.


SQL> alter database archivelog;


Database altered.

SQL> alter database open;

Database altered.


==============================================================

automatic enable archiving at instance startup

=============================================================

SQL> alter system set log_archive_start=true scope=spfile;

System altered.

SQL> alter system set log_archive_max_processes=1;

System altered.


==============================================================

manual enable archiving

==============================================================

SQL> alter system set log_archive_start=false scope=spfile;

System altered.

==============================================================

manual archiving online redo log file.

==============================================================


SQL>
SQL> alter system archive log current;

System altered.

===============================================================

automatic enable archiving after instance startup

==============================================================

SQL> alter system archive log start;

System altered.


==============================================================

automatic desable archiving

==============================================================


SQL> alter system archive log stop;

System altered.

SQL>