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

ORACLE°²×°Ö®ºóµÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·

2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
     OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
     Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´´½¨×ÊÁϵµ°¸¿â£¬ÔÚʹÓÃOracle Management Serverʱ½«»á³öÏÖÈçÏ´íÎó:
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
»òÕß
VTK-1000£ºÎÞ·¨Á¬½Óµ½Management server¡£ÇëÑéÖ¤ÄúÒÑÊäÈëOracle Management ServerµÄÕýÈ·Ö÷»úÃûºÍ״̬¡£
 
Òò´Ë£¬±ØÐëÏÈ´´½¨Oracle Enterprise Manager×ÊÁϵµ°¸¿â,ÒÔ±ãÄÜÁ¬½Óµ½Oracle Management Server¡£´´½¨Oracle Manager Server×ÊÁϵµ°¸¿âµÄ²½Ö裺
1¡¢“¿ªÊ¼→³ÌÐò→Oracle→OraHome92→Configuration and Migration”£¬Ê¹ÓÃÆäÖеēEnterprise Manager Configuration Assistant”³ÌÐòÅäÖñ¾»úµÄOracle Management Server£¬´´½¨Ò»¸öеĵµ°¸×ÊÁϿ⡣
2¡¢µÇ¼Oracle Management Server
     ½¨Á¢Íê×ÊÁϵµ°¸¿âºó£¬¾Í¿ÉÒÔʹÓÃOEMÁË¡£Çë°´ÈçϲÙ×÷½øÐУº
    “¿ªÊ¼→³ÌÐò→Oracle→OraHome92→Enterprise Manager Console”,µÇ¼·½Ê½²»Ñ¡Ôñ¶ÀÁ¢Æô¶¯£¬ÒªÑ¡ÔñµÇ¼µ½Oracle   Management Server¡£¼¤»îOracle Enterprise Manager ConsoleµÄµÇ¼´°¿Úºó£¬Ôڸô°¿ÚÖÐÓû§ÒªÌṩÏàÓ¦µÄ¹ÜÀíÔ±Ãû³Æ¡¢¿ÚÁîºÍManagement Server¡£Enterprise ManagerÓÐһĬÈϹÜÀíÔ±sysman,¿ÚÁîΪoem_temp£¬Management ServerÇëÌîдÖ÷»úÃû»ò¼ÆËã»úIPµØÖ·¡£
3¡¢µÇ¼³É¹¦ºó£¬OracleÌáʾ¸ü¸ÄsysmanÓû§¿ÚÁî¡£Èç¹ûµÇ¼²»³É¹¦£¬Çë¼ì²éÔÚ¿ØÖÆÃæ°åÖГ·þÎñ”ÖÐOracle Management Server·þÎñÊÇ·ñÒÑÆô¶¯,ÈçδÆô¶¯ÇëÊÖ¶¯Æô¶¯¡£
    
 
4¡¢Á¬½Óµ½Òª²Ù×÷µÄÊý¾Ý¿â
     ÔÚOEM×ó²àµÄĿ¼Ê÷ÖУ¬µ¥»÷Òª±¸·ÝµÄÊý¾Ý¿âÃû£¬ÔÚËæºó³öÏֵĵǼ¿òÖÐÊäÈëÕýÈ·µÄÓû§Ãû¡¢¿ÚÁî¼°Á¬½ÓÉí·Ý£¬´Ëʱ¸ÃÊý¾Ý¿âÒÑÓë¹ÜÀí·þÎñÆ÷Á¬½Ó¡£
5¡¢½¨Á¢Ê×Ñ¡Éí·ÝÖ¤Ã÷
     Ê×Ñ¡Éí·ÝÖ¤Ã÷µÄ×÷ÓÃÊÇÅäÖÃÒ»¸öÊý¾Ý¿âÓû§Ö´ÐÐÊý¾Ý¿âά»¤²Ù×÷£¬ÔÚ¶ÔÊý¾Ý¿â½øÐб¸·ÝÓë»Ö¸´µÈ²Ù×÷µÄ¹ý³ÌÖУ¬Óû§²»±ØÊäÈëÓû§¼°¿ÚÁî¡£ÔÚOEMÖдò¿ªÅäÖò˵¥£¬Ñ¡Ôñ“Ê×Ñ¡Éí·ÝÖ¤Ã÷”Ñ¡Ï´ò¿ª“±à¼­¹ÜÀíÔ±Ê×Ñ¡Ïî&r


Ïà¹ØÎĵµ£º

Windows Oracle 10GÊÖ¹¤´´½¨Êý¾Ý¿â

ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃæ¹¤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......

Oracle Rman¿çresetlogs°æ±¾»Ö¸´

RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......

OracleÍⲿ±íСÀý

1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øÏ½µ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ