Enabling archive log mode in ORACLE

Setting your Oracle 10g Database in ARCHIVELOG Mode:

1. Start your SQL *PLUS and log in with SYSDBA priveledges.

START > RUN > sqlplusw

SQL > CONNECT  username/password AS SYSDBA

2. Issue a Shutdown command

SQL > SHUTDOWN IMMEDIATE;

3. Mount yourDatabase

SQL > STARTUP MOUNT;

4. Set your database in ARCHIVELOG mode

SQL > ALTER DATABASE ARCHIVELOG;

5. Open your database

SQL > ALTER DATABASE OPEN;


6.SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled