Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¹éµµÈÕÖ¾Îļþ

 ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSϰÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²» ......

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

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

ORACLE Êý¾Ý¿âÂß¼­±¸·Ý ¼òµ¥ EXP/IMP

 ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼­±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ