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

oracleÊý¾Ý±¸·Ý

/// <summary>  
        /// Êý¾Ý¿â±¸·Ý  
        /// </summary>  
        /// <param name="fileName">dmpÎļþÃû³Æ</param>  
        /// <param name="logFileName">logÎļþÃû³Æ</param>  
        /// <returns>true:±¸·Ý³É¹¦;false:±¸·Ýʧ°Ü</returns>  
        public static bool DBBackup(string dmpFileName, string logFileName)  
        {  
            // ·µ»ØÖµ  
            bool result = false;  
            // ±¸·ÝÃüÁî,´ÓxmlÎļþÖлñÈ¡ "/c EXP Óû§Ãû/ÃÜÂë@Êý¾Ý¿â·þÎñÃû FULL=Y INCTYPE=COMPLETE "  
            string backupCmd = MsgXml.GetConfig(XMLKey.BackupCommand.ToString());  
            // cmdÖÐÊäÈëµÄ²ÎÊýÄÚÈÝ  
            string arg = backupCmd + " FILE= " + dmpFileName + " LOG= " + logFileName;  
 
            try 
            {  
                // Èç¹ûdmpÎļþ²»´æÔÚ£¬´´½¨Îļþ²¢ÊÍ·Å  
                if (!File.Exists(dmpFileName))  
         &


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

Oracle Ê±ÇøÎÊÌâ

oracleÖеÄtz_offsetÊÇÓÃÀ´·µ»Ø¸ø¶¨Ê±ÇøÓë±ê×¼Ê±Çø(UTC universal of time Coordinate ͨÓÃʱ¼ä×ø±ê)µÄÆ«ÒÆÁ¿£¬Æä²ÎÊý¿ÉÒÔÊÇ£º
1.Ò»¸öºÏ·¨µÄÊ±ÇøÃû
2.Ò»¸öÀëUTCµÄ±ê×¼Æ«ÒÆÁ¿
3.¹Ø¼ü×ÖSessionTimeZone»òÕßÊÇDB_timezone
 
ÆäÖкϷ¨µÄÊ±ÇøÃû¿ÉÒÔ´ÓϵͳÊÓͼV$TimeZone_namesÖеÄÁÐTZnameÖеĵõ½£º
TZNAME
— ......

oracle ͳ¼ÆÃ¿ÔÂÀÛ»ý¹ºÂòÈËÊý

oracle ¿ÉÓÐʲô·½·¨ ͳ¼ÆÃ¿ÔÂÀÛ»ý¹ºÂòÈËÊý
±ÈÈç˵ÓиöÃŵê 2008Ä깺ÂòÉÌÆ·µÄÈËÊý
±í:t_buy_log  ×Ö¶Î f_username Óû§Ãû³Æ;¹ºÂòʱ¼äf_buytime

1 Èç¹ûÊÇͳ¼ÆÃ¿Ô¹ºÂòÈËÊý
select to_char(f_buytime,'yyymm'),count(distinct f_username)
from t_buy_log
group by to_char(f_buytime,'yyymm')
......

Oracle ±í¿Õ¼ä»ù±¾²Ù×÷

1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M;
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ