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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
½ñÌì·¢ÏÖ×Ô¼ºÌ¨Ê½»úÉϵÄORACLEÓÐÎÊÌ⣬´òËãÖØ×°Ò»Ï£¬·¢ÏÖÕû¸öORACLEĿ¼ɾ³ý£¬±¨OCI.DLLÎÞ·¨É¾³ý´íÎó£¬Ñо¿ÁËһϣ¬
·¢ÏֹصôMSDTC·þÎñ¾Í¿ÉÒÔÁË£¬MSDTC·þÎñÔÚϵͳÖеķþÎñÃûΪ
Distributed T ......
ORACLEÊý¾Ý¿âÄÚ´æ²ÎÊýÉè´óÓÚ8GµÄÄÚ´æÆô¶¯³ö´íÎÊÌâ½â¾ö
4¸öINTEL 1.6g 4ºËCPU£¬16G Äڴ棬°²×°ÍêORACLE 10G FOR RED HAT LINUX£64UPDATA4X86-64 ×¼±¸µ¼Êý¾Ý½øÈ¥£¬Ë³ÊÖÐÞ¸ÄÁ˼¸¸ö²ÎÊý¡£
alter system set sga_max_size=11g scope=spfile;
alter system set sga_target=11g scope=spfile ......
ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëÔʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæÊµÏÖ¡£¾ßÌå ......