ÈçºÎÉèÖÃ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
±£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......