Çë½ÌÒ»¸öÔÚ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Õâ¿éµÄ²ÎÊý²»»áдÁË£¬ºÇºÇ¡£
Ŷ£¿ÔÚ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ϵͳµÄ½Å±¾Êéд¸ñʽ²»ºÜÇå³þ£¬»¹Çë¶à¶àÖ¸½Ì¡£ºÇºÇ¡£
¶¨Òå±äÁ¿¡£Êǵ쬵±Ê±¾ÍÊÇ£¬ÕâÑù£¡
Õâ¸öÊÇ´íµÄ¡£²»Êǵ¥ÒýºÅ¡£ÊǼüÅÌÉÏ1¼ü×ó±ßÄǸö¡°`¡±
Ïà¹ØÎÊ´ð£º
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Êý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......