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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracleÖеÄtz_offsetÊÇÓÃÀ´·µ»Ø¸ø¶¨Ê±ÇøÓë±ê×¼Ê±Çø(UTC universal of time Coordinate ͨÓÃʱ¼ä×ø±ê)µÄÆ«ÒÆÁ¿£¬Æä²ÎÊý¿ÉÒÔÊÇ£º
1.Ò»¸öºÏ·¨µÄÊ±ÇøÃû
2.Ò»¸öÀëUTCµÄ±ê×¼Æ«ÒÆÁ¿
3.¹Ø¼ü×ÖSessionTimeZone»òÕßÊÇDB_timezone
ÆäÖкϷ¨µÄÊ±ÇøÃû¿ÉÒÔ´ÓϵͳÊÓͼV$TimeZone_namesÖеÄÁÐTZnameÖеĵõ½£º
TZNAME
— ......
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')
......
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 ......