Changing the Oracle Database Archive Mode

Enabling Archive Mode

  • Oracle 10g and latest SI.
SQL> alter system set log_archive_dest_1='location=/oradata/orcl/archivelog' scope=spfile;

SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

SQL> alter system switch logfile;
  • Oracle 10g and latest RAC.
SQL> alter system set log_archive_dest_1='location=+ARCH' scope=spfile sid='*';

~]$ srvctl stop database -d orcl
~]$ srvctl start instance -d orcl -i orcl1 -o mount

SQL> alter database archivelog;
SQL> alter database open;

~]$ srvctl start instance -d orcl -i orcl2

SQL> alter system archive log current;

Disabling Archive Mode

  • Oracle 10g and latest SI.
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog;
SQL> alter database open;
  • Oracle 10g and latest RAC.
~]$ srvctl stop database -d orcl
~]$ srvctl start instance -d orcl -i orcl1 -o mount

SQL> alter database noarchivelog;
SQL> alter database open;

~]$ srvctl start instance -d orcl -i orcl2