Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

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 ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ