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

oracle raw devices

1.LVM:
[root@vmfs ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sdg
  VG Name               db_v4
  PV Size               2.00 GB / not usable 0  
  Allocatable           yes
  PE Size (KByte)       4096
  Total PE              511
  Free PE               1
  Allocated PE          510
  PV UUID               MlB8lE-H3DL-RCcf-p5Di-J6A2-INLc-zw328m
  
  --- Physical volume ---
  PV Name               /dev/sdf
  VG Name               db_v3
  PV Size               2.00 GB / not usable 0  
  Allocatable           yes
  PE Size (KByte)       4096
  Total PE              511
  Free PE               115
  Allocated PE          396
  PV UUID               2KsemU-DsQQ-GR8k-nnR2-Zm7M-nUCb-yXuUR5
  
  --- Physical volume ---


Ïà¹ØÎĵµ£º

ÔÚ Windows ÉÏ°²×° Oracle Êý¾Ý¿â 11g

 
ÔÚ Windows ÉÏ°²×° Oracle Êý¾Ý¿â 11g
°²×°Oracle Èí¼þ£¬±ØÐëʹÓà Oracle Universal Installer¡£
1.ÔÚÕâÒ»°²×°ÖУ¬ÄúÐèҪʹÓà DVD »òÏÂÔØ DVD °æ±¾¡£ÔÚ±¾½Ì³ÌÖУ¬½«´ÓÒÑÏÂÔصİ汾½øÐа²×°¡£ÔÚ½âѹËõ DVD ÎļþµÄĿ¼ÖУ¬´ò¿ª Windows ×ÊÔ´ä¯ÀÀÆ÷²¢Ë«»÷ \db\Disk1 Ŀ¼µÄ setup.exe¡£
2.°²×°µÄ²úƷΪ Oracle Da ......

Oracleɾ³ý±íÖÐÖظ´¼Ç¼

--刪³ýÖØ復ÁÐ  
  a.Èç¹ûÓÐID×ֶΣ¬¾ÍÊǾßÓÐΨһÐÔµÄ×ֶΠ 
   
  delect   table   where   id   not   in   (  
   
  select   max(id)   from   table   group   by   col1,col ......

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......

Oracle RAC ¹éµµ Óë ·Ç¹éµµ Çл»


Oracle µÄÉú²ú¿â¶¼ÊÇÆô¶¯Ôڹ鵵ģʽÏ£¬RACϹ鵵·Ç¹éµµµÄÇл»ºÍµ¥ÊµÀýÒ²ÊÇÒ»ÑùµÄ£¬¶¼ÊÇÔÚMOUNTģʽÏÂÖ´ÐÐALTER DATABASE ARCHIVELOG/NOARCHIVELOG;ÃüÁî¡£ ²»Í¬µÄÊÇ£ºRAC»·¾³ÏÂËùÓÐʵÀý¶¼±ØÐë´¦ÓÚ·ÇOPEN״̬£¬È»ºóÔÚÈÎÒâÒ»¸ö´¦ÓÚMOUNT״̬µÄʵÀýÖ´ÐÐALTER DATABASEÃüÁ²Ù×÷³É¹¦ºó£¬ÔÙÕý³£Æô¶¯ ......

oracle¸ü¸Ä×Ö·û¼¯

ÐÞ¸Äoracle 10gµÄ×Ö·û¼¯
ÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯Îª£ºZHS16GBK
Ê×ÏÈÓÃscott&tiger&orclµÇ¼µ½sql/plus
²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯
SQL > select * from
V$NLS_PARAMETERS;
Ð޸ģº
$sqlplus /nolog
SQL>conn / as sysdba
Èô
´ËʱÊý¾Ý¿â·þÎñÆ÷ÒÑÆô¶¯£¬ÔòÏÈÖ´ÐÐ SHUTDOWN IMMEDIATE Ãü
Áî¹Ø±ÕÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÖ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ