oracle ±¨¾¯ÈÕÖ¾ÎÞЧÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
»·¾³£ºlinux ÆóÒµ°æ oracle 10g ¸ÕÎÒɾ³ýÁ˸öÊý¾ÝÎļþ£¬startup ÌáʾÉÙÒ»¸öÊý¾ÝÎļþ£¬ µ«ÊDz鿴±¨¾¯ÈÕ־û·´Ó¦£¬»¹ÊÇÎÒ¸Õ×°ORACLEʱµÄÈÕÖ¾ÄÚÈÝ£¬ µ«Ê±¼äÊÇ×î½üÒ»´ÎstartupµÄʱ¼ä£¬ Çó½â£¡£¡£¡£¡
È·ÈÏһϸ澯ÈÕÖ¾ÎļþµÄ·¾¶ÊÇ·ñÕýÈ· show parameter background_dump_dest ·¾¶Ã»Ê²Ã´ÎÊÌ⣬ÏÖÔÚÓÖÒ»¸öÎÊÌâÀ´ÁË£¡ »Ö¸´²»ÁËÄǸöÊý¾ÝÎļþÁË£¡ ÊÇÖ±½ÓCP¹ýÀ´Â𣿵«CP¹ýÀ´ºó»¹ÊÇ¿ª²»ÆðÀ´£¡ Ó¦¸Ã°ÑÊý¾Ý¿âÆô¶¯µ½mount״̬Ï£¬´Ó±í¿Õ¼äÖÐɾ³ýµôÄãÒѾÎïÀíɾ³ýµÄÊý¾ÝÎļþ¶ÔÓ¦µÄ±í¿Õ¼ä¡£ ÎÒ¾ÍÊÇÏëʵÑéϱ¨¾¯ÈÕÖ¾²Åɾ³ýÒ»¸öϵͳÊý¾ÝÎļþµÄ£¬ÔÚɾ³ýÎå·ÖÖÓǰÓб¸·Ý£¬ ºóÀ´ÔÙCP»ØÔÀ´ÄǸöÎļþ»¹ÊÇÌáʾÉÙ£» ÏÖÊý¾Ý¿âÖ»ÄÜ¿ªµ½mount µ½²»ÁËopen ÏÈshutdown immediate Êý¾ÝÎļþ¸´ÖƵ½ÔÀ´µÄÕý³£Î»Öà ȻºóÖØÐÂstartupÒýÓà ·¾¶Ã»Ê²Ã´ÎÊÌ⣬ÏÖÔÚÓÖÒ»¸öÎÊÌâÀ´ÁË£¡ »Ö¸´²»ÁËÄǸöÊý¾ÝÎļþÁË£¡ ÊÇÖ±½ÓCP¹ýÀ´Â𣿵«CP¹ýÀ´ºó»¹ÊÇ¿ª²»ÆðÀ´£¡ ÄÜÆðÀ´¾Í¹ÖÁË£¬ËäÈ»ÊÇ5·ÖÖÓÒÔǰµÄ£¬µ«ÊÇSCNÒѾ²»Ò»ÑùÁË¡£Ä㿪Æô¹éµµÁËÂð£¬Èç¹û¿ªÆôÁË£¬ÄÇ¿ÉÒÔ»Ö¸´µ½×îС£ ½øRMAN rman connect target / startup mount sql "alter database datafile 5 offline"; (oracle֮ǰ±¨´íʱ¿Ï¶¨¸ø³öÕâ¸ödatafileµÄ±àºÅÁË£¬ÎÒÕâ¼ÙÉèÊÇ5£© restore datafile 'c:\oracle\xxx.dbf'; recover datafile 5;(û¹éµµÕâÒ»²½¾Í×ö²»ÁËÁË£© sql "alter database datafile 5 online"; ÄãÊÔÊÔ°É¡£ restore datafile 'c:\oracle\xxx.dbf'; ÕâÀïµÄ·¾¶Ö¸
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......