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

Çë½ÌÒ»¸öÔÚlinuxÖ´ÐеÄoracle±¸·Ý½Å±¾µÄÎÊÌâ

ÒÔÏÂÊÇÎÒÔÚwindowsÏÂÃæ²âÊÔʱºòʹÓõĽű¾£º
set oracle_sid=orcl
rman target / msglog D:\backup\logs\%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log cmdfile=D:\backup.rman

ÈôÎÒÏëÔÚlinuxÏÂÃæÊ¹ÓõϰӦ¸ÃÔõôд²Å¿ÉÒÔÄØ£¿±¸·Ý·¾¶ÊÇ/oracle/backup£¬Ö÷ÒªÊÇcmdfileÕâ¿éµÄ²ÎÊý²»»áдÁË£¬ºÇºÇ¡£

ÒýÓÃ
cmdfile¾ÍÊÇÖ¸¶¨ÄãµÄ±¸·Ý½Å±¾Îļþ°¡£¿±ÈÈ磺cmdfile=/oracle/backup/bk.sql
Ҫʲô²ÎÊý£¿

ÄãÊÇ˵logÎļþµÄÈÕÆÚ²ÎÊý²»»áд°É£¿
¶¨Òå¸ö±äÁ¿£º
rq=`date +%y%m%d`
rman target / cmdfile=/oracle/backup/bk.sql log=/oracle/backup/bk${rq}.log


Ŷ£¿ÔÚlinuxÏÂÃæÒ²ÊÇÓÃcmdfileÀ´Ö¸¶¨½Å±¾Îļþ·¾¶µÄÂ𣿺Ǻǣ¬Ã÷°×ÁË£¬Ð»Ð»Á˰¡¡£ÎÒÒÔΪlinux·¾¶ÏÂÃæµÄÊéд¸ñʽºÍwindows²»Í¬ÄØ¡£·Ç³£¸Ðл°¡£¡

ÑÏÖØÖ§³Ö    kaixinmengya

ÔÙÇë½Ìһϣ¬ÊDz»ÊÇÎÒÔÚ±¸·Ý½Å±¾ÀïÃæ¶¨ÒåÒ»¸öÈÕÆÚ±äÁ¿rq£¬È»ºóÖ±½Ó°´ÕÕÏÂÃæÕâôд¾Í¿ÉÒÔÁËÂð£¿

rq='date +%y%m%d'
rman target / log=/oracle/backup/logs/${rq}.log cmdfile=/oracle/backup/backup.rman

rq='date +%y%m%d'
ÇëÎÊÕâÌõÓï¾äÊDz»ÊǾÍÊǶ¨Òå±äÁ¿°¡£¿ÎÒ¶ÔlinuxϵͳµÄ½Å±¾Êéд¸ñʽ²»ºÜÇå³þ£¬»¹Çë¶à¶àÖ¸½Ì¡£ºÇºÇ¡£

¶¨Òå±äÁ¿¡£Êǵ쬵±Ê±¾ÍÊÇ£¬ÕâÑù£¡

ÒýÓÃ
rq='date +%y%m%d'
ÇëÎÊÕâÌõÓï¾äÊDz»ÊǾÍÊǶ¨Òå±äÁ¿°¡£¿ÎÒ¶ÔlinuxϵͳµÄ½Å±¾Êéд¸ñʽ²»ºÜÇå³þ£¬»¹Çë¶à¶àÖ¸½Ì¡£ºÇºÇ¡£

Õâ¸öÊÇ´íµÄ¡£²»Êǵ¥ÒýºÅ¡£ÊǼüÅÌÉÏ1¼ü×ó±ßÄǸö¡°`¡±

ÒýÓÃ
ÒýÓà 5 Â¥ kaixinme


Ïà¹ØÎÊ´ð£º

linux»·¾³ÏÂgethostbynameº¯ÊýÎÊÌâ - C/C++ / CÓïÑÔ

дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
   
  struct hostent *hp; 
char AlarmDevIP[20];  
  int x2;

hp = gethostbyname("www.google.com");
if (hp)
{ ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ