[root@rtest ~]# su - oracle
[oracle@rtest ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 2 10:47:46 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
idle> conn /as sysdba
Connected.
sys@TESTDB> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Current log sequence 7
sys@TESTDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@TESTDB> startup mount;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 1929379840 bytes
Redo Buffers 20078592 bytes
Database mounted.
sys@TESTDB> alter database archivelog;
Database altered.
sys@TESTDB> alter database open;
Database altered.
sys@TESTDB> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
sys@TESTDB> shutdown immedaite;
SP2-0717: illegal SHUTDOWN option
sys@TESTDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@TESTDB> startup mount;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 1929379840 bytes
Redo Buffers 20078592 bytes
Database mounted.
sys@TESTDB> alter database noarchivelog;
Database altered.
sys@TESTDB> alter database open;
Database altered.
sys@TESTDB> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Current log sequence 7
sys@TESTDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@TESTDB> startup mount;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 1929379840 bytes
Redo Buffers 20078592 bytes
Database mounted.
sys@TESTDB> alter database archivelog;
Database altered.
sys@TESTDB> alter database open;
Database altered.
sys@TESTDB> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
总结：
在mount状态下转换，
使用alter database archivelog;转为归档
使用alter database noarchivelog;转为非归档
最后打开数据库alter database open;