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

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;

ITPub博客

开启归档模式

最新文章