Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨6£©£º¹ÜÀíOracle´æ´¢½á¹¹

Ò»¡¢»ù±¾µÄOracle´æ´¢½á¹¹£º±í¿Õ¼äÓëÊý¾ÝÎļþ
OracleÊý¾Ý¿âÖоßÓÐÁ½ÖÖÀàÐ͵Ĵ洢£ºÎïÀí´æ´¢ºÍÂß¼­´æ´¢¡£
ÉÏÃæµÄOracle´æ´¢½á¹¹Ä£ÐÍÖУ¬¿ÉÒÔ¿´³öÏÂÁÐÒªËØ£º
ÿ¸öÊý¾Ý¿â£¨Database£©¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¨Tablespace£©×é³É¡£Ã¿¸ö±í¿Õ¼ä¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÊý¾Ý¿â¡£
ÿ¸ö±í¿Õ¼ä¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öÊý¾ÝÎļþ£¨Datafile£©×é³É¡£Ã¿¸öÊý¾ÝÎļþ¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸ö±í¿Õ¼ä¡£
ÿ¸öÊý¾ÝÎļþ¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö²Ù×÷ϵͳ¿é£¨Operation System Block£©×é³É¡£Ã¿¸ö²Ù×÷ϵͳ¿é¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÊý¾ÝÎļþ¡£
ÿ¸ö±í¿Õ¼ä¶¼¿ÉÒÔ°üº¬Ò»¸ö»ò¶à¸ö¶Î£¨Segment£©¡£Ã¿¸ö¶Î¶¼±ØÐë´æÔÚ²¢ÇÒÖ»ÄÜ´æÔÚÓÚÒ»¸ö±í¿Õ¼äÄÚ¡£
ÿ¸ö¶Î¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öÇø¼ä£¨Extent£©×é³É¡£Ã¿¸öÇø¼ä¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸ö¶Î¡£
ÿ¸öÇø¼ä¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸öOracleÊý¾Ý¿é£¨Oracle Block£©×é³É¡£Ã¿¸öOracleÊý¾Ý¿é¶¼±ØÐëÊôÓÚ²¢ÇÒÖ»ÊôÓÚÒ»¸öÇø¼ä¡£
ÿ¸öÇø¼ä¶¼±ØÐë±»¶¨Î»²¢ÇÒÖ»Äܶ¨Î»ÔÚÒ»¸öÊý¾ÝÎļþÄÚ¡£Êý¾ÝÎļþÖеĿռä¿ÉÒÔ±»·ÖÅäΪһ¸ö»ò¶à¸öÇø¼ä¡£
ÿ¸öOracleÊý¾Ý¿é¶¼±ØÐëÓÉÒ»¸ö»ò¶à¸ö²Ù×÷ϵͳ¿é×é³É¡£Ã¿¸ö²Ù×÷ϵͳ¿é¶¼¿ÉÒÔÊDz¢ÇÒÖ»ÄÜÊÇÒ»¸öOracleÊý¾Ý¿éµÄ²¿·Ö¡£
1¡¢ÎïÀí´æ´¢½á¹¹
ÎïÀí½á¹¹ÊDzÙ×÷ϵͳ²Ù×÷OracleÊý¾Ý¿âʱÄܹ»¿´¼ûµÄ½á¹¹¡£
1.1¡¢OracleÊý¾ÝÎļþ
Êý¾ÝÎļþÓÉÏÂÁÐ3²¿·Ö×é³É£ºÍ·²¿¡¢Çø¼ä£¨ÒÑ·ÖÅäµÄ¿Õ¼ä£©ÒÔ¼°¿ÕÏпռ䣨δ·ÖÅäµÄ¿Õ¼ä£©¡£
 
Êý¾ÝÎļþµÄÍ·²¿£¨Header£©½«Æä±êʶΪÊý¾Ý¿âµÄÒ»²¿·Ö£¬²¢ÇÒ´æ´¢Á˸ÃÊý¾ÝÎļþµÄϸ½Ú£¬Ï¸½Ú°üÀ¨Êý¾ÝÎļþËùÊôµÄ±í¿Õ¼äÒÔ¼°×îºóÖ´Ðеļì²éµã¡£ÕâÑù£¬Oracle¾ÍÄܹ»ÔÚÆô¶¯Ê±¼ì²éËùÓÐÏà¹ØÎļþÊÇ·ñͬ²½¡£Êý¾ÝÎļþµÄÊ£Óಿ·ÖÓÉÇø¼äºÍ¿ÕÏпռä×é³É£¬Í¨¹ý´´½¨¡¢É¾³ýºÍ¸ü¸ÄOracleµÄ¶Î£¨Segment£©Âß¼­´æ´¢×é¼þ¾Í¿ÉÒÔ¶ÔÕâЩʣÓಿ·Ö½øÐйÜÀí¡£
ÿ¸öOracleÊý¾ÝÎļþ¶¼Ö»ÊôÓÚÒ»¸ö±í¿Õ¼ä¡£
1.2¡¢²Ù×÷ϵͳ¿é
²Ù×÷ϵͳ¿é£¨Operating System Block£©ÊÇÎļþϵͳËùʹÓõÄ×îС·ÖÅäµ¥Ôª¡£
2¡¢Âß¼­´æ´¢½á¹¹
2.1¡¢±í¿Õ¼ä
ÔÚÊý¾Ý¿âÖУ¬±í¿Õ¼äÊÇ×î´óµÄ´æ´¢½á¹¹¡£ÔÚOracle 10G°æ±¾ÖУ¬Êý¾Ý¿âÖÁÉÙ¾ßÓÐÏÂÁÐ3¸ö±í¿Õ¼ä£ºSYSTEM¡¢SYSAUXÒÔ¼°Ò»¸ö³·Ïú±í¿Õ¼ä¡£
ÔÚOracleÖд´½¨Ò»¸öÓû§Ê±£¬ÐèÒªÖ¸¶¨Ä¬Èϵıí¿Õ¼ä£¬Õâ¸öĬÈϵıí¿Õ¼äÄܹ»´æ´¢ÓÃÓÚ¸ÃÓû§´´½¨µÄËùÓжεÄÇø¼ä¡£¾¡¹Ü×îºÃʹÓÃΪÊý¾Ý¿â¶¨ÒåµÄÈ«¾ÖÁÙʱ±í¿Õ¼ä£¬µ«»¹ÊÇ¿ÉÒÔ´´½¨Ò»¸ö´æ´¢ÁÙʱ¶ÎµÄÁÙʱ±í¿Õ¼ä¡£
ËùÓÐÓû§¹²ÏíDBAËùÉèÖõij·Ïú±í¿Õ¼ä¡£²é¿´Óû§µÄĬÈϱí¿Õ¼äºÍÁÙʱ±í¿Õ¼ä£¬ÎÒÃÇ


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÃÜÂëÎļþµÄ´´½¨£º

¡¡¡¡ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME\DATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪPWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´¡¡£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽ ......

Oracleʱ¼äÈÕÆÚ²Ù×÷

Oracleʱ¼äÈÕÆÚ²Ù×÷
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
sysdate+5/24 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
sysdate+5 ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
add_months(sysdate,-5) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
add_months(sysdate,-5*12) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
ÉÏÔÂÄ©µÄÈÕÆÚ£ºsel ......

OracleÊý¾Ý¿âÃÜÂëÎļþµÄά»¤£º

1. ²é¿´ÃÜÂëÎļþÖеijÉÔ±£º
¿ÉÒÔͨ¹ý²éѯÊÓͼV$PWFILE_USERSÀ´»ñȡӵÓÐSYSOPER/SYSDBAϵͳȨÏÞµÄÓû§µÄÐÅÏ¢£¬±íÖÐSYSOPER/SYSDBAÁеÄȡֵTRUE/FALSE±íʾ´ËÓû§ÊÇ·ñÓµÓÐÏàÓ¦µÄȨÏÞ¡£ÕâЩÓû§Ò²¾ÍÊÇÏàÓ¦µØ´æÔÚÓÚÃÜÂëÎļþÖеijÉÔ±¡£
2. À©Õ¹ÃÜÂëÎļþµÄÓû§ÊýÁ¿£º
µ±ÏòOracleÊý¾Ý¿âÃÜÂëÎļþÌí¼ÓµÄÕʺÅÊýÄ¿³¬¹ý´´½¨ÃÜÂëÎļþʱ ......

oracle Êý¾Ý¿â´´½¨DBLink Óï·¨

-- Drop existing database link drop database link DL_name
-- Create database link create database link DL_name connect to username identified by userpwd using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ipaddress)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)))'; ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨1£©

¸Ð¾õÕâ¸ö»¹ÊÇ·Ö¿ªÐ´ºÃÁË£¬Êý¾Ý¿âµÄ´´½¨¹¤×÷£¬Ô­ÒÔΪºÃÈÝÒ×¾ÍÊÇÏÂÒ»²½ÏÂÒ»²½µÄÎÊÌ⣬ԭÀ´ÀïÃæµÄÄÚÈÝ»¹ÊǺܶàµÄ£¬°üÀ¨Ìåϵ½á¹¹ÒªÁ˽âһЩ£¬DBCA½¨¿âÊÇÈÝÒ×À­£¬²»¹ýÒª»áÊÖ¶¯½¨¿âÄDzŽпáÂÄøö½çÃæµãÏÂÒ»²½ÏÂÒ»²½Ë­²»»á°¡£¬ÄÇ»¹½ÐDBA°¡£¿ºÇºÇ¡£
Oracle·þÎñÆ÷ÓÉÏÂÁÐÁ½¸öʵÌå×é³É£ºÊµÀý£¨Instance£©ÓëÊý¾Ý¿â¡£ÊµÀýÓÉ´æ´¢½á¹¹º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ