Monthly Archives: November 2011

Enabling Archivelog Mode in Oracle9i


How do I enable archivelog in an Oracle9i database?


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;