[Oracle 10g] ÉÁ»Ø»Ö¸´Çø (Flash Recovery Area)
ºÎΪÉÁ»Ø»Ö¸´Çø
Oracle 10g ÓÐÒ»Ïîй¦ÄܳÆÎª:×Ô¶¯µÄ»ùÓÚ´ÅÅ̵ı¸·ÝÓë»Ö¸´( Automatic Disk-Based Backup and Recovery )¡£ÊµÏָù¦ÄܵĻù´¡Îª±¾ÎÄÒª½²ÊöµÄÉÁ»Ø»Ö¸´Çø( Flash Recovery Area )¡£ÉÁ»Ø»Ö¸´ÇøÊÇ Oracle 10g ÖеÄÐÂÊÂÎï¡£¼òµ¥µÄ˵£¬ÉÁ»Ø»Ö¸´ÇøÊÇÒ»¿éÓÃÒÔ´æ´¢»Ö¸´Ïà¹ØµÄÎļþµÄ´æ´¢¿Õ¼ä¡£ÔÊÐíÓû§¼¯Öд洢ËùÓлָ´Ïà¹ØµÄÎļþ¡£
ÉÁ»Ø»Ö¸´Çø¿ÉÒÔ·ÅÔÚÈçϼ¸ÖÖ´æ´¢ÐÎʽÉÏ:
Ŀ¼
Ò»¸öÎļþϵͳ
×Ô¶¯´æ´¢¹ÜÀí(ASM)´ÅÅÌ×é
ÔÚ RAC »·¾³ÖÐ,Õâ¸ö¸ÃλÖñØÐëΪ ¼¯ÈºÎļþϵͳ (cluster file system) »òÊÇ ASM ´ÅÅÌ×éÒà»òÊÇͨ¹ý NFS ¿ØÖƵÄÎļþ¹²ÏíĿ¼£¬»¹Òª×¢ÒâµÄÊÇ£¬ËùÓÐʵÀýµÄλÖúͲÙ×÷ϵͳµÄ´ÅÅÌÏÞ¶î (disk quota) ±ØÐëÒ»Ö¡£
Èçϼ¸ÖÖÎļþ¿ÉÒԷŵ½ÉÁ»Ø»Ö¸´ÇøÖÐ:
¿ØÖÆÎļþ
¹éµµµÄÈÕÖ¾Îļþ(×¢£ºOracle ÊÖ²áÉÏËù˵µÄÔÚÉ趨flash recovery areaÖ®ºó£¬LOG_ARCHIVE_DEST_10µÄÖµ½«×Ô¶¯É趨Ϊflash recovery areaµÄλÖã¬Õâ¸ö±ä»¯ÔÚ±ÊÕß²âÊÔ¹ý³ÌÖй۲첻µ½)
ÉÁ»ØÈÕÖ¾
¿ØÖÆÎļþºÍ SPFILE ×Ô¶¯±¸·Ý
RMAN ±¸·Ý¼¯
Êý¾ÝÎļþ¿½±´
ΪºÎÒªÓÃÉÁ»Ø»Ö¸´Çø?
ÈçǰËùÊö£¬ÉÁ»Ø»Ö¸´ÇøÌṩÁËÒ»¸ö¼¯Öл¯µÄ´æ´¢ÇøÓò£¬ºÜ´ó³Ì¶ÈÉϼõСÁ˹ÜÀí¿ªÏú¡£ÕâÊÇÆä×îÖ÷ÒªµÄÓŵ㡣Óë RMAN ½áºÏʹÓÿÉÒÔ½øÐпìËÙ»Ö¸´¡£
½üÄêÀ´Ëæ×Å´æ´¢¼¼ÊõµÄ·¢Õ¹£¬µ¥¸ö´ÅÅ̵Ĵ洢ÄÜÁ¦ÒѾ¼ÓÇ¿¡£Õâʹ×Ô¶¯µÄ»ùÓÚ´ÅÅ̵ı¸·ÝÓë»Ö¸´µÄ¼¼ÊõʵÏÖ³ÉΪ¿ÉÄÜ¡£¶øÉÁ»Ø»Ö¸´ÇøÇ¡ÊÇ»ùÓÚ´ÅÅ̵ı¸·ÝÓë»Ö¸´µÄ»ù´¡¡£°ÑÉÁ»Ø»Ö¸´ÇøºÍ OMF Óë ASM ½áºÏÔËÓÿ´ÆðÀ´ÊDZȽÏÍêÃÀµÄ·½°¸¡£µ±È»£¬²»¿É·ñÈϵÄÊÇ£¬×Ô¶¯±¸·Ý»Ö¸´¼¼Êõ»¹Ô¶Ô¶²»¹»³ÉÊì¡£
É趨ÉÁ»Ø»Ö¸´Çø
Èç¹ûÄúʹÓÃDBCA´´½¨µÄÊý¾Ý¿â£¬ÔÚ°²×°Ê±¿ÉÒÔÉ趨ÉÁ»Ø»Ö¸´ÇøµÄλÖÃÒÔ¼°´óС(µã»÷ÕâÀï²é¿´°²×°½ØÍ¼)--ÕâÒ²ÊÇ Oracle 10g OUI µÄй¦ÄÜÖ®Ò»¡£Èç¹ûÔÚ¿ªÊ¼µÄʱºòûÓÐÆôÓÃÉÁ»Ø»Ö¸´Çø£¬¿ÉÒÔͨ¹ýÈçÏ·½Ê½É趨¡£
µ÷ÕûÈçÏÂÁ½¸ö¶¯Ì¬³õʼ»¯²ÎÊý(ÎÞÐèÖØÐÂÆô¶¯ÊµÀý)£º
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2g SCOPE=BOTH;
System altered.
SQL>
SQL> ALTER SYSTEM SET db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
2 SCOPE=BOTH;
System altered.
SQL>
Ö®ºó²é¿´Ëù×÷µÄÐÞ¸ÄÊÇ·ñÉúЧ£º
SQL> SHOW parameter db_recovery_file_dest
NAME TYPE VALUE
-------------------------------- ----------- -----------------------------------
db_recovery_file_dest
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10 ......
Ò».ÔÚWEBLOGICÉÏÅ䱸ÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGICÌṩµÄ¸ººÉ¾ùºâıÂÔ£¬½«²¢·¢¾ùºâµÄ¾÷±ðµ½Á½¸ö½ÚµãÉÏ¡£ÏêϸÅ䱸ÔÚÈç´Î²Î¿¼×ÊÁÏ»ò¸½¼þÖС£
²Î¿¼×ÊÁÏ:http://www.oracle.com/technology/products/weblogic/howto/rac/index.html
¶þ.Ö±½ÓÊ©ÓÃÁËRACµÄÔØºÉ¾ùºâ¶Ô²ß¡£
ÔÚOracleÖÐÕÒ³ötnsnames.oraÕâ¸ö×ÊÁÏ¡£ÔÚÅ䱸Êý¾ÝԴʱ£¬UR ......
objectǶÈë¶ÔÏóÖ®Flash²¥·ÅÆ÷
object±ê¼Ç¶¨ÒåÒ»¸öǶÈëµÄ¶ÔÏó¡£ÇëʹÓôËÔªËØÏòÄúµÄ XHTML Ò³ÃæÌí¼Ó¶àýÌå¡£´ËÔªËØÔËÐÐÄú¹æ¶¨²åÈë HTML ÎĵµÖеĶÔÏóµÄÊý¾ÝºÍ²ÎÊý£¬ÒÔ¼°¿ÉÓÃÀ´ÏÔʾºÍ²Ù×÷Êý¾ÝµÄ´úÂë¡£Òò´Ëobject±ê¼Ç¿ÉÒÔÓÃÀ´ÏÔʾflash¶¯»¡£object±ê¼ÇÖ»ÊÊÓÃÓÚIEÄں˵Ää¯ÀÀÆ÷,¶ÔÓÚ·ÇIEÄں˵Ää¯ÀÀÆ÷¿ÉÓÃÇ°ÃæÑ§Ï°µÄembed¶àýÌå² ......
½áºÏÀíÂÛºÍʵ¼ÊÓ¦Ó㬶ÔRAM¡¢ROM¡¢FlashµÄ×öÒÔÇø±ð£¬ÈôÓò»µ±Ö®´¦ÇëÌá³ö
RAM(Random Access Memory)
È«ÃûÎªËæ»ú´æÈ¡¼ÇÒäÌ壬ËüÏ൱ÓÚPC»úÉϵÄÒÆ¶¯´æ´¢£¬ÓÃÀ´´æ´¢ºÍ±£´æÊý¾ÝµÄ¡£ËüÔÚÈκÎʱºò¶¼¿ÉÒÔ¶Áд£¬RAMͨ³£ÊÇ×÷Ϊ²Ù×÷ϵͳ»òÆäËûÕýÔÚÔËÐгÌÐòµÄÁÙʱ´æ´¢½éÖÊ(ÄÚ´æ)¡£µ±µçÔ´¹Ø±Õʱ ......