ÈçºÎ´ÓÍêºÃµÄÊý¾ÝÎļþ»Ö¸´oracleÊý¾Ý¿â
Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
2£©
Cmd>sqlplus /nolog
Sql>conn as sysdba
Óû§Ãû£ºsystem
ÃÜÂ룺£¨´Ë´¦ÃÜÂëΪд´½¨Êý¾Ý¿âµÄÃÜÂ룩
Sql>shutdown immediate
Sql>startup nomount
Sql>alter database mount
´Ëʱ¿´Êý¾Ý¿âÊDz»ÊÇÄÜmountÆðÀ´£¬ÓÐʱ»áÌáʾûÓпÚÁîÎļþPWDdemo.oraÎļþÕÒ²»µ½¡£²é¿´¶ÔÓ¦µÄĿ¼£¨databaseÏ£©»á·¢ÏÖ¸ÃÎļþÊÇ´æÔڵġ£´ËʱÐèҪעÒ⣬¸Ã¿ÚÁîÎļþÊÇа²×°Êý¾Ý¿âºó´´½¨ÊµÀýʱÉú³ÉµÄ¿ÚÁîÎļþ£¬²»ÊÇÒÔÇ°ËùÓÃÊý¾Ý¿âµÄ¿ÚÁîÎļþ£¬¶øÏÖÔÚ£¬ÎÒÃÇÊÇÓÃÒÔÇ°Êý¾Ý¿âµÄ¿ØÖÆÎļþºÍÊý¾ÝÎļþÀ´´ò¿ªÒÔÇ°µÄÊý¾Ý¿â£¬ËùÒÔ´ËʱÐèÒªÖØд´½¨Ò»¸ö¿ÚÁîÎļþ¡£
Sql>shutdown immediate
Sql>host orapwd file=c£º\oracle9i\database\PWDdemo.ora password=oracle
Entries=10 £¨·ÅÔÚdatabase Ŀ¼Ï£©
Sql>startup nomount
Sql>alter database mount
Sql>alter database open
´ò¿ªÊý¾Ý¿â
2.Èç¹ûÐÂÊý¾Ý¿âµÄ°²×°Ä¿Â¼ºÍÔÓÐÊý¾Ý¿âµÄĿ¼²»Ò»Ñù£¬ÄÇô´Ëʱ¿ÉÒÔÖؽ¨¿ØÖÆÎļþÀ´´ò¿ªÊý¾Ý¿â¡£ÒòΪԿØÖÆÎļþÖмǼµÄÊý¾ÝÎļþµØÖ·ºÍÏÖÓеÄÊý¾ÝÎļþλÖò»Ò»Ñù¡£´ËʱºÍÏÂÃæµÚ¶þÖÐÇé¿öÒ»Ñù¡£µ±È»£¬´ËʱҲ¿ÉÒÔ´´½¨ºÍÔÊý¾Ý¿âÒ»ÑùµÄĿ¼½á¹¹£¨Ç°ÌáÊÇÒª¼ÇµÃÔÊý¾Ý¿âµÄĿ¼½á¹¹£©£¬ÐèҪעÒâµÄ¾ÍÊDzÎÊýÎļþÖмǼµÄ¿ØÖÆÎļþλÖúͿØÖÆÎļþÖмǼµÄÊý¾ÝÎļþλÖá£
˵Ã÷£ºÎÒÃÇÐèÒªÇå³þÊý¾Ý¿âÔÚ´ò¿ªµÄÈý¸ö½×¶ÎÖУ¬ÐèÒª¶ÁÈ¡µÄÎļþ
Sql>startup nomount £¨´Ëʱ¶ÁÈ¡²ÎÊýÎļþ£©
Sql>alter database mount £¨¸ù¾Ý²ÎÊýÎļþÖмǼµÄ¿ØÖÆÎļþµØÖ·£¬È¥¶ÁÈ¡¿ØÖÆÎļþ£©
Sql>alter database open £¨¸ù¾Ý¿ØÖÆÎļþÖмÇ
Ïà¹ØÎĵµ£º
Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......
Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
·ÖÅä´æ ......
1£¬Ê²Ã´ÊÇÓαꣿ
¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
¢Ú¹ØϵÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
&n ......
HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
Oracle Management ServerÅäÖò½ÖèÈçÏ£º
1¡¢Ê¹ÓÃenterprise manager configuration assistant½¨Á¢µµ°¸×ÊÁÏ¿â
ÆäÖпÉÑ¡Ôñн¨Ò»¸öÊý¾Ý¿âʵÀý»òÕßÔÚÒÑÓÐÊý¾Ý¿âʵÀýÖÐн¨×ÊÁϿ⣨н¨±í¿Õ¼ä£©¡£
2¡¢Æô¶¯management server
3¡¢ÔËÐÐenterprise manage console£¬Ñ¡ÔñµÇ¼µ½management server
µÇ ......