Monthly Archives: November 2011

Enabling Archivelog Mode in Oracle9i

Problem:

How do I enable archivelog in an Oracle9i database?

Solution:

After logging into the running Oracle9i instance as the SYS user (sqlplus “/ as sysdba”), check the log_archive parameters:

show parameter log_archive

Set the archive log destination directory (note that these commands assume that the database uses the spfile):

alter system set log_archive_start=TRUE scope=spfile;
alter system set log_archive_dest_1='location=/u01/archive/ORCL/' scope=spfile;
alter system set log_archive_format='arch_%t_%s.arc' scope=spfile;

Then shutdown and mount the database, and enable archivelog:

shutdown immediate;
startup mount;
archive log start;
alter database archivelog;
alter database open;

Reference:
http://www.oracle-base.com/articles/9i/ArchivelogModeOnRAC9i.php