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

ORACLE Êý¾Ý¿â×Ô¶¯±¸·Ý½Å±¾

#! /bin/bash
if  [ -f ~/.bashrc ];then
. ~/.bash_profile
fi
export script=/home/oracle/script
export bakdata_destination=/u02/rman_backup/data
export baklog_destination=/u02/rman_backup/log
export datadir=`date +'%Y_%m_%d'`
export days=`date +'%w'`
if ! test -d $script
then
   mkdir -p $script
fi
if ! test -d $bakdata_destination
then
   mkdir -p $bakdata_destination
fi
if ! test -d $baklog_destination
then
   mkdir -p $baklog_destination
fi
if [ $days -eq 1 ];then
#create the directory for datafile
if ! test -e $baklog_destination/failedlog.txt
then
  touch $baklog_destination/failedlog.txt
fi
if [ $? = 0 ];then
  echo "you is the frist create the failed file"
fi
if ! test -e $baklog_destination/successful.txt
then
   touch $baklog_destination/successful.txt
fi
if [ $? = 0 ] ; then
  echo "you is the frist creat the successful file"
fi
if ! test -d $bakdata_destination/$datadir
then
   mkdir $bakdata_destination/$datadir
fi
if [ $? -eq 1 ]; then
 echo "Error :Cann't create the directory,please check the reason! ">>$baklog_destination/failedlog.txt
fi
echo run {                      >$script/rman_level0.rman
echo "backup incremental level 0 database filesperset = 7 format '"$bakdata_destination/$datadir/bak0_`date '+%Y_%m_%d_%H_%M_%S'`.bak"';"       >>$script/rman_level0.rman
echo "sql \"ALTER SYSTEM ARCHIVE LOG CURRENT\"; ">>$script/rman_level0.rman
echo backup  archivelog all delete input   >>$script/rman_level0.rmanecho "format '"$bakdata_destination/$datadir/arc0_`date '+%Y_%m_%d_%H_%M_%S'`.bak"';"                  >>$script/rman_level0.rman
echo }     &


Ïà¹ØÎĵµ£º

ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä

PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔ­Òò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øÊ¹Óá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......

oracle Ö®ËÄÁ½²¦Ç§½ï ÃîÕк¯Êý

1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
        select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
        select sys_context('userenv','ip_address') from dual; ......

oracleɾ³ý·þÎñ

°²×°oracleʱ£¬ÓÉÓÚ·´¸´°²×°Ð¶ÔØ£¬Óöµ½·þÎñûÓÐÐ¶ÔØ²»ÄܼÌÐø°²×°µÄÎÊÌ⣬´ÓÍøÉÏÕÒµ½ÁË×ÊÁÏ£¬Å¶ªÊ§ÔÚ´Ë×ªÔØÒ»Ï£¬ÄÚÈÝÈçÏÂ:
Èç¹ûÄãÒ²ºÍÎÒÒ»Ñù£¬Óù¤¾ß´´½¨ÁËÒ»¸ö·þÎñ£¬Ïëɾ³ýʱȴ·¢ÏÖɾ³ý²»µô¡£»òÕß°²×°ÁËDameWare Mini Remote ÒԺ󣨰üÀ¨×Ô¼º°²×°»òÕß»úÆ÷±»ºÚ£©ÔÚ·þÎñÀïÓÐÒ»¸ö“DameWare Mini Remote Control” ......

hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/ ......

oracleË÷ÒýµÄ¼à¿Ø

×î½üµÄÑо¿·¢ÏÖ Oracle Êý¾Ý¿âËùʹÓõÄË÷Òý´ÓÀ´Ã»Óдﵽ¹ý¿ÉÓÃË÷ÒýÊýµÄ1/4£¬
»òÕ߯äÓ÷¨ÓëÆä¿ªÊ¼Éè¼ÆµÄÒâͼ²»Ïàͬ¡£Î´ÓõÄË÷ÒýÀ˷ѿռ䣬¶øÇÒ»¹»á½µµÍ DML
µÄËÙ¶È£¬ÓÈÆäÊÇ UPDATE ºÍ INSERT Óï¾ä;¿ØÊý¾Ý¿âË÷ÒýµÄʹÓã¬ÊÍ·ÅÄÇЩδ±»Ê¹ÓÃ
µÄË÷Òý£¬´Ó¶ø½Úʡά»¤Ë÷ÒýµÄ¿ªÏú£¬ÓÅ»¯sqlÐÔÄÜ
ÔÚ Oracle9i ֮ǰ£¬¼à¿ØË÷ÒýʹÓõÄÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ