oralce 启动信息

SQL> startup nomout
SP2-0714: invalid combination of STARTUP options
SQL> startup nomount
ORACLE instance started.

Total System Global Area  209715200 bytes
Fixed Size                  1266632 bytes
Variable Size              79694904 bytes
Database Buffers          125829120 bytes
Redo Buffers                2924544 bytes

  //看看对应alert_orcl.log


[oracle@localhost bdump]$ tail -f alert_orcl.log
Thu Oct 21 21:40:37 2010
Starting ORACLE instance (normal)//启动实例
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/10.2/db/dbs/arch
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  sessions                 = 170
  __shared_pool_size       = 71303168
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 209715200
  control_files            = /opt/oracle/product/oradata/orcl/control01.ctl, /opt/oracle/product/oradata/orcl/control02.ctl, /opt/oracle/product/oradata/orcl/control03.ctl
  db_block_size            = 8192
  __db_cache_size          = 125829120
  compatible               = 10.2.0.3.0
  db_file_multiblock_read_count= 16
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
  job_queue_processes      = 10
  background_dump_dest     = /opt/oracle/product/admin/orcl/bdump
  user_dump_dest           = /opt/oracle/product/admin/orcl/udump
  core_dump_dest           = /opt/oracle/product/admin/orcl/cdump
  audit_file_dest          = /opt/oracle/product/admin/orcl/adump
  db_name                  = orcl
  open_cursors             = 300
//上面是参数，下面是实例的进程
  pga_aggregate_target     = 41943040
MMAN started with pid=4, OS id=4906
PSP0 started with pid=3, OS id=4904
PMON started with pid=2, OS id=4902
DBW0 started with pid=5, OS id=4908
LGWR started with pid=6, OS id=4910
CKPT started with pid=7, OS id=4912
SMON started with pid=8, OS id=4914
RECO started with pid=9, OS id=4916
CJQ0 started with pid=10, OS id=4918
MMON started with pid=11, OS id=4920

//pid 数据库内部标识代码 os id 对应操作系统进程的pid 
Thu Oct 21 21:40:40 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4922
Thu Oct 21 21:40:40 2010
starting up 1 shared server(s) ...

再执行 alter database mount;

//装载数据库

alter database mount
Thu Oct 21 21:48:06 2010
Setting recovery target incarnation to 2
Thu Oct 21 21:48:07 2010
Successful mount of redo thread 1, with mount id 1260771474
Thu Oct 21 21:48:07 2010
Database mounted in Exclusive Mode
Completed: alter database mount

再打开数据库
alter database open;

alter database open
Thu Oct 21 21:49:31 2010
Beginning crash recovery of 1 threads
Thu Oct 21 21:49:31 2010
Started redo scan
Thu Oct 21 21:49:32 2010
Completed redo scan
 276 redo blocks read, 69 data blocks need recovery
Thu Oct 21 21:49:33 2010
Started redo application at
 Thread 1: logseq 8, block 3
Thu Oct 21 21:49:33 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 8 Reading mem 0
  Mem# 0: /opt/oracle/product/oradata/orcl/redo02.log
Thu Oct 21 21:49:33 2010
Completed redo application
Thu Oct 21 21:49:33 2010
Completed crash recovery at
 Thread 1: logseq 8, block 279, scn 666813
 69 data blocks read, 69 data blocks written, 276 redo blocks read
Thu Oct 21 21:49:33 2010
Thread 1 advanced to log sequence 9 (thread open)
Thread 1 opened at log sequence 9
  Current log# 3 seq# 9 mem# 0: /opt/oracle/product/oradata/orcl/redo03.log
Successful open of redo thread 1
Thu Oct 21 21:49:34 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Oct 21 21:49:34 2010
SMON: enabling cache recovery
Thu Oct 21 21:49:37 2010
Successfully onlined Undo Tablespace 1.
Thu Oct 21 21:49:37 2010
SMON: enabling tx recovery
Thu Oct 21 21:49:37 2010
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=4930
Thu Oct 21 21:49:48 2010
Completed: alter database open

上面是oralce nomount mount open 过程 ，alert_orcl.log的变化