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
°²×°Oracle Èí¼þ£¬±ØÐëʹÓà Oracle Universal Installer¡£
1.ÔÚÕâÒ»°²×°ÖУ¬ÄúÐèҪʹÓà DVD »òÏÂÔØ DVD °æ±¾¡£ÔÚ±¾½Ì³ÌÖУ¬½«´ÓÒÑÏÂÔصİ汾½øÐа²×°¡£ÔÚ½âѹËõ DVD ÎļþµÄĿ¼ÖУ¬´ò¿ª Windows ×ÊÔ´ä¯ÀÀÆ÷²¢Ë«»÷ \db\Disk1 Ŀ¼µÄ setup.exe¡£
2.°²×°µÄ²úƷΪ Oracle Da ......
--刪³ýÖØ復ÁÐ
a.Èç¹ûÓÐID×ֶΣ¬¾ÍÊǾßÓÐΨһÐÔµÄ×Ö¶Î
delect table where id not in (
select max(id) from table group by col1,col ......
ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......
Oracle µÄÉú²ú¿â¶¼ÊÇÆô¶¯Ôڹ鵵ģʽÏ£¬RACϹ鵵·Ç¹éµµµÄÇл»ºÍµ¥ÊµÀýÒ²ÊÇÒ»ÑùµÄ£¬¶¼ÊÇÔÚMOUNTģʽÏÂÖ´ÐÐALTER DATABASE ARCHIVELOG/NOARCHIVELOG;ÃüÁî¡£ ²»Í¬µÄÊÇ£ºRAC»·¾³ÏÂËùÓÐʵÀý¶¼±ØÐë´¦ÓÚ·ÇOPEN״̬£¬È»ºóÔÚÈÎÒâÒ»¸ö´¦ÓÚMOUNT״̬µÄʵÀýÖ´ÐÐALTER DATABASEÃüÁ²Ù×÷³É¹¦ºó£¬ÔÙÕý³£Æô¶¯ ......
ÐÞ¸Äoracle 10gµÄ×Ö·û¼¯
ÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯Îª£ºZHS16GBK
Ê×ÏÈÓÃscott&tiger&orclµÇ¼µ½sql/plus
²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯
SQL > select * from
V$NLS_PARAMETERS;
Ð޸ģº
$sqlplus /nolog
SQL>conn / as sysdba
Èô
´ËʱÊý¾Ý¿â·þÎñÆ÷ÒÑÆô¶¯£¬ÔòÏÈÖ´ÐÐ SHUTDOWN IMMEDIATE Ãü
Áî¹Ø±ÕÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÖ´ ......