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

OracleÃüÁî1

 OracleÃüÁîÈ«¼¯
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
µÚ¶þÕ£º±í¿Õ¼ä¹ÜÀí
µÚÈýÕ£º±í
µÚËÄÕ£ºË÷Òý
µÚÎåÕ£ºÔ¼Êø
µÚÁùÕ£ºLOADÊý¾Ý
µÚÆßÕ£ºreorganizing data
µÚ°ËÕ£º managing password security and resources
µÚ¾ÅÕ£ºManaging users
µÚʮգºmanaging privileges
µÚʮһÕ£º manager role
µÚÊ®¶þÕÂ: BACKUP and RECOVERY
OracleÃüÁîÈ«¼¯
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
1.forcing log switches
    sql> alter system switch logfile;
    2.forcing checkpoints
    sql> alter system checkpoint;
    3.adding online redo log groups
    sql> alter database add logfile [group 4]
    sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;
    4.adding online redo log members
    sql> alter database add logfile member
    sql> '/disk3/log1b.rdo' to group 1,
    sql> '/disk4/log2b.rdo' to group 2;
    5.changes the name of the online redo logfile
    sql> alter database rename file 'c:/oracle/oradata/oradb/redo01.log'
    sql> to 'c:/oracle/oradata/redo01.log';
    6.drop online redo log groups
    sql> alter database drop logfile group 3;
    7.drop online redo log members
    sql> alter database drop logfile member 'c:/oracle/oradata/redo01.log';
    8.clearing online redo log files
    sql> alter database clear [unarchived] logfile 'c:/oracle/log2a.rdo';
    9.using logminer analyzing redo logfiles
    a. in the init.ora specify utl_file_dir = ' '
    b. sql> execute dbms_logmnr_d.build('oradb.ora','c:oracleoradblog');
    c. sql> execute dbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',
    sql> dbms_logmnr.new);
    d. sql> execute dbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',
    sql> dbms_logmnr.addfile);
    e. sql> execute dbms_logmnr.start_


Ïà¹ØÎĵµ£º

OracleµÄOpenWorld:ÁªÊÖSun¶ÔÕ½IBM

 ½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£­15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾ­À­¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......

¹ØÓÚOracle 01122,01110,01207µÄ´íÎóºÍ½â¾ö

 Ô­´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕÇ¨ÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈϰ²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......

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

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

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

2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
     OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
     Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......

oracle management server£¨oms£©Æô¶¯ÎÊÌâ

 
      ÅäÖÃÒ»¸ö¹ÜÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools/Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄoracle management server/´´½¨Ò»¸öеÄ×ÊÁϿ⵵°¸/µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æ¹ÜÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ