ÈçºÎÉèÖÃoracleÊý¾Ý¿âÔÚÍíÉÏ12µã×Ô¶¯±¸·ÝÄØ
Çë¸ßÊÖ°ï°ï棬¾ÀíÒªÎÒÉèÖÃoracleÊý¾Ý¿âÍíÉÏ12µã×Ô¶¯±¸·Ý£¬ÎÒÔÚѧУ¶¼Ã»Ñ§¹ýÕâÑùµÄ£¬²»¶®Ôõô×ö£¬ÈçºÎдÃüÁÇë¸ßÊֽ̽ÌÎÒ£¬°ÑÏêϸ²½ÖèдÏ£¬Ð»Ð»£¡ÔÚÏߵȣ¬¼±¼±¼±
Windowsϵͳ¿ÉÒÔ×öÒ»¸öbatÎļþ£¬Ìí¼ÓÈÎÎñ¼Æ»®¶¨Ê±Ö´ÐÐ
linux,°Ñshell±¸·Ý½Å±¾Ìí¼Óµ½crontabÁË.
[oracle@hfcc]$ crontab -l
15 1 * * * /u03/scripts/hot_database_backup.sh
0 1 * * * /u03/scripts/ckalertlog.sh
45 1 * * * /u03/scripts/logicbackup.sh
00 2 * * * /u03/scripts/ck_tbsp.sh
25 2 * * * /u03/scripts/df.sh
RMAN Èȱ¸·Ý½Å±¾
http://user.qzone.qq.com/251097186/blog/1242326086
export Âß¼±¸·Ý½Å±¾
http://user.qzone.qq.com/251097186/blog/1242326460
ѧϰ
ÎÒµÄÊÇwindows xpϵͳ£¬ÎÒ½ñÄê±ÏÒµµÄ£¬ËùÒԺö಻¶®Ã»¾Ñ飬¿É²»¿ÉÒÔ˵Ïêϸµã£¬ÎÒ·´Ó¦±È½ÏÂý£¬Ì«¶à²»¶®ÁË£¬ÎÒµÄoracleÊý¾Ý¿âÊÇÓÃ11gµÄ£¬Âé·³¸ßÊְѲ½ÖèдϺÃÂð£¿ÎÒÕæµÄºÜ¸Ð¼¤£¬Ì«¸ÐлÄãÃÇÁË£¬ÕâÐв»ºÃ»ì°¡£¡Çë°ï°ïÎÒ°É
ÓÃEM(ÆóÒµ¹ÜÀíÆ÷),ÔÚÖ÷½çÃæ½øÈë"ά»¤",½øÈë"µ÷¶È±¸·Ý",Ñ¡Ôñ"µ÷¶È¶¨ÖƱ¸·Ý",Ò»²½²½×ö¾Í¿ÉÒÔÁË.
ÎÒÓÃsysÓû§µÇÈ룬¿ÉÊÇÔÚÖ÷½çÃæ¿´²»µ½ÓС°Î¬»¤¡±ÕâЩ×ÖŶ£¡
д¸ö×î¼òµ¥µÄ¸øÄã²Î¿¼
SQL code:
rem rman backup
rman cmdfile=E:\full_backup.txt msglog=E:\Backups\ora\test.log
±£
Ïà¹ØÎÊ´ð£º
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......