Enabling and disabling Archivelog mode
                                                 Last update (2009-12-14 09:50:09)
                                                                                                                   Date added (2008-02-13 16:11:22)

Summary
First check in what mode you are.
Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE# from V$DATABASE;
From NOARCHIVELOG -> AUTOMATIC ARCHIVELOG MODE
To turn on automatic archivelog mode for Oracle9i set the parameters.
alter system set log_archive_start=TRUE scope=spfile;
alter system set log_archive_max_processes=3 scope=spfile;
alter system set log_archive_min_succeed_dest=1 scope=spfile;
alter system set log_archive_trace=0 scope=spfile;
alter system set log_archive_format='arch%t_EDB1_%s.ARC' scope=spfile;
alter system set log_archive_dest_1='location=/oracle10/ARCHIVES/EDB1' scope=spfile;
You have to restart the database
sqlplus "/ as sysdba"
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
alter system switch logfile;
Check if the archive log file is created at the log_archive_dest_1

Depending on the version of Oracle some small differences might exist. For example at Oracle10g you donąt have to set:
log_archive_start=TRUE and the log_archive_format must contain %s, %t and %r.

For RAC especially, because of the two instances lets say OTE1 and OTE2 the steps are a little bit different.
First you have to set the parameter cluster_database = FALSE
Then to startup mount only one instance (OTE1)
Then shutdown immediate this instance (OTE1)
Then change parameter cluster_database = TRUE

From AUTOMATIC ARCHIVELOG MODE -> NOARCHIVELOG

Remove all parameters from spfile that have to do with archiving, and restart the database. For example
ALTER SYSTEM RESET log_archive_format SCOPE=SPFILE SID='*';
You have to restart the database
sqlplus "/ as sysdba"
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search