å¨Oracleæ°æ®åºä¸ï¼æä¸ç§æ¥å¿æ件å«åéåæ¥å¿æ件ï¼ä»å°±æ¯å¤§å®¶ä¿ç§°çï¼redologãå¨redologä¸åå为两ç§ï¼å¨çº¿éåæ¥å¿ä¸å½æ¡£æ¥å¿ã
ONLINE Redo log
å¨çº¿éåæ¥å¿(online redo log )主è¦ç¨äºï¼Oracleæ°æ®åºæå¨æå¡å¨çªç¶æçµãçªç¶éå¯æè
æ§è¡shutdown abortçå½ä»¤ä½¿å¾å¨æå¡å¨éæ°å¯å¨ä¹åï¼Oracleæ°æ®åºæ²¡æåæ³æ£å¸¸çå¯å¨å®ä¾ãæ¤æ¶ï¼å¨çº¿éåæ¥å¿å°±æ´¾ä¸äºç¨åºï¼Oracleä¼ä½¿ç¨å¨çº¿éåæ¥å¿ï¼ææ°æ®åºæ¢å¤å°æå¡å¨æçµåçé£ä¸ä¸ªæ¶å»ï¼ä»è使å¾æ°æ®åºè½æ£å¸¸çå¯å¨èµ·æ¥ ã
å¨Oracleæ°æ®åºä¸ï¼é»è®¤æ
åµä¸ï¼è³å°ä¼æ两个éåæ¥å¿ç»ï¼èä¸æ¯ä¸ªç»éé¢è³å°å
å«äºä¸ä¸ªéåæ¥å¿æ件ãæ¥å¿ç»ä¸ä¼èªå¨å¢å ï¼å¨ä¸ä¸ªå满ä¹åï¼ä¼èªå¨å»åä¸ä¸ä¸ªãå¨ä¸ä¸ä¸ªè¢«å满ä¹åä¼åä»ç¬¬ä¸ä¸ªå¼å§åèµ·ã
Archive redo log
å½æ¡£æ¥å¿(archive log)主è¦ç¨äºç¡¬ä»¶çº§å«çé误ï¼ç£ççåé导è´æ æ³è¯»åãåå
¥ç失败ãç£çåæ导è´æ°æ®åºæ°æ®ä¸¢å¤±ãè¿å°±è¦ä½¿ç¨å½æ¡£æ¥å¿æ件ï¼éè¿å½æ¡£æ¥å¿æ件ï¼ææ°æ®åºæ¢å¤å°å½æ¡£æ¥å¿æå¨çæ¶é´ç¹ä¸ç¶ååéè¿å¨çº¿éåæ¥å¿æ件ææ°æ®åºæ¢å¤å°å½åçæ¶é´ç¹ä¸ã
对äºå½æ¡£æ¥å¿æ件ï¼å¯ä»¥ç解为å¨çº¿éåæ¥å¿æ件çå¤ä»½ãå³å½ä¸ä¸ªéåæ¥å¿æ件被填满äºä¹åï¼å½æ¡£æ¥å¿æ件就ä¼æå
¶å¤ä»½ä¿çä¸ä»½ãï¼å 为ä¸é¢è¯´äºï¼å¨çº¿éåæ¥å¿æ件ä¼èªå¨çè¦çï¼æ以ï¼å½æ¡£æ¥å¿æ件就æ¯æ§çå¨çº¿æ¥å¿æ件çå¤ä»½ã
温馨提示:答案为网友推荐,仅供参考