Oracleæ°æ®åºçä½ç³»ç»æå
æ¬å个æ¹é¢ï¼æ°æ®åºçç©çç»æãé»è¾ç»æãå
åç»æåè¿ç¨ã
ãã
ãã1. ç©çç»æ
ãã
ããç©çæ°æ®åºç»ææ¯ç±æææ°æ®åºçæä½ç³»ç»æ件æå³å®ï¼Oracleæ°æ®åºæ件å
æ¬ï¼
ãã
ããæ°æ®æ件ï¼Data Fileï¼
ããæ°æ®æ件ç¨æ¥åå¨æ°æ®åºä¸çå
¨é¨æ°æ®ï¼ä¾å¦æ°æ®åºè¡¨ä¸çæ°æ®åç´¢å¼æ°æ®.é常以为*.dbfæ ¼å¼ï¼ä¾å¦:userCIMS.dbf ã
ãã
ããæ¥å¿æ件ï¼Redo Log Fileï¼
ããæ¥å¿æ件ç¨äºè®°å½æ°æ®åºæåçå
¨é¨åæ´ï¼å¦å¢å ãå é¤ãä¿®æ¹ï¼ã以便å¨ç³»ç»åçæ
éæ¶ï¼ç¨å®å¯¹æ°æ®åºè¿è¡æ¢å¤ãååé常为Log*.dbfæ ¼å¼ï¼å¦ï¼Log1CIMS.dbf,Log2CIMS.dbf ã
ãã
ããæ§å¶æ件ï¼Control Fileï¼
ããæ¯ä¸ªOracleæ°æ®åºé½æç¸åºçæ§å¶æ件ï¼å®ä»¬æ¯è¾å°çäºè¿å¶æ件ï¼ç¨äºè®°å½æ°æ®åºçç©çç»æï¼å¦ï¼æ°æ®åºåãæ°æ®åºçæ°æ®æ件åæ¥å¿æ件çåååä½ç½®çä¿¡æ¯ãç¨äºæå¼ãååæ°æ®åºãååé常为Ctrl*ctl æ ¼å¼ï¼å¦Ctrl1CIMS.ctlã
ãã
ããé
ç½®æ件
ããé
ç½®æ件记å½Oracleæ°æ®åºè¿è¡æ¶çä¸äºéè¦åæ°ï¼å¦ï¼æ°æ®åç大å°ï¼å
åç»æçé
ç½®çãååé常为init*.ora æ ¼å¼ï¼å¦ï¼initCIMS.ora ã
ãã
ãã2 é»è¾ç»æ
ãã
ããOracleæ°æ®åºçé»è¾ç»ææè¿°äºæ°æ®åºä»é»è¾ä¸å¦ä½æ¥åå¨æ°æ®åºä¸çæ°æ®ãé»è¾ç»æå
æ¬è¡¨ç©ºé´ã段ãåºãæ°æ®åå模å¼å¯¹è±¡ãæ°æ®åºçé»è¾ç»æå°æ¯é
ä¸ä¸ªæ°æ®åºå¦ä½ä½¿ç¨ç³»ç»çç©ç空é´.模å¼å¯¹è±¡åå
¶ä¹é´çèç³»åæè¿°äºå
³ç³»æ°æ®åºä¹é´ç设计.
ãã
ããä¸ä¸ªæ°æ®åºä»é»è¾ä¸è¯´æ¯ç±ä¸ä¸ªæå¤ä¸ªè¡¨ç©ºé´æç»æï¼è¡¨ç©ºé´æ¯æ°æ®åºä¸ç©çç¼ç»çæ°æ®ä»åºï¼æ¯ä¸ä¸ªè¡¨ç©ºé´æ¯ç±æ®µ(segment)ç»æï¼ä¸ä¸ªæ®µæ¯ç±ä¸ç»åº(extent)æç»æï¼ä¸ä¸ªåºæ¯ç±ä¸ç»è¿ç»çæ°æ®åºå(database block)ç»æï¼èä¸ä¸ªæ°æ®åºå对åºç¡¬çä¸çä¸ä¸ªæå¤ä¸ªç©çåãä¸ä¸ªè¡¨ç©ºé´åæ¾ä¸ä¸ªæå¤ä¸ªæ°æ®åºçç©çæ件ï¼å³æ°æ®æ件ï¼.ä¸ä¸ªæ°æ®åºä¸çæ°æ®è¢«é»è¾å°åå¨å¨è¡¨ç©ºé´ä¸ã
ãã
ãã表空é´ï¼tablespaceï¼
ããOracleæ°æ®åºè¢«åå为ä¸ä¸ªæå¤ä¸ªç§°ä¸ºè¡¨ç©ºé´çé»è¾ç»æï¼å®å
æ¬ä¸¤ç±»è¡¨ç©ºé´ï¼System表空é´åéSystem表空é´ï¼å
¶ä¸ï¼System表空é´æ¯å®è£
æ°æ®åºæ¶èªå¨å»ºç«çï¼å®å
å«æ°æ®åºçå
¨é¨æ°æ®åå
¸ï¼åå¨è¿ç¨ãå
ãå½æ°å触åå¨çå®ä¹ä»¥åç³»ç»åæ»æ®µãé¤æ¤ä¹å¤ï¼è¿è½å
å«ç¨æ·æ°æ®ãã
ãã
ããä¸ä¸ªè¡¨ç©ºé´å
å«è®¸å¤æ®µï¼æ¯ä¸ªæ®µæä¸äºå¯ä»¥ä¸è¿ç»çåºç»æï¼æ¯ä¸ªåºç±ä¸ç»è¿ç»çæ°æ®åç»æï¼æ°æ®åæ¯æ°æ®åºè¿è¡æä½çæå°åä½ã
ãã
ããæ¯ä¸ªè¡¨ç©ºé´å¯¹åºä¸ä¸ªæå¤ä¸ªæ°æ®æ件ï¼æ¯ä¸ªæ°æ®æ件åªè½å±äºä¸ä¸ªè¡¨ç©ºé´ã
ãã
ããæ°æ®åºåï¼database blockï¼
ããæ°æ®åºåä¹ç§°é»è¾åæORACLEåï¼å®å¯¹åºç£çä¸ä¸ä¸ªæå¤ä¸ªç©çåï¼å®ç大å°ç±åå§ååæ°db-block-sizeï¼å¨æ件init.oraä¸ï¼å³å®ï¼å
¸åç大å°æ¯2kãPckfree åpctused 两个åæ°ç¨æ¥ä¼åæ°æ®å空é´ç使ç¨ã
ãã
ããåºï¼extentï¼
ããåºæ¯ç±ä¸ç»è¿ç»çæ°æ®åæç»æçæ°æ®åºåå¨ç©ºé´åé
çé»è¾åä½ã
ãã
ãã段ï¼segmentï¼
ãã段æ¯ä¸ä¸ªæå¤ä¸ªä¸è¿ç»çåºçéåï¼å®å
æ¬ä¸ä¸ªè¡¨ç©ºé´å
ç¹å®é»è¾ç»æçæææ°æ®ï¼æ®µä¸è½è·¨è¡¨ç©ºé´åæ¾ãOracleæ°æ®åºå
æ¬æ°æ®æ®µãç´¢å¼æ®µã临æ¶æ®µãåæ»æ®µçã
温馨提示:答案为网友推荐,仅供参考