時(shí)間：2015-06-28 00:00:00 來源：IT貓撲網(wǎng) 作者：網(wǎng)管聯(lián)盟 我要評論(0)
Oracle的啟動過程共經(jīng)歷四個(gè)階段：
shutdown→nomount→mount→open
shutdown→nomount過程：
讀初始參數(shù)文件
分配物理內(nèi)存
啟動后臺進(jìn)程
定位到控制文件
打開/寫alert文件
nomount過程可以訪問的動態(tài)性能視圖：v$parameter,v$sga,v$option,v$process,v$version,v$instance
nomount→mount過程：
打開控制文件
確認(rèn) database的結(jié)構(gòu)信息
mount過程可以訪問的動態(tài)性能視圖: v$thread,v$controlfile,v$database,v$datafile,v$datafile_header,v$logfile
以下任務(wù)必須在mount狀態(tài)下進(jìn)行：
命名數(shù)據(jù)文件
啟用和禁用重作日志歸檔選項(xiàng)
執(zhí)行完全數(shù)據(jù)庫恢復(fù)
mount→open過程：
打開數(shù)據(jù)文件
打開重做日志文件
最后階段中，oracle服務(wù)器驗(yàn)證所有數(shù)據(jù)文件和重做日志文件是否可以打開，并檢查數(shù)據(jù)庫的一致性，如果需要，smon進(jìn)程會啟動例程恢復(fù)。
自上而下：
shutdown：
nomount：讀取初始化參數(shù)，并且分配物理內(nèi)存，通過初始化參數(shù)定位到control file，后臺進(jìn)程啟動，寫alter文件，如果alter文件不存在將創(chuàng)建它
SQL> startup nomount
ORACLE 例程已經(jīng)啟動。
Total System Global Area 167772160 bytes
Fixed Size????? 1247900 bytes
Variable Size? 83887460 bytes
Database Buffers???? 79691776 bytes
Redo Buffers??? 2945024 bytes
altert文件中內(nèi)容：
Fri Dec 28 11:34:06 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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.1.0.
System parameters with non-default values:
processes??? = 150
__shared_pool_size = 75497472
__large_pool_size? = 4194304
__java_pool_size?? = 4194304
__streams_pool_size????? = 0
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_2\DBS\SPFILEORCL.ORA
sga_target?? = 167772160
control_files????? = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size????? = 8192
__db_cache_size??? = 79691776
compatible?? = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest??? = E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management??? = AUTO
undo_tablespace??? = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain??? =
dispatchers? = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes????? = 10
audit_file_dest??? = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest???? = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest???? = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest???? = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name????? = orcl
open_cursors = 300
pga_aggregate_target???? = 16777216
PMON started with pid=2, OS id=3280
PSP0 started with pid=3, OS id=2972
MMAN started with pid=4, OS id=2280
DBW0 started with pid=5, OS id=828
LGWR started with pid=6, OS id=1936
CKPT started with pid=7, OS id=3844
SMON started with pid=8, OS id=596
RECO started with pid=9, OS id=3252
CJQ0 started with pid=10, OS id=1932
MMON started with pid=11, OS id=3788
Fri Dec 28 11:34:17 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=928
Fri Dec 28 11:34:17 2007
starting up 1 shared server(s) ...
#p#副標(biāo)題#e#
在nomount狀態(tài)：
可以訪問到實(shí)例
SQL> select * from v$instance;
INSTANCE_NUMBER? INSTANCE_NAME?? HOST_NAME
--------------- -------------------------------- -------------------------------
1??? orcl???? ORACLE10G
可以訪問到后臺進(jìn)程
select * from v$bgprocess;
可以訪問到內(nèi)存結(jié)構(gòu)
SQL> select * from v$sga;
NAME????? VALUE
---------------------------------------- ----------
Fixed Size??? 1247900
Variable Size????? 83887460
Database Buffers?? 79691776
Redo Buffers? 2945024
關(guān)鍵詞標(biāo)簽：Oracle
相關(guān)閱讀
熱門文章
Oracle中使用alter table來增加,刪除,修改列的語法
oracle中使用SQL語句修改字段類型-oracle修改SQL語句案例
誤刪Oracle數(shù)據(jù)庫實(shí)例的控制文件
為UNIX服務(wù)器設(shè)置Oracle全文檢索
人氣排行 oracle中使用SQL語句修改字段類型-oracle修改SQL語句案例 Oracle中使用alter table來增加,刪除,修改列的語法 ORACLE SQL 判斷字符串是否為數(shù)字的語句 ORACLE和SQL語法區(qū)別歸納(1) oracle grant 授權(quán)語句 ORACLE修改IP地址后如何能夠使用 如何加速Oracle大批量數(shù)據(jù)處理 Oracle刪除表的幾種方法