SQL>alter system set log_archive_start=TRUE scope=spfile;

SQL>alter system set log_archive_dest_1='LOCATION=/u01/ora9/oradata/itown01/archive' scope=spfile;

 

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> ls
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 7 15:47:31 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter system switch logfile;

System altered.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
oracle@linux-unknown:/u01/ora9/oradata/itown01/archive> ls
1_1330.dbf

 

注:在oracle10g只需要执行开启归档模式命令即可

SQL> alter database archivelog;