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

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

¡¾×ª¡¿OracleÐÔÄܵ÷ÕûµÄÎóÇø

OracleÐÔÄܵ÷ÕûµÄÎóÇø
http://tech.it168.com/db/o/2006-07-03/200607031305157.shtml
ΪÁËÌá¸ßÐÔÄÜ,ÎÒÃÇÕë¶ÔOracleÊý¾Ý¿â±¾ÉíÌṩÁ˵ķ½·¨»ò·½°¸½øÐйý²»Éٵij¢ÊÔ£¬Ö÷Òª°üÀ¨:
    ¹²Ïí·þÎñÆ÷ģʽ(MTS)
    ¼¯Èº¼¼Êõ(Clustering)RAC
    ·ÖÇø
    ²¢ÐÐ ......

OracleËæ»úÈ¡Êý¾ÝµÄ3ÖÖ·½Ê½

µÚÒ»ÖÖ£º
select * from SOME_TABLE sample(1) where rownum <= 10;
µÚ¶þÖÖ£º
select * from (select * from SOME_TABLE order by dbms_random.value) where rownum<=10;
µÚÈýÖÖ£º
select * from (select * from SOME_TABLE order by sys_guid()) where rownum <= 10; ......

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¡£Sysdate µ±Ç°È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ