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

ÈçºÎÉèÖÃoracleÊý¾Ý¿âÔÚÍíÉÏ12µã×Ô¶¯±¸·ÝÄØ

Çë¸ßÊÖ°ï°ï棬¾­ÀíÒªÎÒÉèÖÃoracleÊý¾Ý¿âÍíÉÏ12µã×Ô¶¯±¸·Ý£¬ÎÒÔÚѧУ¶¼Ã»Ñ§¹ýÕâÑùµÄ£¬²»¶®Ôõô×ö£¬ÈçºÎдÃüÁÇë¸ßÊֽ̽ÌÎÒ£¬°ÑÏêϸ²½ÖèдÏ£¬Ð»Ð»£¡ÔÚÏߵȣ¬¼±¼±¼±
Windowsϵͳ¿ÉÒÔ×öÒ»¸öbatÎļþ£¬Ìí¼ÓÈÎÎñ¼Æ»®¶¨Ê±Ö´ÐÐ

ÒýÓÃ
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
±£


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ