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

Oracle´Ó·Ç¹éµµÄ£Ê½±ä³É¹éµµÄ£Ê½

http://www.cuijie.net.cn/?cat=6
¸ü¸ÄÊý¾Ý¿âµÄ¹éµµÄ£Ê½ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿â£¬ÔÚmountģʽÏÂÐ޸쬼òÒª²½Öè
1   ÒÔshutdown immediate ·½Ê½¹Ø±ÕÊý¾Ý¿â
2  Æô¶¯ÊµÀýµ½mount״̬
3  ¸ü¸ÄÔËÐÐģʽ²¢´ò¿ªÊý¾Ý¿â
²Ù×÷²½Ö裺
1   µÇ¼Êý¾Ý¿â²é¿´Êý¾Ý¿âµÄ¹éµµ×´Ì¬
     SQL> archive log list;
     Èç¹û³öÏÖÐÅÏ¢£º
     Database log mode              No Archive Mode
     Automatic archival             Disabled
     ÔòΪ·Ç¹éµµÄ£Ê½
2  ¹Ø±ÕÊý¾Ý¿â
     SQL>shutdown immediate;
3   Æô¶¯Êý¾Ý¿âµ½mount״̬
     SQL>startup mount;
4   Æô¶¯¹éµµÄ£Ê½
     SQL>alter database archivelog;       (·Ç¹éµµÄ£Ê½Îª£ºalter database noarchivelog)
  
5   ´ò¿ªÊý¾Ý¿â
     SQL>alter database open;
      ²é¿´¹éµµÄ£Ê½×´Ì¬
     SQL>archive log list
      Èç¹û³öÏÖÐÅÏ¢£º
      Database log mode              Archive Mode
      Automatic archival             Enabled
      ³É¹¦¸Ä³É¹éµµÄ£Ê½
http://uplinux.com/online/dodev/sjk/2009/1103/243.html
OracleÊý¾Ý¿â¿ÉÒÔÔËÐÐÔÚ2ÖÖģʽÏÂ:¹éµµÄ£Ê½(archivelog)ºÍ·Ç¹éµµÄ£Ê½(noarchivelog)
¹éµµÄ£Ê½¿ÉÒÔÌá¸ßOracleÊý¾Ý¿âµÄ¿É»Ö¸´ÐÔ£¬Éú²úÊý¾Ý¿â¶¼Ó¦¸ÃÔËÐÐÔÚ´ËģʽÏ£¬¹éµµÄ£Ê½Ó¦¸ÃºÍÏàÓ¦µÄ±¸·Ý²ßÂÔÏà½áºÏ£¬Ö»Óй鵵ģʽûÓÐÏàÓ¦µÄ±¸·Ý²ßÂÔÖ»»á´øÀ´Âé·³¡£
±¾Îļòµ¥½éÉÜÈçºÎÆôÓú͹رÕÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
1.shutdown normal»òshutdown immediate¹Ø±ÕÊý¾Ý¿â
[oracle@jumper oracle]$ sqlplus "/ as sysdba"


Ïà¹ØÎĵµ£º

Oracle¸´ÔÓ²éѯ

1¡¢²éѯÁ½¸öÈÕÆÚÖ®¼äµÄÊý¾Ý¡£
¼ÙÉèÓбíTable1£¬Æä´´½¨±íµÄsqlÓï¾äΪ£º
create table Table1(
StationID    NUMBER(10) Primary key,
Year           NUMBER(4)  not null,
Month        NUMBER(2)  n ......

oracle raw devices

1.LVM:
[root@vmfs ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sdg
  VG Name               db_v4
  PV Size  ......

oracle sql loader


SQL*LOADERÊÇORACLEµÄÊý¾Ý¼ÓÔØ¹¤¾ß£¬Í¨³£ÓÃÀ´½«²Ù×÷ϵͳÎļþÇ¨ÒÆµ½ORACLEÊý¾Ý¿âÖС£SQL*LOADERÊÇ´óÐÍÊý¾Ý
²Ö¿âÑ¡ÔñʹÓõļÓÔØ·½·¨¡£
¡¡¡¡ÔÚNTÏ£¬SQL*LOADERµÄÃüÁîΪSQLLDR£¬ÔÚUNIXÏÂÒ»°ãΪsqlldr/sqlload¡£
¡¡¡¡ÈçÖ´ÐУºd:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on ÐÇÆÚ¶þ 1ÔÂ 8 11:06:42 2 ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1.×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ´¦Àí
MYSQLÓÐ ......

OracleºÍMySQL¡¢PostgreSQLÌØÐÔ¶Ô±È

¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄÒ»Ð©ÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ