archMode.txt
09-08-2001 Bikle
------------------

This file describes the steps to place the ABIKLE database in ARCHIVELOG mode.

First, we use grep to find the value of LOG_ARCHIVE_DEST in $ORACLE_HOME/dbs/initABIKLE.ora:


sf49er.bikle.com 2 % grep -i dest $ORACLE_HOME/dbs/initABIKLE.ora
log_archive_dest_1 = "location=/u2/oracle/data/ABIKLE/arch"
background_dump_dest = /u2/oracle/admin/ABIKLE/bdump
core_dump_dest = /u2/oracle/admin/ABIKLE/cdump
user_dump_dest = /u2/oracle/admin/ABIKLE/udump
sf49er.bikle.com 3 %

Next, we make sure that the LOG_ARCHIVE_DEST directory exists:

sf49er.bikle.com 3 % mkdir /u2/oracle/data/ABIKLE/arch
sf49er.bikle.com 4 % 

Then, we put the database in ARCHIVELOG mode:

$ ABIKLE.csh
sf49er.bikle.com 1 % sqi

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Sep 8 13:23:32 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

13:23:32 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
13:23:50 SQL> startup mount
ORACLE instance started.

Total System Global Area  186908832 bytes
Fixed Size		      73888 bytes
Variable Size		   75399168 bytes
Database Buffers	  100933632 bytes
Redo Buffers		   10502144 bytes
Database mounted.

13:24:12 SQL> alter database archivelog;

Database altered.

13:24:24 SQL> alter database open;

Database altered.

13:24:38 SQL> alter system switch logfile;

System altered.

13:24:47 SQL> exit


sf49er.bikle.com 4 % ls -latr /u2/oracle/data/ABIKLE/arch
total 9236
drwxr-xr-x   3 oracle   dba          512 Sep  7 00:00 ../
drwxr-xr-x   2 oracle   dba          512 Sep  8 13:24 ./
-rw-r-----   1 oracle   dba      4715008 Sep  8 13:24 arch_1_131.arc
sf49er.bikle.com 5 %