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

Oracle 10g ÒªµãÕûÀí Ö® ÉÁ»Ø£¨½öÏÞÓÚSQL*Plus£©

ÉÁ»Ø
1 ÌØÕ÷
ÉÁ»ØÊý¾Ý¿âÖ»ÊÇÂß¼­Êý¾ÝÔâµ½ÆÆ»µÊ±µÄÊֶΡ£
ÉÁ»ØÊý¾Ý¿âÈÕÖ¾±ØÐëÔÚÊý¾Ý¿â»Ö¸´ÇøÖд´½¨¡£
ÉÁ»ØÈÕÖ¾²»ÐèÒª¹éµµ£¬²»ÄÜÓÃÓÚÎïÀí»Ö¸´¡£
Ö´ÐÐÉÁ»ØÊý¾Ý¿â²Ù×÷ʱ£¬±³¾°½ø³ÌRVWR¾ÍÆô¶¯ÁË¡£
 
2 ʹÓÃÉÁ»ØÊý¾Ý¿â
3ÖÖ¹¤¾ß£¬SQL*Plus£¬RMAN£¬OEM¡£
£¨1£©ÒªÇó
ΪÁËʹÓÃÉÁ»ØÊý¾Ý¿â£¬Êý¾Ý¿â±ØÐë´¦Óڹ鵵ÈÕ־ģʽ¡£
 
£¨2£©´ÓSQL*PlusÖÐÉÁ»ØÊý¾Ý¿â
¢Ù Óû§±ØÐëʹÓÃas sysdbaÁ¬½Óµ½Êý¾Ý¿â¡£
¢Ú ¹Ø±ÕÊý¾Ý¿â
   shutdown immediate;
¢Û °²×°Êý¾Ý¿â
   startup mount exclusive;
¢Ü ʹÓÃalter systemÃüÁÉèÖÃdb_flashback_retention_targetΪһ¸öÄ¿±êÖµ£¬¸ÃÖµÖ¸¶¨ÁË¿ÉÒÔÉÁ»ØµÄʱ¼äÉÏÏÞ£¨·ÖÖÓ£©
   alter system set db_flashback_retention_target = Êý×Ö;
¢Ý ʹÓÃalter database ÉèÖÃÔÊÐíÉÁ»Ø
   alter database flashback on£»
¢Þ ʹÓÃalter database openÃüÁî´ò¿ªÊý¾Ý¿â¡£
¢ß ¹Ø±ÕÊý¾Ý¿â£¬ÖØа²×°Êý¾Ý¿â¡£
¢à ʹÓÃflashback database to timestamp»òflashback database to scn Êý×Ö Ö´ÐÐÉÁ»Ø²Ù×÷¡£
¢á ʹÓÃalter database open read only¡£
¢â È·ÈÏÉÁ»Ø³É¹¦ºó£¬Ö´ÐÐalter database open resetlog
 
3 Ïà¹ØÊÓͼ
£¨1£©v$database£ºÀïÃæÓÐÒ»ÁГflashback_on”£¬²¼¶ûÀàÐÍ¡£¾ö¶¨ÊÇ·ñÔÊÐíÖ´ÐÐÉÁ»Ø²Ù×÷¡£
£¨2£©v$flashback_database_log£ºÓÃÓÚ¼àÊÓÉÁ»ØÊý¾Ý¿â¡£
£¨3£©v$ flashback_database_stat£ºÓÃÓÚ¼àÊÓÉÁ»ØÊý¾Ý¿âÈÕÖ¾µÄ¸ººÉ¡£
 
4»ØÊÕÕ¾
»ØÊÕÕ¾¾ÍÊÇÒ»¸öÊý¾Ý×Öµä±í£¬·ÅÖÃÓû§ÒÑɾ³ýµÄÊý¾Ý¿â¶ÔÏóÐÅÏ¢¡£
ÓÃÓÚÖ§³Öflashback drop¹¦ÄÜ¡£µ±Ä³¸ö¶ÔÏó±»dropÖ®ºó£¬Ëü¾ÍÒƶ¯µ½ÁË»ØÊÕÕ¾ÖС£
Èç¹ûÏ£Íû³¹µ×ɾ³ý¶ÔÏ󣬶ø²»ÒƵ½»ØÊÕÕ¾£¬¾ÍÔÚdropÃüÁîºó¼Ópurge²ÎÊý¡£
È磺drop table emp purge£»
 
±»É¾³ýºÍÒƵ½µ½»ØÊÕÕ¾ÖеĶÔÏó²¢Ã»ÓÐÊͷſռ䣬ֱµ½½«Æä´Ó»ØÊÕÕ¾Çå³ýΪֹ¡£
 
purge ¶ÔÏóÀàÐÍ ¶ÔÏóÃû£»
ÉÏÃæµÄÓï¾äÓÃÓÚÇå³ý»ØÊÕÕ¾ÖÐÖ¸¶¨µÄ¶ÔÏó¡£
 
flashback ¶ÔÏóÀàÐÍ ¶ÔÏóÃû to before drop (rename to жÔÏóÃû)£»
Èç¹û¶à´Î´´½¨ºÍɾ³ýͬһ¶ÔÏó£¬ÄÇôֻÊǻָ´×îб»É¾³ýµÄ¶ÔÏó¡£
 
ʹÓÃuser_recyclebinÊÓͼ²é¿´»ØÊÕÕ¾ÖеÄÐÅÏ¢¡£
 
Èƹý»ØÊÕÕ¾
¢Ùdrop table ±íÃû purge£»
¢Údrop tablespace ±í¿Õ¼äÃû including contents£»
¢Ûdrop user Óû§Ãû cascade£»
 
´ÓÉÁ»ØÊý¾Ý¿âÖÐÅųý±í¿Õ¼ä
alter tablespace ±í¿Õ¼äÃ


Ïà¹ØÎĵµ£º

Oracle 10g ÒªµãÕûÀí Ö® Ìåϵ½á¹¹ºÍÊý¾Ý×Öµä

1Á¬½ÓÊý¾Ý¿âʵÀý
£¨1£©Óû§½ø³Ì£ºÈí¼þ£¬SQL*Plus£¬Ê¹ÓÃOracle Net Services£¨ÍøÂç·þÎñ£©ÓëÊý¾Ý¿âͨѶ
£¨2£©Oracle¼àÌýÆ÷£ºlistener.ora£¬¶¨ÒåÁËÊý¾Ý¿âʵÀýÃû£¬Â·¾¶£¬¿ÉÒÔʹÓõÄЭÒ飬¶Ë¿Ú
£¨3£©OracleÍøÂç¿Í»§£ºtnsnames.ora£¬¶¨ÒåÁËͨѶЭÒ飬¶Ë¿Ú£¬·þÎñÆ÷µØÖ·
 
2 ·þÎñÆ÷½ø³Ì
  ¸ºÔðÓû§½ø³ÌºÍOracleʵÀý ......

MY SQL »¹ÊǺÜÇ¿´óµÄ¡£¡£¡£

֮ǰûÔõôÑо¿¹ýMySQLµÄÈÝÁ¿£¬ÓÉÓÚÏîÄ¿ÐèÒª£¬ÐèÒªÒ»¸öÃâ·ÑµÄ¿ÉÒÔÖ§³ÖǧÍòÌõÊý¾Ý¼¶ÒÔÉϵÄÊý¾Ý¿â£¬²é¿´ÏÂmysqlµÄÎĵµ£¬·¢ÏÂmysql»¹ÊǺÜÇ¿´óµÄ£¬¼Ç¼Ï£¬ºÇºÇ¡£Ô­ÎÄÈçÏ£º
MySQL 3.22ÏÞÖƵıí´óСΪ4GB¡£ÓÉÓÚÔÚMySQL 3.23ÖÐʹÓÃÁËMyISAM´æ´¢ÒýÇ棬×î´ó±í³ß´çÔö¼Óµ½ÁË65536TB£¨2567 –1×Ö½Ú£©¡£ÓÉÓÚÔÊÐíµÄ±í³ß´ç¸ü´ ......

SQL Server Á¬½Ó×Ö·û´®ºÍÉí·ÝÑéÖ¤

SQL Server .NET Data Provider Á¬½Ó×Ö·û´®°üº¬Ò»¸öÓÉһЩÊôÐÔÃû/Öµ¶Ô×é³ÉµÄ¼¯ºÏ¡£Ã¿Ò»¸öÊôÐÔ/Öµ¶Ô¶¼ÓɷֺŸô¿ª¡£
         PropertyName1=Value1;PropertyName2=Value2;PropertyName3=Value3;.....
ͬÑù£¬Á¬½Ó×Ö·û´®±ØÐë°üº¬SQL ServerʵÀýÃû³Æ:
     ......

Oracle 10g ÒªµãÕûÀí Ö® PL/SQL

PL/SQL
1 ¸ÅÊö
PL/SQLÊÇÒ»ÖÖ¹ý³Ì»¯±à³ÌÓïÑÔ£¬Óû§¿ÉÒÔʹÓÃPL/SQL±àд¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷²¢ÇÒ´æ´¢ÕâЩ´úÂë¡£
PL/SQL²»Çø·Ö´óСд¡£
PL/SQL·ÖΪ¼¸²¿·Ö£º
 
 
declare ¿ÉÑ¡                   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ