Oracle±í¿Õ¼ä»Ö¸´ÈÃÄã²»ÔÙµ£ÐÄÊý¾Ý¿â³öÏÖ´íÎó
ѧϰOracleʱ£¬Äã¿ÉÄÜ»áÓöµ½oracle±í¿Õ¼ä»Ö¸´ÎÊÌ⣬ÕâÀォ½éÉÜOracle±í¿Õ¼ä»Ö¸´ÎÊÌâµÄ½â¾ö·½·¨£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϡ£
Oracle±í¿Õ¼ä»Ö¸´·½°¸
Ò».Óû§±í¿Õ¼ä
´íÎó:
ÔÚÆô¶¯Êý¾Ý¿âʱ³öÏÖora-01157,ora-01110»ò²Ù×÷ϵͳ¼¶´íÎóÀýÈçora-07360, ÔڹرÕÊý¾Ý¿â(ʹÓÃshutdown normal»òshutdown immediate) ʱ½«µ¼Ö´íÎóora -01116,ora-01110ÒÔ¼°²Ù×÷ϵͳ¼¶´íÎóora-07368
ÒÔÏÂÓÐÁ½ÖÖ½â¾ö·½°¸:
1.Óû§µÄ±í¿Õ¼ä¿ÉÒÔ±»ÇáÒ×µØÖؽ¨ ¼´×î½üµ¼³öµÄ¶ÔÏóÊÇ¿ÉÓõĻò±í¿Õ¼äÖеĶÔÏó¿ÉÒÔ±»ÇáÒ×µØÖؽ¨µÈ.ÔÚ ÕâÖÖÇé¿öÏÂ,×î¼òµ¥µÄ·½·¨ÊÇoffline²¢É¾³ý¸ÃÊý¾ÝÎļþ,ɾ³ý±í¿Õ¼ä²¢ ÖØ½¨±í¿Õ¼äÒÔ¼°ËùÓеĶÔÏó.
svrmgrl> startup mount
svrmgrl> alter database datafile filename offline drop;
svrmgrl> alter database open;
svrmgrl> drop tablespace tablespace_name including contents;
ÖØ½¨±í¿Õ¼ä¼°ËùÓжÔÏó.
2.Óû§µÄ±í¿Õ¼ä²»Äܹ»±»ÇáÒ×µØÖؽ¨ÔÚ´ó¶àÊýÇé¿öÏÂ,ÖØ½¨±í¿Õ¼äÊDz»¿ÉÄܼ°Ì«ÐÁ¿àµÄ¹¤×÷.·½·¨Êǵ¹±¸·Ý¼°×ö½éÖʻָ´.Èç¹ûÄúµÄϵͳÔËÐÐÔÚnoarchivelogģʽÏÂ,ÔòÖ»ÓжªÊ§µÄÊý¾Ý ÔÚonline redo logÖз½¿É±»»Ö¸´¡£
²½ÖèÈçÏÂ:
1)restore the lost datafile from a backup
2)svrmgrl> startup mount
3)svrmgrl> select v1.group#,member,sequence#,first_change# > from v$log v1,v$logfile v2 > where v1.group#=v2.group#;
4)Èç¹ûÊý¾Ý¿âÔËÐÐÔÚnoarchivelogģʽÏÂÔò: svrmgrl> select file#,change# from v$recover_file;
Èç¹û change# ´óÓÚ×îСµÄfirst_change#ÔòÊý¾ÝÎļþ¿ÉÒÔ±»»Ö¸´¡£ Èç¹û change# СÓÚ×îСµÄfirst_change#ÔòÊý¾ÝÎļþ²»¿É»Ö¸´¡£ »Ö¸´×î½üÒ»´ÎµÄÈ«±¸·Ý»ò²ÉÓ÷½°¸Ò».
5)svrmgrl> recover datafile filename;
6)È·ÈÏOracle±í¿Õ¼ä»Ö¸´³É¹¦
7)svrmgrl> alter database open resetlogs;
3.Ö»¶Á±í¿Õ¼äÎÞÐè×ö½éÖʻָ´,Ö»Òª½«±¸·Ý»Ö¸´¼´¿É.ΨһµÄÀýÍâÊÇ:
±í¿Õ¼äÔÚ×îºóÒ»´Î±¸·Ýºó±»¸ÄΪread-write ģʽ
±í¿Õ¼äÔÚ×îºóÒ»´Î±¸·Ýºó±»¸ÄΪread-only ģʽ
ÔÚÕâÖÖÇé¿öÏÂ,¾ùÐè½øÐнéÖʻָ´
¶þ.ÁÙʱ±í¿Õ¼ä
ÁÙʱ±í¿Õ¼ä²¢²»°üº¬ÕæÕýµÄÊý¾Ý,»Ö¸´µÄ·½·¨ÊÇɾ³ýÁÙʱ±í¿Õ¼ä²¢Öؽ¨¼´¿É.
Èý.ϵͳ±í¿Õ¼ä
Èç¹û±¸·Ý²»¿ÉÓÃ,ÔòÖ»ÄܲÉÓÃÖØ½¨Êý¾Ý¿âµÄ·½·¨
ËÄ.»Ø¹ö±í¿Õ¼ä
ÓÐÁ½ÖÖÇé¿ö:
1¡¢Êý¾Ý¿âÒѾÍêÈ«¹Ø±Õ(ʹÓÃshutdown immediate»òshutdownÃüÁî)
1) È·ÈÏÊý¾Ý¿âÍêÈ«¹Ø±Õ
2) ÐÞ¸Äinit
Ïà¹ØÎĵµ£º
1. ͨ¹ýv$session£¬v$locked_object²é¿´ËËø¶¨ÁË×ÊÔ´
select t1.sid, t1.serial#, t1.username, t1.logon_time
from v$session t1 , v$locked_object t2
where t1.sid = t2.session_id
order by t1.logon_time
......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......
oracleÈçºÎ½«Êý¾Ýµ¼Èëµ½ÁíÒ»¸ö±í¿Õ¼ä
ij¸öÓû§µÄÊý¾ÝÔÚUSER±í¿Õ¼äÀÈç¹û¶à¸öÓû§µÄÊý¾Ý¶¼ÔÚUSERS±í¿Õ¼äÄÚ£¬½«ÑÏÖØÓ°ÏìϵͳÐÔÄÜ£¬Ò»°ãÔÚÏµÍ³Ç¨ÒÆµÄʱºò£¬ÔÚеÄϵͳÀïÏ£Íûµ¼ÈëÒ»¸ö¶ÀÁ¢µÄÓû§±í¿Õ¼ä£¬µ«ÊǾ³£ÎÞ·¨µ¼ÈëÓû§Ö¸¶¨µÄȱʡ±í¿Õ¼ä£¬Õâ¸öÎÊÌâ²úÉúµÄÔÒòÊÇÈç¹ûÒ»¸öÓû§ÓÐDBAµÄȨÏÞ£¬µ¼ÈëÊý¾Ýµ ......
ʹÓÃnulls first »òÕßnulls last Óï·¨
Nulls firstºÍnulls lastÊÇOracle Order byÖ§³ÖµÄÓï·¨
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls firstÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îǰ(²»¹ÜÊÇasc »¹ÊÇ desc)
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls lastÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îºó (²»¹ÜÊÇasc »¹ÊÇ desc)
ʹÓÃÓï·¨ÈçÏ£º
--½«nulls ......
ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëÔʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæÊµÏÖ¡£¾ßÌå ......