11g Convert to Archive Mode

Archivelog Mode
------------------

1.
mkdir for archive and make sure it exists with correct write permissions.
$ pwd -> /u01/oracle/arch/orcl1

2.
sqlplus sys as sysdba

SQL> Select log_mode
From v$database;

o/p -> NOARCHIVELOG or ARCHIVELOG (If NOARCHIVELOG then proceed as follows;)

3.
SQL> alter system set log_archive_dest_1='location=/u01/oracle/arch/orcl1';

4.
SQL> shutdown immediate;

5.
SQL> startup mount;

SQL> Select open_mode
From v$database;

o/p -> MOUNTED

6.
SQL> alter database archivelog;

7.
SQL> alter database open;

SQL> Select log_mode
From v$database;

o/p -> ARCHIVELOG

8.
SQL> alter system switch logfile;

9.
SQL> host ls /u01/oracle/arch/orcl1

o/p -> The logswitch should have created an archive redo log

-----------------------------------------------------------------

- Suresh