ÈçºÎ´ÓÍêºÃµÄÊý¾ÝÎļþ»Ö¸´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Êý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......
Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
·ÖÅä´æ ......
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Ìåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......
<!--
/* 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:"\@ËÎÌå" ......