Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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'; ÕâÀïµÄ·¾¶Ö¸


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ