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"
Ïà¹ØÎĵµ£º
1.LVM:
[root@vmfs ~]# pvdisplay
--- Physical volume ---
PV Name /dev/sdg
VG Name db_v4
PV Size  ......
Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
£¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......
select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 sele ......
linux ÉϵÄoracle sqlplus ²»ÄÜÀûÓà ÉÏ, Ï ¼üÀ´²é¿´ÃüÁËÑË÷µ½½â¾öÎÊÌâµÄ°ì·¨£¬ÕûÀíÈçÏÂ
°²×°Èí¼þrlwrap¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣬¸ÃÈí¼þÊÇÓÃcдµÄ³ÌÐò
¹Ù·½ÏÂÔØµØÖ·£ºhttp://utopia.knoware.nl/~hlub/uck/rlwrap/
°²×°¹ý³Ì£º
ÎÒÃÇÒ²¿ÉÒԲ鿴½âѹºóµÄtar°ü£¬²é¿´README°ïÖúÎļþ
shell>tar -zxvf rlwrap-0.36.tar.gz
sh ......