2¡¢ Ä£Äâ»·¾³£º 1£©Ê×ÏÈʹÓÃrman×÷Õû¸öÊý¾Ý¿â±¸·Ý 2£©Ê±¼ä£º # date Tue Aug 23 17:35:19 BEIDT 2005 3£©²Ù×÷£º sql>truncate table scott.emp 3¡¢ »Ö¸´Êý¾Ý¿âµ½2005Äê8ÔÂ23ÈÕ17µã35·Ö19Ãë 4¡¢ Êý¾Ý¿âµ½mount״̬ 5¡¢ ÉèÖñäÁ¿ $set nls_date_format=yyyy-mm-dd:hh24:mi:ss 6¡¢ Á¬½Óµ½rman $rman target / catalog [email=rman/rman@omsora9]rman/rman@omsora9[/email] RMAN> run { 2> set until time="to_date('2005-08-23:...
by cxm.cm - LinuxÎĵµ×¨Çø - 2007-05-17 14:56:41 ÔĶÁ£¨755£© »Ø¸´£¨0£©
À䱸·ÝµÄ²»ÍêÈ«»Ö¸´:»ùÓÚÈýÖÖÇé¿ö ¡¡¡¡Ò» À䱸·Ý. ¡¡¡¡ ½¨Á¢±í¿Õ¼ätest,Óû§test,±íÃûtest ²åÈëÊý¾Ý ¡¡¡¡insert into test.test(a,b) values(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),to_char(sysdate,'yyyy-mm-dd hh24:mi¡¯)); ¡¡¡¡commit; ¡¡¡¡alter system archive log current£» ¡¡¡¡½øÐÐÁËÁ½¸öÊÂÎñ(commit)ºÍÈÕÖ¾Çл» ¡¡¡¡commit; ¡¡¡¡alter system archive log current£»ÈÕÖ¾Çл»Í¬Ê±¹éµµ ¡¡¡¡ ¡¡¡¡select checkpoin...
·þÎñÆ÷dell2950£¬freebsd 7.1 amd64£¬ÉÏÃæÅÜapache+php£¬phpÐèÒªÁ¬½Óoralce·þÎñÆ÷ ÀíÈÏÉϰ²×°oracle8-client + php5-oic8¾Í¿ÉÒÔ£¬Êµ¼ÊÒ»¸ö¶¼°²×°²»ÁË¡£:em16: 1¡¢µÚÒ»´Î°²×° freebsd# cd /usr/ports/databases/oracle8-client/ freebsd# make install clean ===> oracle8-client-0.2.0_1 is only for i386, while you are running amd64. *** Error code 1 Stop in /usr/ports/databases/oracle8-client. 2¡¢µÚ¶þ´Î°²×° freeb...
ÎҵĻúÆ÷£ºsunBlade100 256M ram ²Ù×÷ϵͳ£ºSolaris 8 Ò»ÏÂÊǰ²×°Ê±³ö´íµÄµØ·½£¬Çë¶à¶àÖ¸½Ì£¬ÔÚÏߵȴý£¡£¡£¡ -------------------------------------------------------------------------- $ ls doc install patch stage index.htm ops_patch runInstaller Translations $ env AB_CARDCATALOG=/usr/dt/share/answerbooks/en_US.ISO8859-1/ab_cardcatalog AGENTWORKS_DIR=/NSM CAIGLBL0000=/NSM CAIGLBL0002=CACRITMON ...
¶ą̀·þÎñÆ÷£¬ÓÐʱÐèÒªÖØ×°linuxºÍoracle£¬oracleÐèÒª½øÐгõʼ»¯£¬ÏëÓÃshell½Å±¾×Ô¶¯´¦Àí£¬´úÂ뼸°ÙÐУ¬ÓÐûÓÐʲô°ì·¨£¿
ÎÒʹÓõÄÊÇoracle7.3.4ÒÔ¼°SCO unix5.0.6(ÒÔϾùÊǰ´ÕÕÎÒµÄÒªÇó½øÐÐÉèÖõ쬽ö¹©²Î¿¼£© 1.¼ì²éÓ²¼þ ²é¿´ÏµÍ³ÊÇ·ñ·ûºÏ°²×°Ìõ¼þ¡£ 2.µ÷Õûkernel²ÎÊý Æô¶¯·½·¨£º#scoadmin-->;Hardware/kernel Manager-->;Tone parament ÐèÒªµ÷ÕûµÄ²ÎÊý 15.Semaphores(100,300,100,60) 16.Share data/maximun shared memory 524288-->;67108864 relink reboot 3.Éú³ÉoracleÓû§ÒÔ¼°dba×é ¿ÉÒÔÓÃscoadmin»òÕßÃüÁîÉú³É¡£ÕâÀïÎÒ²ÉÓÃÃüÁîÉú³É <1>;½¨Á¢o...
oracle 9i µÚÒ»´Î°²×°Ê±£¬¿ÉÒÔÖ¸¶¨Ò»¸öÖ÷Ŀ¼£ºÀý£ºOraHome92 ²¢ÎªËüÖ¸¶¨Ò»¸ö·¾¶ ¾ÙÀýΪ£ºe:\oracle\or92 µ±µÚ¶þ´Î°²×°oracleʱ£¬OraHome92µÄ·¾¶£¨e:\oracle\or92£©²»ÄÜÐ޸ģ¬Èç¹ûÐ޸쬻áÉú³ÉÒ»¸öеÄÖ÷Ŀ¼£¬²»ÖªµÀ´ó¼ÒÓÐûÓÐÓöµ½¹ý¡£ ½â¾ö·½°¸£º ÔÚ°²×°Ç° ɾ³ý»òÐÞ¸Ä ÒÔÏÂÐÅÏ¢ºó¾Í¿ÉÐÞ¸ÄÖ÷Ŀ¼Ãû³Æ¼°Ö÷Ŀ¼·¾¶ 1¡¢É¾³ý ´ÅÅÌ£ºc:\program files\oracle ×¢²á±í£ºHKEY_LOCAL_MACHINE\SOFTWARE\oracle 2¡¢ÐÞ¸ÄÎļþC:\Progra...
Óû§¹ÜÀíµÄ²»ÍêÈ«»Ö¸´±ØÐëÂú×ãÏÂÃæÈý¸öÌõ¼þ²Å¿ÉÒÔʹÓÃ: a) ¹éµµÄ£Ê½ b) ÒªÓÐËùÓÐdatafileÔÚÎó²Ù×÷֮ǰµÄ±¸·Ý c) ÒªÓÐ×ÔҪʹÓõı¸·ÝÒÔÀ´µÄËùÓй鵵 ²»ÍêÈ«»Ö¸´µÄÀàÐÍ a) »ùÓÚʱ¼äµã :±ÈÈç´Óalter¾¯¸æÎļþÖв鵽drop table²Ù×÷ÊÇʲôʱºò·¢ÉúµÄ¡¡¡¡ recover database until time '2000-10-01 10:10:10' b) »ùÓÚCancel : ¿ÉÄÜÖмäij¸ö¹éµµË𻵻ò¶ªÊ§ recover database untill cancel c) »ùÓÚSCN(ϵͳ¸Ä±àºÅ)¡¡¡¡ recover d...
Óû§¹ÜÀíµÄ²»ÍêÈ«»Ö¸´±ØÐëÂú×ãÏÂÃæÈý¸öÌõ¼þ²Å¿ÉÒÔʹÓ㺠¡¡¡¡a) ¹éµµÄ£Ê½ ¡¡¡¡b) ÒªÓÐËùÓÐdatafileÔÚÎó²Ù×÷֮ǰµÄ±¸·Ý ¡¡¡¡c) ÒªÓÐ×ÔҪʹÓõı¸·ÝÒÔÀ´µÄËùÓй鵵 ²»ÍêÈ«»Ö¸´µÄÀàÐÍ ¡¡¡¡a) »ùÓÚʱ¼äµã £º±ÈÈç´Óalter¾¯¸æÎļþÖв鵽drop table²Ù×÷ÊÇʲôʱºò·¢ÉúµÄ¡¡¡¡recover database until time '2000-10-01 10:10:10' ¡¡¡¡b) »ùÓÚCancel £º ¿ÉÄÜÖмäij¸ö¹éµµË𻵻ò¶ªÊ§recover database untill cancel ¡¡¡¡c) »ùÓÚSCN(ϵͳ¸Ä±àºÅ...
¡¡Èç¹û±íµÄÐí¶à·ÖÇø±»ÒâÍâdrop£¬ÐèÒªÀûÓôø¿âÉϵı¸·Ý¼¯ÔÚ²âÊÔ»úÉÏ×ö²»ÍêÈ«»Ö¸´£¬¶ø¾ßÌåÈÕÆÚÐèÒª´ïµ½Ò»¸öÌØ¶¨µÄʱ¼ä£¬ÄÇôÎÒÃÇ¿ÉÒԲο¼ÏÂÎÄÖеĽâ¾ö·½·¨¡£ ¡ôÊ×ÏÈÐèÒªÓÃlogminer²é³öɾ³ýÓï¾ä£º uncompress /oracle/oradata/xxx/xxx.ARC.Z ... begin sys.dbms_logmnr.add_logfile('/oracle/oradata/xxx/xxx.ARC'); ... end; begin sys.dbms_logmnr.start_logmnr...
Èç¹û±íµÄÐí¶à·ÖÇø±»ÒâÍâdrop£¬ÐèÒªÀûÓôø¿âÉϵı¸·Ý¼¯ÔÚ²âÊÔ»úÉÏ×ö²»ÍêÈ«»Ö¸´£¬¶ø¾ßÌåÈÕÆÚÐèÒª´ïµ½Ò»¸öÌØ¶¨µÄʱ¼ä£¬ÄÇôÎÒÃÇ¿ÉÒԲο¼ÏÂÎÄÖеĽâ¾ö·½·¨¡£ ¡ôÊ×ÏÈÐèÒªÓÃlogminer²é³öɾ³ýÓï¾ä£º uncompress /oracle/oradata/xxx/xxx.ARC.Z ... begin sys.dbms_logmnr.add_logfile('/oracle/oradata/xxx/xxx.ARC'); ... end; begin sys.dbms_logmnr.start_logmnr(O...