How to enable ARCHIVELOG MODE in Oracle 9i
Initially when a database is created, by default the database will always be in NOARCHIVELOG mode. In order to put it in ARCHIVELOG mode, you must do the following:
1) You have to shutdown the database
SQL>shutdown immediate;
2) Set the parameter in the pfile (i.e. init.ora).
LOG_ARCHIVE_START=TRUE
3) Create New SPFILE from Modified pfile(init.ora)
SQL> create SPFILE from PFILE;
4) Startup Database in Mount Mode
SQL> startup mount;
5) Change Database log mode from NOARCHIVELOG to ARCHIVELOG
SQL> alter database archivelog;
6) Open DB for normal use
SQL> alter database open;
7) Check the archive log status
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\Oracle\product\RDBMS
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1
Default Archivelog destination is :$ORACLE_HOME/rdbms.