Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ