oracle±í·ÖÇøÏê½â
http://tianzt.blog.51cto.com/459544/171759
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3.±í·ÖÇøµÄÓÅȱµã
4.±í·ÖÇøµÄ¼¸ÖÖÀàÐͼ°²Ù×÷·½·¨
5.¶Ô±í·ÖÇøµÄά»¤ÐÔ²Ù×÷.
(1.) ±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
±í¿Õ¼ä£º
¡¡¡¡ÊÇÒ»¸ö»ò¶à¸öÊý¾ÝÎļþµÄ¼¯ºÏ£¬ËùÓеÄÊý¾Ý¶ÔÏ󶼴æ·ÅÔÚÖ¸¶¨µÄ±í¿Õ¼äÖУ¬µ«Ö÷Òª´æ·ÅµÄÊÇ±í£¬ ËùÒÔ³Æ×÷±í¿Õ¼ä¡£
·ÖÇø±í£º
µ±±íÖеÄÊý¾ÝÁ¿²»¶ÏÔö´ó£¬²éѯÊý¾ÝµÄËٶȾͻá±äÂý£¬Ó¦ÓóÌÐòµÄÐÔÄܾͻáϽµ£¬Õâʱ¾ÍÓ¦¸Ã¿¼ÂǶԱí½øÐзÖÇø¡£±í½øÐзÖÇøºó£¬Âß¼ÉϱíÈÔÈ»ÊÇÒ»ÕÅÍêÕûµÄ±í£¬Ö»Êǽ«±íÖеÄÊý¾ÝÔÚÎïÀíÉÏ´æ·Åµ½¶à¸ö±í¿Õ¼ä(ÎïÀíÎļþÉÏ)£¬ÕâÑù²éѯÊý¾Ýʱ£¬²»ÖÁÓÚÿ´Î¶¼É¨ÃèÕûÕÅ±í¡£
( 2).±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
OracleµÄ±í·ÖÇø¹¦ÄÜͨ¹ý¸ÄÉƿɹÜÀíÐÔ¡¢ÐÔÄܺͿÉÓÃÐÔ£¬´Ó¶øΪ¸÷ʽӦÓóÌÐò´øÀ´Á˼«´óµÄºÃ´¦¡£Í¨³££¬·ÖÇø¿ÉÒÔʹijЩ²éѯÒÔ¼°Î¬»¤²Ù×÷µÄÐÔÄÜ´ó´óÌá¸ß¡£´ËÍâ,·ÖÇø»¹¿ÉÒÔ¼«´ó¼ò»¯³£¼ûµÄ¹ÜÀíÈÎÎñ£¬·ÖÇøÊǹ¹½¨Ç§Õ××Ö½ÚÊý¾Ýϵͳ»ò³¬¸ß¿ÉÓÃÐÔϵͳµÄ¹Ø¼ü¹¤¾ß¡£
·ÖÇø¹¦ÄÜÄܹ»½«±í¡¢Ë÷Òý»òË÷Òý×éÖ¯±í½øÒ»²½Ï¸·ÖΪ¶Î£¬ÕâЩÊý¾Ý¿â¶ÔÏóµÄ¶Î½Ð×ö·ÖÇø¡£Ã¿¸ö·ÖÇøÓÐ×Ô¼ºµÄÃû³Æ£¬»¹¿ÉÒÔÑ¡Ôñ×Ô¼ºµÄ´æ´¢ÌØÐÔ¡£´ÓÊý¾Ý¿â¹ÜÀíÔ±µÄ½Ç¶ÈÀ´¿´£¬Ò»¸ö·ÖÇøºóµÄ¶ÔÏó¾ßÓжà¸ö¶Î£¬ÕâЩ¶Î¼È¿É½øÐм¯Ìå¹ÜÀí£¬Ò²¿Éµ¥¶À¹ÜÀí£¬Õâ¾ÍʹÊý¾Ý¿â¹ÜÀíÔ±ÔÚ¹ÜÀí·ÖÇøºóµÄ¶ÔÏóʱÓÐÏ൱´óµÄÁé»îÐÔ¡£µ«ÊÇ£¬´ÓÓ¦ÓóÌÐòµÄ½Ç¶ÈÀ´¿´£¬·ÖÇøºóµÄ±íÓë·Ç·ÖÇø±íÍêÈ«Ïàͬ£¬Ê¹Óà SQL DML ÃüÁî·ÃÎÊ·ÖÇøºóµÄ±íʱ£¬ÎÞÐèÈκÎÐ޸ġ£
ʲôʱºòʹÓ÷ÖÇø±í£º
1¡¢±íµÄ´óС³¬¹ý2GB¡£
2¡¢±íÖаüº¬ÀúÊ·Êý¾Ý£¬ÐµÄÊý¾Ý±»Ôö¼Ó¶¼ÐµķÖÇøÖС£
(3).±í·ÖÇøµÄÓÅȱµã
±í·ÖÇøÓÐÒÔÏÂÓŵ㣺
1¡¢¸ÄÉƲéѯÐÔÄÜ£º¶Ô·ÖÇø¶ÔÏóµÄ²éѯ¿ÉÒÔ½öËÑË÷×Ô¼º¹ØÐĵķÖÇø£¬Ìá¸ß¼ìË÷Ëٶȡ£
2¡¢ÔöÇ¿¿ÉÓÃÐÔ£ºÈç¹û±íµÄij¸ö·ÖÇø³öÏÖ¹ÊÕÏ£¬±íÔÚÆäËû·ÖÇøµÄÊý¾ÝÈÔÈ»¿ÉÓã»
3¡¢Î¬»¤·½±ã£ºÈç¹û±íµÄij¸ö·ÖÇø³öÏÖ¹ÊÕÏ£¬ÐèÒªÐÞ¸´Êý¾Ý£¬Ö»ÐÞ¸´¸Ã·ÖÇø¼´¿É£»
4¡¢¾ùºâI/O£º¿ÉÒ԰Ѳ»Í¬µÄ·ÖÇøÓ³Éäµ½´ÅÅÌÒÔƽºâI/O£¬¸ÄÉÆÕû¸öϵͳÐÔÄÜ¡£
ȱµã£º
·ÖÇø±íÏà¹Ø£ºÒѾ´æÔڵıíûÓз½
Ïà¹ØÎĵµ£º
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
&nb ......
£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅä¸øÓû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create sess ......
ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬ÔÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öĿ¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......
ÏÞÖÆ¿ØÖÆÎļþµÄ´óС
a.)²éѯ¿É¸´Óò¿·ÖµÄ±£´æÌìÊý(²»ÄÜÖ±½Ó¿ØÖÆ´óС,±£´æÌìÊýÔ½´óÊý¾ÝÔ½¶à)
SELECT name,value from v$parameter WHERE name = 'control_file_record_keep_time';
b.)ÉèÖÿɸ´Óò¿·Ö±£´æʱ¼ä
ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME = 14;
......