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 ±í¿Õ¼äÃ
Ïà¹ØÎĵµ£º
1Á¬½ÓÊý¾Ý¿âʵÀý
£¨1£©Óû§½ø³Ì£ºÈí¼þ£¬SQL*Plus£¬Ê¹ÓÃOracle Net Services£¨ÍøÂç·þÎñ£©ÓëÊý¾Ý¿âͨѶ
£¨2£©Oracle¼àÌýÆ÷£ºlistener.ora£¬¶¨ÒåÁËÊý¾Ý¿âʵÀýÃû£¬Â·¾¶£¬¿ÉÒÔʹÓõÄÐÒ飬¶Ë¿Ú
£¨3£©OracleÍøÂç¿Í»§£ºtnsnames.ora£¬¶¨ÒåÁËͨѶÐÒ飬¶Ë¿Ú£¬·þÎñÆ÷µØÖ·
2 ·þÎñÆ÷½ø³Ì
¸ºÔðÓû§½ø³ÌºÍOracleʵÀý ......
֮ǰûÔõôÑо¿¹ýMySQLµÄÈÝÁ¿£¬ÓÉÓÚÏîÄ¿ÐèÒª£¬ÐèÒªÒ»¸öÃâ·ÑµÄ¿ÉÒÔÖ§³ÖǧÍòÌõÊý¾Ý¼¶ÒÔÉϵÄÊý¾Ý¿â£¬²é¿´ÏÂmysqlµÄÎĵµ£¬·¢ÏÂmysql»¹ÊǺÜÇ¿´óµÄ£¬¼Ç¼Ï£¬ºÇºÇ¡£ÔÎÄÈçÏ£º
MySQL 3.22ÏÞÖƵıí´óСΪ4GB¡£ÓÉÓÚÔÚMySQL 3.23ÖÐʹÓÃÁËMyISAM´æ´¢ÒýÇ棬×î´ó±í³ß´çÔö¼Óµ½ÁË65536TB£¨2567 –1×Ö½Ú£©¡£ÓÉÓÚÔÊÐíµÄ±í³ß´ç¸ü´ ......
SQL Server .NET Data Provider Á¬½Ó×Ö·û´®°üº¬Ò»¸öÓÉһЩÊôÐÔÃû/Öµ¶Ô×é³ÉµÄ¼¯ºÏ¡£Ã¿Ò»¸öÊôÐÔ/Öµ¶Ô¶¼ÓɷֺŸô¿ª¡£
PropertyName1=Value1;PropertyName2=Value2;PropertyName3=Value3;.....
ͬÑù£¬Á¬½Ó×Ö·û´®±ØÐë°üº¬SQL ServerʵÀýÃû³Æ:
  ......
PL/SQL
1 ¸ÅÊö
PL/SQLÊÇÒ»ÖÖ¹ý³Ì»¯±à³ÌÓïÑÔ£¬Óû§¿ÉÒÔʹÓÃPL/SQL±àд¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷²¢ÇÒ´æ´¢ÕâЩ´úÂë¡£
PL/SQL²»Çø·Ö´óСд¡£
PL/SQL·ÖΪ¼¸²¿·Ö£º
declare ¿ÉÑ¡ &nbs ......