windows Æô¶¯ oracle Åú´¦Àí½Å±¾
Oracle°²×°ºó£¬»á°Ñ4¸ö·þÎñÉèΪ×Ô¶¯Æô¶¯£¬·Ö±ðΪ£º
1. OracleOraHome90Agent
2. OracleOraHome90HTTPServer
3. OracleOraHome90TNSListener
4. OracleServiceORA
ÆäÖеڶþ¸ö²»ÊDZØÐëµÄ£¬¿ÉÒÔÔÚ·þÎñÀï°ÑËü½ûÓá£ÆäËûÈý¸öÔÚOracleÔËÐÐʱ¶¼ÒªÆô¶¯¡£
OracleµÄ½ø³Ì¶¼ÊdzÔÄÚ´æµÄÀÏ»¢£¬¿ÉϧÎÒÖ»ÓÐ512MµÄÄڴ涼Ҫ±ðËü³ÔÈ¥Ò»°ë£¬ÓÚÊDZã°ÑËùÓеÄOracle·þÎñ¶¼ÉèΪÊÖ¶¯£¬Ð´Ò»¸öÅú´¦ÀíÀ´Æô¶¯Oracle·þÎñºÍ¹Ø±ÕOracle·þÎñ£¬ÕâÑùÖ»ÓÐÒªÓõ½Oracleʱ²ÅÆô¶¯Ëü£¬ºÜ·½±ã¡£
Æô¶¯Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÆô¶¯OracleÂð£¿
pause
net start OracleOraHome90Agent
net start OracleOraHome90TNSListener
net start OracleServiceORA
Í£Ö¹Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÍ£Ö¹OracleÂð£¿
pause
net stop OracleOraHome90Agent
net stop OracleOraHome90TNSListener
net stop OracleServiceORA
ÆäÖÐ×îºóÒ»¸ö·þÎñµÄÃû³ÆºÍÄãµÄOracleÀý³ÌÃûÏà¹Ø£¬OraÊÇÎÒµÄOracleÀý³ÌÃû£¬Èç¹ûÀý³ÌÃû²»Ò»Ñù£¬ÄÇô°ÑOra»»³ÉÄãµÄÀý³ÌÃû¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢ ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1) VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......
Ç°Á½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉÏ°²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃÖØ×°oracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉÏ°²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂ붼×öÁ˸Ķ¯£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......
¶ÔÓÚUNDO
±í¿Õ¼ä´óСµÄ¶¨ÒåÐèÒª¿¼ÂÇUNDO_RETNETION
²ÎÊý¡¢²úÉúµÄUNDO BLOCKS/
Ãë¡¢UNDO BLOCK
µÄ´óС¡£undo_retention
£º¶ÔÓÚUNDO
±í¿Õ¼äµÄÊý¾ÝÎļþÊôÐÔΪautoextensible,
Ôòundo_retenion
²ÎÊý±ØÐëÉèÖã¬UNDO
ÐÅÏ¢½«ÖÁÉÙ±£ÁôÖÁundo_retention
²ÎÊýÉ趨µÄÖµÄÚ£¬µ«UNDO
±í¿Õ¼ä½«»á×Ô¶¯À©Õ¹¡£¶ÔÓڹ̶¨UNDO
±í¿Õ¼ä ......
1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......
»ùÓÚOCI ʵÏÖµÄ ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......