Çë½ÌÒ»¸öoracle±¸·ÝµÄÎÊÌâ - Oracle / ¿ª·¢
ÏëÔÚunix»·¾³ÏÂд¸öshell£¬
¶¨ÆÚ±¸·ÝÒ»¸ö±ítest ÖеÄpartition£¬partiton¡¡ÒÔP+ÈÕÆÚÃüÃû£¬ÀýÈçP20100426
ÏÖÔÚÏ뱸·ÝÉϸöÔ±ítestÖеÄpartition¸ÃÈçºÎ×öÄØ£¿
ÓÉÓÚϵͳ²»Ö§³Ö¡¡date -d ·½·¨£¬ËùÒÔÓÃexp¡¡·½·¨Ê±£¬²»ÖªµÀ¸ÃÈçºÎÈ¡ÉϸöÔµÄpartitonÃû×ÖÁË£¿
Çë½Ì¸÷λÊÇ·ñ»¹ÓÐÆäËû·½·¨¿ÉÒÔʵÏÖ£¿
ÄãµÄϵͳ֧³Ö
date +"%Y%m"
Õâ¸ö²»£¿
Õâ¸öÖ§³Ö
date '+%y-%m-%d'
Õâ¸öÊǵ±ÌìµÄ
ÎÊÌâÊÇ¡¡ÒªÈçºÎÈ¡¡¡ÉϸöÔµÄ
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPÏ°²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈÇ°ÓõÄ10gÒ²Óöµ½ÀàËƵÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......