数据库修改成归档状态 - oracle

姓名：痴痴地等职业：跳蚤守望者年龄：31 位置：金刚塔下地狱十字架个性介绍：不够成熟理智，不够积极优雅,希望能够觉悟人生，奉献人生，善用其心，善待一切，感恩包容，分享结缘。“真诚、清净、平等、正觉、慈悲”，“看破、放下、自由、随缘、念佛”要用这种心对人、对事、对天地万物！佛看我们迷惑颠倒，他以种种方便来诱导我们、开启我们，希望我们豁然觉悟，又恢复到本觉，这就是佛度众生。《金刚经》上很坦率地告诉我们，佛不度众生，众生怎么度的？自己度自己。背景音乐：暂停

将一个数据库修改成归档状态如下操作

在initSID.ora中加如下面的内容
log_archive_dest='/archivelog'
log_archive_max_processes=8
log_archive_start=TRUE
log_buffer=4000000

db1@root[/oracle>]sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.6.0 - Production on Tue May 27 20:19:44 2008

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

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

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

Total System Global Area 3830225408 bytes
Fixed Size                   748032 bytes
Variable Size             671088640 bytes
Database Buffers         3154116608 bytes
Redo Buffers                4272128 bytes
Database mounted.
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Enabled
Archive destination            /archivelog
Oldest online log sequence     12058
Current log sequence           12063
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter system switch logfile;

System altered.