ORACLE STANDBYѧϰʵ¼ù¿Æѧ·¢Õ¹¹ÛÐĵÃÌå»á
ʵ¼ùµÚÒ»½²£º
Ãû´Ê½âÊÍ£º
dataguard£ººÇºÇ ORACLE¸ß¿ÉÓÃÌåϵÖÐÈý¼ÜÂí³µÖ®Ò»£¨RAC¡¢STREAM£©¡£¸ÉÂïÓã¿£¿£¿¾ÍÊÇÒìµØ±¸·Ý¡¢ÈÝÔÖʲôµÄ¡£Ê²Ã´ÔÀí£¿£¿==ÁĹþ¡£
primary:Êý¾ÝĸÌå
standby:Êý¾ÝĸÌåµÄ¿½±´»ò±¸·Ý»ò¿Ë¡£¨Ö»ÄÜ¿Ë9¸ö Ϊʲô ÒªÎÊORACLE Ϊʲô log_archive_dest_n Õâ¸öÄãNµÄÉÏÏÞÊÇ10ඣ©
ʵ¼ùµÚ¶þ¼þ£º
ʵ¼ù¼ìÑéÕæÀíµÄΨһ±ê×¼£º
ÏÈ˵ Õâ¸östandbyÔõôÀ´µÄ¡£¡£¿´¹ý¾ýÈý˼ÄÇѾµÄBLOGÂð£¬Ñ¾µÄ»¹³öÊ飬Åå·þ°¡¡£²»ÖªµÀ°¡ ÄÇѾµÄ дÁ˺ܶà È¥¿´¿´°É¡£¡£¡£Òª²» ÖªµÀRMAN duplicate,ÔÙ²»ÐÐ ¾øÕоÍÊÇCOPY¡£
ÎÒÊÇÕâô¸ãŶ¡£¡£¡£
Ïȱ¸·ÝÊý¾Ý¿â and ¹éµµÈÕÖ¾¡£COPYµ½standbyÄǸö±¸»úÉÏ¡£Â·¾¶ÒªÒ»Ö¹þ¡£
primary Éú³ÉstandbyµÄ¿ØÖÆÎļþ£ºalter database create standby controlfile as '***.ctl',Ò»Ñù¿½±´¹ýÈ¥£¬Ò»ÑùµÄ·¾¶¡£
Õâ¸ö¶«¶«ÄãÔÚrmanÖÐ list copy ÄÜÕҵõ½¡£
½ÓÏÂÀ´ ¾ÍÊÇ×î×îÖØÒªµÄÄØ£¿£¿£¿
ʲôÄØ£¿£¿Äã²Âprimary ºÍn¸östandbyËüÃÇÊÇÔõô¸ö´î½¨ÒìµØ±¸·ÝµÄÌåϵ¡£
oracleÓÐÁ½¸ö¶«Î÷²»´í£º¹éµµÈÕÖ¾¡¢Áª»úÈÕÖ¾¡££¨ËüÃÇÇø±ð ÖªµÀ°É¡£¡££©
primaryÔڹ鵵Ï£¨ÍæÕâ¸ö±ØÐëÒª¹éµµÄ£Ê½£¬Òª²»Ã»¸ãÍ·£©²»¹Ü¸ÉÂïÁË ¶¼Òª¼ÇÕË¡£×öÍêÁ˾Íͨ¹ý¿ìµÝ¹«Ë¾Ë͵½¸÷¸ö·Ö¶æ¡£¸÷¸ö·Ö¶æ½Óµ½Á쵼ָʾ£¬¾Í¹á³¹Áìµ¼¾«Éñ£¬Ò»Ä£Ò»ÑùµÄ¸ãÒ»±é¡£ºÇºÇÔÀí¾ÍÕâÑù¡£
ÄDzÎÊýÔõôÅä¡£¡£¡£¡£¼¸¸öÒªµã£º½Úµã¼äͨÐÅ£¬Äǿ϶¨ÒªÅäÖÃnetworkÂȻºó¾Í¸ÃÔÚ½ÚµãÃǵIJÎÊýÎļþÀï¼ÓÉϼ¸¸ö²ÎÊý£º
db_unque_name
log_archive_config
log_archive_dest_n
log_archive_dest_state_n
fal_server
fal_client
×¢Ò⣺һ¸ödataguardϵÄËùÓнڵãµÄdb_nameÒªÒ»Ö¡£¼ÈÈ»ÊÇͨÐÅ£¬ÄÇÎÒÓ¦¸ÃÒªÖªµÀ¶Ô·½µÄÀ´Í·£¬ÐÕʲô¡£Õâ¸öÈËÔÚÄãµÄnetworkÖж¨Òå¹ýÁË£¬¾ÍÊÇËûÁË¡£²»ÊÇʲôʵÀýÃû»ò·þÎñÃûŶ ÎÒ±»¾ýÈý˼Îóµ¼¹ý¡£¡£¡£ºÇºÇ ÈË·ÇÊ¥ÏÍ£¬ÊëÄÜÎÞ¹ý¡£
¶¼ºÃÁË¡£¡£»¹ÓÐÒ»¸öÊÂÍüÁË£¨½ÚµãµÄsysÃÜÂëÒªÒ»Ö£¬²»Ò»Ö°¡ Äã¾ÍÖØж¨Ò壩ÄÇ¾Í duplicate target database for standby.
¡£¡£¡£¡£¡£¡£Îҵȡ£¡£¡£¡£¡£
ºÃÁË ¹§Ï² ³É¹¦Ò»Ð¡²½¡£¡£¡£¡£
½ÓÏÂÀ´ ¿´Äã¾ö¶¨dataguardµÄ±£»¤Ä£Ê½£¬ÒªÇó¸ßÁË ¾ÍÔÚstandbyÉϽ¨¼¸¸östandby log£¬ÕâÀïÎÒÑ¡Ôñ ×î´óÐÔÄÜµÄ ²»½¨ÁË¡£
¼ÌÐø¹þ¡£¡£¡£
ÔÚstandbyÉÏÖ´ÐÐͬ²½£ºrecover managed standby database disconnect from session.
OK!!!·Ö±ðÈ¥Ö÷»úºÍ±¸»úÉϼìÑéÀͶ¯³É¹û¡£
Ôõô¿´¡£¡£¡£¡£select switchover_status fr
Ïà¹ØÎĵµ£º
Ò»¸öÏîÄ¿ÐèÒªDB2£¬ÒÔǰûÓùý£¬ÓÃÁËWINDOWS 2008ϵÄDB29.7 ºÃ¼¸ÖÜ£¬ËãÈëÃÅÁË°É£¬ÏÂÃæÕâÎÄÕ¾͵±Ò»¸öORACLEʹÓÃÕßÑÛÀïµÄDB2µÄÓ¡Ïó°É£¬Ò²ÐíÓÐЩ¶«Î÷¿ÉÄÜÓÐÆ«²î£¬µ«ÊǾÍÊÇÎÒ×Ô¼ºµÄÓ¡Ïó£º
1¡¢Ìåϵ½á¹¹£¬DB2µÄʵÀýºÍÊý¾Ý¿â·Ö¿ªµÄ×ö·¨£¬ÎÒ¸öÈË»¹ÊDZȽÏϲ»¶µÄ£¬ÒòΪʵÀý¿ÉÒÔ´´½¨¶à¸ö£¬Êý¾Ý¿âµÄ»Ö¸´Ö±½Ó»Ö¸´µ½ÊµÀýϾͿÉÒÔÁË£¬Ïච......
ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊÇ°²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔϾÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄ ......
oracleÊý¾Ý¿âͬ²½
ÔÚÁ½Ì¨oracleÊý¾Ý¿âÖ®¼ä²âÊԳɹ¦£¬ÏÂÃæ¾Í×ܽáһϰɣº
ÐèÇó£º
ÏÖÓÐÁ½Ì¨oracleÊý¾Ý¿â·þÎñÆ÷AºÍB(A,B¿ÉÒÔÊÇÔÚͬһÄÚÍø£¬Ò²¿ÉÒÔÊÇÔÚ»¥ÁªÍøÉϵÄÁ½Ì¨¶ÀÁ¢»úÆ÷)¡£AºÍBÀïÓж¼ÓÐtestable±í£¬½á¹¹Ò»Ñù£¬ÏÖÐèÒªµ±A¿âÖеÄtestable±í±ä»¯Ê±£¬B¿âÀïµÄtestableÒ²ÏàÓ¦±ä»¯Êý¾Ý
ÎҵĽâ¾ö·½°¸£º
ÔÚAÖн¨Á¢µ½B¿âµÄ ......
ÔÎĵØÖ·oracle lock
1ÓÃPerl TKÄ£¿é ²éѯDBÖеÄLOCK
use DBI;
use Tkx;
use DBD::Oracle qw(:ora_session_modes);
$mw = Tkx::widget->new(”.”);
$mw->g_wm_title(”Oracle Lock”);
$content = $mw->new_ttk__frame(-padding => “5 5 12 0″);
$content->g_grid ......