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

ÈçºÎ´ÓÍêºÃµÄÊý¾ÝÎļþ»Ö¸´oracleÊý¾Ý¿â

Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
    1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔ­Êý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
    2£©
    Cmd>sqlplus /nolog
    Sql>conn as sysdba
    Óû§Ãû£ºsystem
    ÃÜÂ룺£¨´Ë´¦ÃÜÂëΪд´½¨Êý¾Ý¿âµÄÃÜÂ룩
    Sql>shutdown immediate
    Sql>startup nomount
    Sql>alter database mount
    ´Ëʱ¿´Êý¾Ý¿âÊDz»ÊÇÄÜmountÆðÀ´£¬ÓÐʱ»áÌáʾûÓпÚÁîÎļþPWDdemo.oraÎļþÕÒ²»µ½¡£²é¿´¶ÔÓ¦µÄĿ¼£¨databaseÏ£©»á·¢ÏÖ¸ÃÎļþÊÇ´æÔڵġ£´ËʱÐèҪעÒ⣬¸Ã¿ÚÁîÎļþÊÇа²×°Êý¾Ý¿âºó´´½¨ÊµÀýʱÉú³ÉµÄ¿ÚÁîÎļþ£¬²»ÊÇÒÔÇ°ËùÓÃÊý¾Ý¿âµÄ¿ÚÁîÎļþ£¬¶øÏÖÔÚ£¬ÎÒÃÇÊÇÓÃÒÔÇ°Êý¾Ý¿âµÄ¿ØÖÆÎļþºÍÊý¾ÝÎļþÀ´´ò¿ªÒÔÇ°µÄÊý¾Ý¿â£¬ËùÒÔ´ËʱÐèÒªÖØд´½¨Ò»¸ö¿ÚÁîÎļþ¡£
    Sql>shutdown immediate
    Sql>host orapwd file=c£º\oracle9i\database\PWDdemo.ora password=oracle
    Entries=10 £¨·ÅÔÚdatabase Ŀ¼Ï£©
    Sql>startup nomount
    Sql>alter database mount
    Sql>alter database open
    ´ò¿ªÊý¾Ý¿â
    2.Èç¹ûÐÂÊý¾Ý¿âµÄ°²×°Ä¿Â¼ºÍÔ­ÓÐÊý¾Ý¿âµÄĿ¼²»Ò»Ñù£¬ÄÇô´Ëʱ¿ÉÒÔÖؽ¨¿ØÖÆÎļþÀ´´ò¿ªÊý¾Ý¿â¡£ÒòΪԭ¿ØÖÆÎļþÖмǼµÄÊý¾ÝÎļþµØÖ·ºÍÏÖÓеÄÊý¾ÝÎļþλÖò»Ò»Ñù¡£´ËʱºÍÏÂÃæµÚ¶þÖÐÇé¿öÒ»Ñù¡£µ±È»£¬´ËʱҲ¿ÉÒÔ´´½¨ºÍÔ­Êý¾Ý¿âÒ»ÑùµÄĿ¼½á¹¹£¨Ç°ÌáÊÇÒª¼ÇµÃÔ­Êý¾Ý¿âµÄĿ¼½á¹¹£©£¬ÐèҪעÒâµÄ¾ÍÊDzÎÊýÎļþÖмǼµÄ¿ØÖÆÎļþλÖúͿØÖÆÎļþÖмǼµÄÊý¾ÝÎļþλÖá£
    ˵Ã÷£ºÎÒÃÇÐèÒªÇå³þÊý¾Ý¿âÔÚ´ò¿ªµÄÈý¸ö½×¶ÎÖУ¬ÐèÒª¶ÁÈ¡µÄÎļþ
    Sql>startup nomount £¨´Ëʱ¶ÁÈ¡²ÎÊýÎļþ£©
    Sql>alter database mount £¨¸ù¾Ý²ÎÊýÎļþÖмǼµÄ¿ØÖÆÎļþµØÖ·£¬È¥¶ÁÈ¡¿ØÖÆÎļþ£©
    Sql>alter database open £¨¸ù¾Ý¿ØÖÆÎļþÖмÇ


Ïà¹ØÎĵµ£º

OracleÓû§¹ÜÀí

 Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
 ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
 ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
 1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
  Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......

¡¾×ª¡¿Oracle Tablespace´´½¨

 Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
  ·ÖÅä´æ ......

Oracle Rman¿çresetlogs°æ±¾»Ö¸´

RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......

oracle Ìåϵ½á¹¹

Ç°¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕÅ°×Ö½ÉÏ»­³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......

MySQLÄ£ÄâOracleµÄSequenceÁ½ÖÖ·½·¨


<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ