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 } &
Ïà¹ØÎĵµ£º
LogMinerÌṩÁËÒ»¸ö´¦ÀíÖØ×öÈÕÖ¾Îļþ²¢½«ÆäÄÚÈÝ·Òë³É´ú±í¶ÔÊý¾Ý¿âµÄÂß¼²Ù×÷µÄSQLÓï¾äµÄ¹ý³Ì¡£LogMinerÔËÐÐÔÚOracle°æ±¾8.1»òÕ߸ü¸ß°æ±¾ÖС£
Ò»£¬ÈçºÎʹÓÃLogminer:
ÏÈÒª°²×°logminerµÄÁ½¸ö°ü£»ÒÔSYSÓû§ÔËÐÐÏÂÃæÁ½¸ö½Å±¾,ÆäÖеÚÒ»¸ö½Å±¾dbmslm.sqlÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·Ö ......
<?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 9iÆóÒµ°æ¹Ù·½ÏÂÔØ9.2.0.1.0
¼òµ¥ÃèÊö£º oracleµÄ¹Ù·½ÍøÕ¾£ºwww.oracle.com ÕâÀïÓÐoracleµÄ¸÷ÖÖ°æ±¾µÄÊý¾Ý¿â¡¢Ó¦Óù¤¾ßºÍȨÍþµÄ¹Ù·½Îĵµ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð×÷¸÷ÖÖÓ¦ÓõÄÈí¼þ»ù´¡¼Ü¹¹¡£ÏµÍ³ÒªÇó£ºÊÊÓÃÓ²¼þ»·¾³ ÖÁÉÙÐèÒª512MÄڴ棻½»»»Çø£ºÒ»°ãÒªÇóÊÇÄÚ´æµÄÁ½±¶£¬ÖÁÉÙÒ ......
×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£ÔÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËƺõ±äµÃÏ൱À§ÄÑ¡£¼¸¾ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
1¡¢ ±ÜÃâʹÓÃHibernate¿ò¼Ü
HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£
¹ØÓÚ²åÈ룺
......
PL/SQL µÄÒì³£(Ô¤¶¨ÒåÒì³£)
2009-08-13 20:24
Òì³£Ãû³Æ & ......