oracle数据库的启动与关闭.ppt

《oracle数据库的启动与关闭.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、数据库的启动与关闭数据库的体系结构DatabaseInstanceSGARedologbufferDatabuffercacheSharedpoolDatadict.cacheLibrarycachePMONDBW0SMONLGWRCKPTOthersUserprocessServerprocessPGAControlfilesDatafilesRedologfilesArchivedlogfilesParameterfilePasswordfileTheInitializationParameterFileControl_files参

2、数与SGA设置有关的参数initU15.oraSQL>CONNECT/ASSYSDBASQL>STARTUPPFILE=/DISK1/initU15.oraInstanceSGARedologbufferDatabuffercacheSharedpoolDatadict.cacheLibrarycachePMONDBWRSMONLGWRCKPTARCHUNIX和NT下的定位及默认名DefaultNameinitSID.oratextfileUNIX$ORACLE_HOME/dbsNT%ORACLE_HOMEora81databaseandP

3、ointto%ORACLE_HOMEadminsidpfile控制文件控制文件：二进制文件，存储有关数据库状态的信息。包括：数据库名表空间信息所有数据文件的名字和位置所有日志文件的名字和位置当前的日志序列号检查点信息等注意：不能用操作系统命令更改控制文件内容，只能用ORACLE命令！！！！InitializationParameterFilesEntriesarespecifictotheinstancebeingstartedTwotypesofparameters:Explicit:HavinganentryinthefileImplici

4、t:Noentrywithinthefile,butassumingtheOracledefaultvaluesMultipleinitializationparameterfilescanexistChangestoentriesinthefiletakeeffectbasedonthetypeofinitializationparameterfileused:Staticparameterfile,PFILEPersistentserverparameterfile,SPFILEPFILEinitSID.oraTextfileModifiedwi

5、thanoperatingsystemeditorModificationsmademanuallyChangestakeeffectonthenextstartupOnlyopenedduringinstancestartupDefaultlocationis$ORACLE_HOME/dbs$ORACLE_HOME/DATABASECreatingaPFILECreatedfromasampleinit.orafileSampleinstalledbytheOracleUniversalInstallerCopysampleusingoperati

6、ngsystemcopycommandUniquelyidentifiedbydatabaseSIDModifytheinitSID.oraEdittheparametersSpecifictodatabaseneedscpinit.ora$ORACLE_HOME/dbs/initdba01.oraPFILEExample#InitializationParameterFile:initdba01.oradb_name=dba01instance_name=dba01control_files=(/home/dba01/ORADATA/u01/con

7、trol01dba01.ctl,/home/dba01/ORADATA/u02/control01dba02.ctl)db_block_size=4096db_cache_size=4Mshared_pool_size=50000000java_pool_size=50000000max_dump_file_size=10240background_dump_dest=/home/dba01/ADMIN/BDUMPuser_dump_dest=/home/dba01/ADMIN/UDUMPcore_dump_dest=/home/dba01/ADMI

8、N/CDUMPundo_management=AUTOundo_tablespace=UNDOTBS...S