ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ¼ÆËã»úÒÔÆäÇ¿´óµÄËٶȴ¦ÀíÄÜÁ¦£¬È¡´úÁ˺ܶàÈËΪµÄ¹¤×÷£¬µ«ÊÇ£¬ÍùÍùºÜ¶àʱºò£¬ËüÓÖÊÇÄÇôÈõ²»½û·ç£¬Ö÷°åÉϵÄоƬ¡¢Ö÷°åµç·¡¢ÄÚ´æ¡¢µçÔ´µÈÈκÎÒ»Ïî²»ÄÜÕý³£¹¤×÷£¬¶¼»áµ¼Ö¼ÆËã»úϵͳ²»ÄÜÕý³£¹¤×÷¡£µ±È»£¬ÕâЩË𻵿ÉÒÔÐÞ¸´£¬²»»áµ¼ÖÂÓ¦ÓúÍÊý¾ÝµÄË𻵡£µ«ÊÇ£¬Èç¹û¼ÆËã»úµÄÓ²ÅÌË𻵣¬½«»áµ¼ÖÂÊý¾Ý¶ªÊ§£¬´Ëʱ±ØÐëÓñ¸·Ý»Ö¸´Êý¾Ý¡£
Æäʵ£¬ÔÚÎÒÃǵÄÏÖʵÊÀ½çÖУ¬ÒѾ¾Í´æÔںܶ౸·Ý²ßÂÔ£¬ÈçRAID¼¼Êõ£¬Ë«»úÈȱ¸£¬¼¯Èº¼¼Êõ·¢Õ¹µÄ²»¾ÍÊǼÆËã»úϵͳµÄ±¸·ÝºÍ¸ß¿ÉÓÃÐÔÂð£¿Óкܶàʱºò£¬ÏµÍ³µÄ±¸·ÝµÄÈ·¾ÍÄܽâ¾öÊý¾Ý¿â±¸·ÝµÄÎÊÌ⣬Èç´ÅÅ̽éÖʵÄË𻵣¬ÍùÍù´Ó¾µÏàÉÏÃæ×ö¼òµ¥µÄ»Ö¸´£¬»ò¼òµ¥µÄÇл»»úÆ÷¾Í¿ÉÒÔÁË¡£
µ«ÊÇ£¬ÉÏÃæËù˵µÄϵͳ±¸·Ý²ßÂÔÊÇ´ÓÓ²¼þµÄ½Ç¶ÈÀ´¿¼ÂDZ¸·ÝÓë»Ö¸´µÄÎÊÌ⣬ÕâÊÇÐèÒª´ú¼ÛµÄ¡£ÎÒÃÇËùÄÜÑ¡Ôñ±¸·Ý²ßÂÔµÄÒÀ¾ÝÊÇ£º¶ªÊÇÊý¾ÝµÄ´ú¼ÛÓëÈ·±£Êý¾Ý²»¶ªÊ§µÄ´ú¼ÛÖ®±È¡£»¹ÓеÄʱºò£¬Ó²¼þµÄ±¸·ÝÓÐʱ¸ù±¾Âú×ã²»ÁËÏÖʵÐèÒª£¬¼ÙÈçÄãÎóɾÁËÒ»¸ö±í£¬µ«ÊÇÄãÓÖÏë»Ö¸´µÄʱºò£¬Êý¾Ý¿âµÄ±¸·Ý¾Í±äµÄÖØÒªÁË¡£ORACLE±¾Éí¾ÍÌṩÁËÇ¿´óµÄ±¸·ÝÓë»Ö¸´²ßÂÔ£¬ÕâÀïÎÒÃÇÖ»ÌÖÂÛORACLE±¸·Ý²ßÂÔ£¬ÒÔϵı¸·Ý¶¼ÊÇÖ¸ORACLEÊý¾Ý¿â±¸·Ý£¬»Ö¸´½«·Åµ½ÏÂÒ»½²ÖС£
Ëùν±¸·Ý£¬¾ÍÊÇ°ÑÊý¾Ý¿â¸´ÖƵ½×ª´¢É豸µÄ¹ý³Ì¡£ÆäÖУ¬×ª´¢É豸ÊÇÖ¸ÓÃÓÚ·ÅÖÃÊý¾Ý¿â¿½±´µÄ´Å´ø»ò´ÅÅÌ¡£
Äܹ»½øÐÐʲôÑùµÄ»Ö¸´ÒÀÀµÓÚÓÐʲôÑùµÄ±¸·Ý¡£×÷Ϊ DBA£¬ÓÐÔðÈδÓÒÔÏÂÈý¸ö·½Ãæά»¤Êý¾Ý¿âµÄ¿É»Ö¸´ÐÔ£º
·Ê¹Êý¾Ý¿âµÄʧЧ´ÎÊý¼õµ½×îÉÙ£¬´Ó¶øʹÊý¾Ý¿â±£³Ö×î´óµÄ¿ÉÓÃÐÔ£»
·µ±Êý¾Ý¿â²»¿É±ÜÃâµØʧЧºó£¬ÒªÊ¹»Ö¸´Ê±¼ä¼õµ½×îÉÙ£¬´Ó¶øʹ»Ö¸´µÄЧÂÊ´ïµ½×î¸ß£»
·µ±Êý¾Ý¿âʧЧºó£¬ÒªÈ·±£¾¡Á¿ÉÙµÄÊý¾Ý¶ªÊ§»ò¸ù±¾²»¶ªÊ§£¬´Ó¶øʹÊý¾Ý¾ßÓÐ×î´óµÄ¿É»Ö¸´ÐÔ¡£
ÔÖÄѻָ´µÄ×îÖØÒªµÄ¹¤×÷ÊÇÉè¼Æ³ä×ãƵÂʵÄÓ²Å̱¸·Ý¹ý³Ì¡£±¸·Ý¹ý³ÌÓ¦¸ÃÂú×ãϵͳҪÇóµÄ¿É»Ö¸´ÐÔ¡£ÀýÈ磬Èç¹ûÊý¾Ý¿â¿ÉÓнϳ¤µÄ¹Ø»úʱ¼ä£¬Ôò¿ÉÒÔÿÖܽøÐÐÒ»´ÎÀ䱸·Ý£¬²¢¹éµµÖØ×öÈÕÖ¾£¬¶ÔÓÚ24*7µÄϵͳ£¬»òÐíÎÒÃÇ¿¼ÂǵÄÖ»ÄÜÊÇÈȱ¸·Ý¡£ Èç¹ûÿÌ춼Äܱ¸·Ýµ±È»»áºÜÀíÏ룬µ«Òª¿¼ÂÇÆ
Ïà¹ØÎĵµ£º
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
ËüÓÖ·ÖΪÆ߸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
ÓÐÈ ......
ÔÚFedora 10ÉÏ°²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
1. Ñé֤ϵͳҪÇó
ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂà ......
oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
&nb ......