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

ʹÓÃRmanʵÏÖoracleÊý¾Ý¿âµÄ±¸·Ý»¹Ô­


´ò¿ªRman
·½·¨1£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë”rman£¬»Ø³µ£¬´ò¿ªrmanÃüÁîÐÐÌáʾ´°¿Ú£¬ÊäÈ룺connect target;Á¬½ÓÉÏÊý¾Ý¿â£¬½ÓÏÂÀ´¾Í¿ÉÒÔ½øÐвÙ×÷ÁË¡£
·½·¨2£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë” rman target username/userpwd@Orcl £¬£¨ºìÉ«×ÖÌå±íʾÊý¾Ý¿âʵÀýÃû£©»Ø³µ£¬´ò¿ªµÄrmanÃüÁîÐд°¿Ú£¬ÒѾ­Á¬½ÓÉÏÊý¾Ý¿âÁË£¬½ÓÏÂÀ´¾Í¿ÉÒÔÖ±½Ó½øÐвÙ×÷ÁË
±¸·ÝÊý¾Ý¿â
 ÔÚÃüÁîÐÐģʽÏ£¬ÊäÈëÒÔÏÂÃüÁ
backup as copy database;
//´ËÃüÁî±íʾ¶ÔÊý¾Ý¿â½øÐÐÍêÈ«±¸·Ý£¬Ä¬ÈÏÇé¿öÏÂÊý¾Ý¿â´¦ÔÚ“·Ç¹éµµÄ£Ê½”Ï¡£ÔÚÖ´ÐÐÉÏÃæµÄ
//ÃüÁîʱ£¬»á³öÏÖÏÂÃæµÄ´íÎó“ÎÞ·¨°´ noarchivelog ģʽ±¸·Ý»ò¸´ÖÆÎļþ”£¬Õë¶ÔÕâ¸ö´íÎ󣬿ÉÒÔ°´ÏÂÃæµÄ·½Ê½½â¾ö¡£
¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë” sqlplus / as sysdba£¬»Ø³µ£¬ÒÔ¹ÜÀíÔ±µÄÉí·ÝÁ¬½ÓÊý¾Ý¿â£¬ÒÀ´ÎÖ´ÐÐÒÔÏÂÃüÁ
shutdown immediate  //¹Ø±ÕÊý¾Ý¿â
startup mount            //Æô¶¯Êý¾Ý¿âµ½“×°Ôؔ״̬
alter database archivelog //ÐÞ¸ÄÊý¾Ý¿âΪ“¹éµµÄ£Ê½”
alter database open        //´ò¿ªÊý¾Ý¿â
È»ºó£¬Ôٻص½Rman¡£Ö´ÐÐbackup²Ù×÷
backup database;
´Ëʱ³öÏÖÁËÁíÒ»¸ö´íÎó£ºora-19809:³¬³öÁ˻ָ´ÎļþÊýµÄÏÞÖÆ
ora-19804:ÎÞ·¨»ØÊÕ 52428800 ×Ö½Ú´ÅÅÌ¿Õ¼ä ´Ó<2147483648ÏÞÖÆÖÐ>
½â¾ö°ì·¨1£ºÍ¨¹ýSqlplusÒÔ¹ÜÀíÔ±µÄÉí·ÝÁ¬½ÓOracleÊý¾Ý¿â£¬Ö´ÐÐÏÂÃæµÄÃüÁ
show parameter db_recovery_file_dest_size;         //ĬÈÏÊÇ2G
alter system set db_recovery_file_dest_size=4G;  //Ôö´ó¿Õ¼äºó£¬±¸·Ý³É¹¦¡£
½â¾ö°ì·¨2£º¸Ä±ä±¸·Ý·¾¶
backup database format 'd:\oracle\backup\%U.dbf' 
plus archivelog format 'd:\oracle\backup\%U.arc';
±¸·ÝѹËõ¹¦ÄÜ
¿ÉÒÔÑ¡ÔñÔÚ±¸·ÝÃüÁîÀïÏÔʾָ¶¨Ñ¹ËõÑ¡Ïî:
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
--½ö¶Ô1,5ÎļþѹËõ±¸·Ý
BACKUP AS COMPRESSED BACKUPSET DATAFILE 1,5;
Ò²¿ÉÒÔÅäÖÃRMANÖ¸¶¨Ñ¹ËõÑ¡Ïî:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
--±¸·ÝѹËõµ½Ö¸¶¨Â·¾¶
backup as Compressed backupset database format 'd:\oracle\backup\%U.dbf' 
plus archivelog for


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

weblogicÏÂÔÚOracleÖд洢clobÀàÐÍÒ»Àý

String sql = "select t.FILE_INFO from T_FILE_DB_DETAIL t where t.id= "
      + fileDBUpDownDetail.getId() + " for update";
    rs = stmt.executeQuery(sql);
    if (rs.next()) {
     // ÔÚweblogicϲ¿Êðʱ£¬ÐèÒª¸ü¸ÄΪBea We ......

Oracle SQLÓëANSI SQLÇø±ð


Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......

SQLÃüÁî²éѯOracle´æ´¢¹ý³ÌÐÅÏ¢£¨´úÂëÄÚÈݵȣ©

SELECT * from ALL_SOURCE 
where TYPE='PROCEDURE'  AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......

Oracle SQL Loader

Ò»£ºSQL Loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ