10.2.0.5
windows 2008 64 bit
sql>shutdown immediate
sql>startup mount
sql>alter database archivelog manual
sql>archive log list
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\archive
Oldest online log sequence 28
Next log sequence to archive 28
Current log sequence 29
SQL>
虽然看上去自动归档,但是在v$database里面可以看出是手工归档
SQL> select log_mode from v$database;LOG_MODE
------------
MANUAL