OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨19£©£º±¸·ÝOracleÊý¾Ý¿â
1¡¢±¸·Ý¹¤¾ß
Ö±½ÓʹÓòÙ×÷ϵͳʵÓóÌÐòcopy¡¢cp¾Í¿ÉÒÔ½øÐб¸·Ý²Ù×÷¡£µ«£¬OracleÇ¿ÁÒ½¨ÒéʹÓÃRecovery Manager£¨»Ö¸´¹ÜÀíÆ÷£¬¼òдRMAN£©¡£
RMANÄܹ»±¸·ÝÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ¡¢¹éµµÈÕÖ¾ÒÔ¼°·þÎñÆ÷²ÎÊýÎļþ£¨spfile£©¡£±¸·Ý¿ÉÒÔ±»Ð´Èë´ÅÅÌ»ò´Å´ø¡£
2¡¢¸ÅÄîÓëÊõÓï
2.1¡¢È«²¿±¸·ÝÓ벿·Ö±¸·Ý
È«²¿±¸·Ý£¨whole backup£©ÊÇËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþÒÔ¼°·þÎñÆ÷²ÎÊýÎļþµÄ±¸·Ý¡£¿ØÖÆÎļþµÄËùÓи´Óø±±¾¶¼ÊÇÍêÈ«ÏàͬµÄ£¬Òò´ËÖ»ÐèÒª±¸·ÝÆäÖÐÒ»¸ö¸±±¾¡£Òª×¢ÒâµÄÊÇ£¬²¢²»ÐèÒª±¸·ÝÁª»úÖØ×öÈÕÖ¾£¡Áª»úÖØ×öÈÕÖ¾Îļþͨ¹ý¸´ÓÃÓë¿ÉÑ¡µÄ¹éµµÊܵ½±£»¤¡£»¹ÓУ¬Ö»ÓÐÓÃÓÚÓÀ¾Ã±í¿Õ¼äµÄÊý¾Ý²Å»á±»±¸·Ý¡£RMAN²»Äܱ¸·ÝÁÙʱ±í¿Õ¼äÎļþ£¬ÕâЩÁÙʱÎļþÒ²²»Äܱ»ÖÃÈëÓÃÓÚ²Ù×÷ϵͳ±¸·ÝµÄ±¸·Ýģʽ¡£
²¿·Ö±¸·Ý£¨partial backup£©°üÀ¨ÁËÒ»¸ö»ò¶à¸öÊý¾ÝÎļþÒÔ¼°¿ØÖÆÎļþ¡£²¿·Ö±¸·ÝÓëÊý¾Ý¿âµÄÊ£Óಿ·Ö¿Ï¶¨²»»áͬ²½¡£²¿·Ö±¸·ÝÖ»ÊÇÌض¨Ê±¿ÌÊý¾Ý¿âij²¿·ÖµÄ¸±±¾¡£Èç¹ûÓбØÒª´Ó²¿·Ö±¸·ÝÖл¹ÔÒ»¸öÎļþ£¬ÄÇôÕâ¸öÎļþÔÚÄܹ»Ê¹ÓÃ֮ǰ±ØÐëÓëÊý¾Ý¿âµÄÆäÓಿ·Öͬ²½£¬ÕâÒâζ×ÅÐèҪͨ¹ýÓ¦Óù鵵ºÍÁª»úÖØ×öÈÕÖ¾ÎļþÖеı仯ʹ»Ö¸´µÄÎļþÊÇ×îеġ£
Ö»ÓÐÔÚÊý¾Ý¿âλÓÚarchivelogģʽʱ£¬²¿·Ö±¸·Ý²ÅÓÐЧ¡£
2.2¡¢ÍêÕû±¸·ÝÓëÔöÁ¿±¸·Ý
ÍêÕû±¸·Ý£¨full backup£©ÊÇÒ»¸ö»ò¶à¸öÊý¾ÝÎļþµÄÒ»¸öÍêÕû¸±±¾¡£Õâ¸ö¸±±¾¿ÉÒÔÊÇÈ«²¿±¸·Ý£¬Ò²¿ÉÒÔÊDz¿·Ö±¸·Ý¡£
ÔöÁ¿±¸·Ý£¨incremental backup£©Ö»ÊÇÊý¾ÝÎļþµÄijЩÊý¾Ý¿éµÄÒ»¸ö±¸·Ý£¬Õâ¸ö±¸·ÝÖ»°üº¬´Ó×î½üÒ»´ÎÍêÕû±¸·ÝÍê³ÉÒÔÀ´±»Ð޸ĻòÌí¼ÓµÄÊý¾Ý¿é¡£
ÎÞÂÛÊý¾Ý¿âλÓÚarchivelogģʽ»ònoarchivelogģʽÖУ¬ÔöÁ¿±¸·Ý¶¼¿ÉÒÔÔÚÊý¾Ý¿â´ò¿ª»ò¹Ø±Õʱ½øÐС£²»¹ý£¬Ö»ÓÐRMAN²ÅÄܽøÐÐÔöÁ¿±¸·Ý¡£
2.3¡¢ÍÑ»ú±¸·ÝÓëÁª»ú±¸·Ý
ÍÑ»ú±¸·Ý£¨offline backup£©ÊÇÔÚÊý¾Ý¿â¹Ø±ÕʱÉú³ÉµÄ±¸·Ý¡£
Áª»ú±¸·Ý£¨online backup£©ÊÇÔÚÊý¾Ý¿âÕý±»Ê¹ÓÃʱÉú³ÉµÄ±¸·Ý¡£
Áª»ú±¸·Ý¿ÉÒÔÊÇÈ«²¿±¸·Ý£¬Ò²¿ÉÒÔÊDz¿·Ö±¸·Ý£¬²¢ÇÒÄܹ»Í¨¹ýʹÓÃRMAN»ò²Ù×÷ϵͳÃüÁîÀ´Íê³É¡£²»¹ý£¬Áª»ú±¸·ÝÖ»ÓÐÔÚÊý¾Ý¿âλÓÚarchivelogģʽÖвÅÄܽøÐС£ÔÚÁª»ú±¸·ÝÆڼ䣬ÒòΪ´æÔÚ¶îÍâµÄ´ÅÅ̻£¬ËùÒÔÊý¾Ý¿âÐÔÄÜ»áÍË»¯¡£
2.4¡¢Ó³Ïñ¸±±¾Ó뱸·Ý¼¯
Ó³Ïñ¸±±¾£¨image copy£©ÊÇij¸öÎļþµÄ±¸·Ý£¬²¢ÇÒÿ¸ö×Ö½Ú¶¼ÓëÔ´ÎļþÏàͬ¡£
±¸·Ý¼¯£¨backup set£©ÊÇÓÉRMANÉú³ÉµÄÒ»ÖÖרÓнṹ¡£ÕâÊÇÒ»ÖÖÓÉÒ»¸ö»ò¶à¸ö±»³ÆΪƬ£¨piece£©µÄÎïÀíÎļþËù×é³ÉµÄÂß¼½á¹¹¡£±¸·ÝƬ°üº¬ÁËÒ»¸ö»ò¶à¸öÊý¾Ý¿âÎļþ£¬ÕâЩÊý¾Ý¿âÎļþ¿ÉÒÔÊÇÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ»ò¹éµµÈÕÖ¾Îļþ¡£3ÖÖ
Ïà¹ØÎĵµ£º
ÓÃjpa²»Äܽ¨±í£¬sqlÓï¾äÊǶԵģ¬²»¹ý¾ÍÊDz»Äܽ¨£¬Í¬ÑùµÄsql£¬ÔÚÏÂÃæµÄjdbcÖоͿÉÒÔ£¬¿ÉÄÜÊÇ¿ò¼ÜµÄÏÞÖÆ£¬Ï£Íû¸ßÈËÖ¸µã
import java.net.URL;
import java.sql.*;
public class Create {
public Create() {
}
public static void main(String[] args){
String url = "jdbc:oracle:thin:@10.0.1.3:1521:SDCDB" ......
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfile [group 4]
sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;
4.adding online re ......
1 Éè¼Æ±í¹ý³ÌÖÐ ¾¡Á¿²ÉÓÃÊý¾ÝÇý¶¯Ë¼Ïë
±ÈÈç˵Óû§×¢²á ÒòΪҵÎñÇé¿ö ÐèÒª4¸ö×ֶβ»Í¬×éºÏÀ´±íʾÓû§´ÓÄÄÀï×¢²áµÄ¡£ ÒµÎñ²¿ÐèÒª²»¶ÏÀ©Õ¹ÐµÄÇþµÀÀ´ÕÐÀ¿Óû§£¬±ÈÈçÔÚij¸öÍøÕ¾×öÁ˹ã¸æ¡£¶ø²»ÄÜÔÚÒµÎñ³ÌÐò»ò´æ´¢¹ý³ÌÖ±½ÓÐÞ¸Ä
update f_userinfo
set f_regchannel='ÐÂÀËÊ ......
OracleÈëÃÅÊé¼®ÍƼö
ºÜ¶àÅóÓÑÒªÎÒ°ïæÍƼöÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......