OracleÉ󼯹¦ÄÜ
OracleÉ󼯹¦ÄÜ
Éó¼ÆÊǶÔÑ¡¶¨µÄÓû§¶¯×÷µÄ¼à¿ØºÍ¼Ç¼£¬Í¨³£ÓÃÓÚ£º
u Éó²é¿ÉÒɵĻ¡£ÀýÈ磺Êý¾Ý±»·ÇÊÚȨÓû§Ëùɾ³ý£¬´Ëʱ°²È«¹ÜÀíÔ±¿É¾ö¶¨¶Ô¸Ã Êý¾Ý¿âµÄËùÓÐÁ¬½Ó½øÐÐÉ󼯣¬ÒÔ¼°¶ÔÊý¾Ý¿âµÄËùÓбíµÄ³É¹¦µØ»ò²»³É¹¦µØÉ¾³ý½øÐÐÉ󼯡£
u ¼àÊÓºÍÊÕ¼¯¹ØÓÚÖ¸¶¨Êý¾Ý¿â»î¶¯µÄÊý¾Ý¡£ÀýÈ磺DBA¿ÉÊÕ¼¯ÄÄЩ±»Ð޸ġ¢Ö´ÐÐÁ˶àÉÙ´ÎÂß¼µÄI/OµÈͳ¼ÆÊý¾Ý¡£
ORACLEÖ§³ÖÈýÖÖÉó¼ÆÀàÐÍ£º
u Óï¾äÉ󼯣¬¶ÔijÖÖÀàÐ͵ÄSQLÓï¾äÉ󼯣¬²»Ö¸¶¨½á¹¹»ò¶ÔÏó¡£
u ÌØÈ¨É󼯣¬¶ÔÖ´ÐÐÏàÓ¦¶¯×÷µÄÏµÍ³ÌØÈ¨µÄʹÓÃÉ󼯡£
u ¶ÔÏóÉ󼯣¬¶ÔÒ»ÌØÊâģʽ¶ÔÏóÉϵÄÖ¸¶¨Óï¾äµÄÉ󼯡£
ORACLEËùÔÊÐíµÄÉó¼ÆÑ¡ÔñÏÞÓÚÏÂÁз½Ã棺
u Éó¼ÆÓï¾äµÄ³É¹¦Ö´ÐС¢²»³É¹¦Ö´ÐУ¬»òÕ߯äÁ½Õß¡£
u ¶ÔÿһÓû§»á»°Éó¼ÆÓï¾äÖ´ÐÐÒ»´Î»òÕß¶ÔÓï¾äÿ´ÎÖ´ÐÐÉó¼ÆÒ»´Î¡£
u ¶ÔÈ«²¿Óû§»òÖ¸¶¨Óû§µÄ»î¶¯µÄÉ󼯡£
µ±Êý¾Ý¿âµÄÉó¼ÆÊÇʹÄܵģ¬ÔÚÓï¾äÖ´Ðн׶βúÉúÉ󼯼Ǽ¡£É󼯼Ǽ°üº¬ÓÐÉ󼯵IJÙ×÷¡¢Óû§Ö´ÐеIJÙ×÷¡¢²Ù×÷µÄÈÕÆÚºÍʱ¼äµÈÐÅÏ¢¡£É󼯼Ǽ¿É´æÔÚÊý¾Ý×Öµä±í£¨³ÆÎªÉ󼯼Ǽ£©»ò²Ù×÷ϵͳÉ󼯼ǼÖС£Êý¾Ý¿âÉ󼯼ǼÊÇÔÚSYSģʽµÄAUD$±íÖС£
ÉèÖÃORACLEÉó¼Æ
ÏÂÁв½Öè¿ÉÒÔÉèÖÃORACLEµÄÉ󼯹¦ÄÜ£º
1. Ð޸IJÎÊýÎļþ£¨init<sid>.ora£¬Èç¹ûʹÓ÷þÎñÆ÷²ÎÊýÎļþʹÓÃalter system set <parameter>=<value> scope=spfile|both£¬ÏêÇé²ÎÕÕ1.1½ÚÖйØÓÚ²ÎÊýÎļþµÄ½éÉÜ£©£¬ÉèÖà AUDIT_TRAIL²ÎÊý£¬²¢ÇÒÖØÆôÊý¾Ý¿â¡£AUDIT_TRAILµÄȡֵÈçÏ£º
l DB/TRUE£ºÆô¶¯É󼯹¦ÄÜ£¬²¢ÇÒ°ÑÉ󼯽á¹û´æ·ÅÔÚÊý¾Ý¿âµÄ SYS.AUD$ ±íÖÐ
l OS£ºÆô¶¯É󼯹¦ÄÜ£¬²¢°ÑÉ󼯽á¹û´æ·ÅÔÚ²Ù×÷ϵͳµÄÉó¼ÆÐÅÏ¢ÖÐ
l DB_EXTENDED£º¾ßÓÐDB/TRUEµÄ¹¦ÄÜ£¬ÁíÍâÌîдAUD$µÄSQLBINDºÍSQLTEXT×Ö¶Î
l &n
Ïà¹ØÎĵµ£º
ÎÒ¶ÔORACLE BI µÄETLµÄһЩ×ܽᣨԣ© ÊÕ²Ø
http://blog.chinaunix.net/u/25176/showart_2036107.html
Êý¾Ý²Ö¿âÖеÄETLÏêϸµÄ·ÖΪËĸö½×¶Î£ºÌáÈ¡£¬´«Ê䣬ת»»£¬×°ÔØ¡£ÎÒÏȼòµ¥µÄ½éÉÜÒ»ÏÂÌáÈ¡ºÍ´«ÊäµÄ·ÖÀàºÍ·½·¨£º
Ò»£ºÌáÈ¡
ÌáÈ¡¿ÉÒÔ·ÖΪÂß¼ÌáÈ¡£¬ºÍÎïÀíÌáÈ¡¡£
1£ºÂß¼ÌáÈ¡°´ÕÕ¹æÄ£·ÖΪ£ºÍ ......
Ò»°ãÊý¾Ý¿âÖÐʱ¼äµÄ¸ñʽΪDATEÀàÐÍ£¬¶øÎÒÃÇ´ÓÒ³ÃæÖлñÈ¡µÄʱ¼äÍùÍùΪStringÀàÐÍ£¬Õâ¸ö¾ÍÐèÒªÀàÐ͵Äת»»¡£Ò»°ãÎÒÃÇ»áͨ¹ýµ÷Óà Java.text.SimpleDateFormat JAVAÀàÀ´¶ÔÆä½øÐÐת»»¡£Õâ¸öJAVAÀàÖÐÎÒÃǾ³£Óõ½µÄ·½·¨ÓÐÁ½¸ö£¬Ò»¸öÊÇformat(½«Ê±¼ä¸ñʽµÄÊý¾Ýת»»³ÉStringÀàÐÍ)£¬ÁíÒ»¸ö¾ÍÊÇ parse(½«StringÀàÐÍת»»³ÉDATEÀàÐÍ)¡£ÎÒ ......
oracleµÄµ¼Èëµ¼³öÃüÁîÖ±½ÓÓÃcmd¾Í¿ÉÒÔÍê³É£¬µ¼³öµÄÎļþµØÖ·¾ÍÊÇcmdµÄµØÖ·£¬cmdµÄÔʼµØÖ·¿ÉÒԸģ¬ÔËÐÐcd ..Í˻ص½Éϼ¶Ä¿Â¼ cd¿Õ¸ñ¼ÓĿ¼Ãû Êǵ½Ï¼¶Ä¿Â¼ ÊäÈëD£º»Ø³µ¾Í¿ÉÒÔÖ±½Óµ½dÅÌ
exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÐèÒª±£´æµÄÎļþ.dmp tables=£¨A±í,B±í....£© log=ÈÕÖ¾.log
exp jjeto_eim_user/jjetoeimuser@EIM ......