oracle arvhivelog、noarchivelog与mount的关系

这里仅仅想解释下，为什么alter database archivelog 与alter database noarchivelog需要在mount状态下执行。

我们来分步骤看看oracle的启动过程日志:

SQL> startup pfile='$ORACLE_HOME/dbs/pfileorcl.ora'  mount;
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated
ORACLE instance started.


Total System Global Area  480182272 bytes
Fixed Size    2254424 bytes
Variable Size  352324008 bytes
Database Buffers  117440512 bytes
Redo Buffers    8163328 bytes
Database mounted.
SQL> 

SQL> show parameter log_archive_start


NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start     boolean FALSE
SQL> archive log list
Database log mode       No Archive Mode
Automatic archival       Disabled
Archive destination       /home/oracle/app/oracle/product/11.2.0/dbhome_1/log/archive
Oldest online log sequence     65
Current log sequence       67
SQL> select name ,log_mode from v$database;


NAME  LOG_MODE
--------- ------------
ORCL  NOARCHIVELOG


SQL> 

看看alert_${ORACLE_SID}.log中记录的启动日志

Sat May 28 00:54:04 2016
Adjusting the default value of parameter parallel_max_servers
from 160 to 120 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 4
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
    NUMA status: non-NUMA system
    cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
    Grp 0: 
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: localhost.localdomain
Release: 3.10.0-229.el7.x86_64
Version: #1 SMP Fri Mar 6 11:36:42 UTC 2015
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in client-side pfile /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/pfileorcl.ora on machine localhost.localdomain
System parameters with non-default values:
  processes                = 150
  memory_target            = 460M
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl"
  control_files            = "/home/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.4.0"
  log_archive_dest_1       = "location=/home/oracle/app/oracle/product/11.2.0/dbhome_1/log/archive"
  log_archive_start        = FALSE
  db_recovery_file_dest    = "/home/oracle/app/oracle/fast_recovery_area"
  db_recovery