oracle µÄ±¸·ÝÓë»Ö¸´
oracle ³ýÁËimp ºÍexp£¬»¹Óв»Òª¹¤¾ß Íâ »¹ÓÐûÓÐÆäËûµÄ±¸·Ý·½·¨£¿
RMAN£¬»Ö¸´¹ÜÀíÆ÷¡£ÎïÀíÈȱ¸£¬ÕæÕýµÄ±¸·Ý/»Ö¸´·½°¸¡£
DATA GUARD£¬standby database
´Å´ø±¸·Ý,2ÌìÒ»´Î,ÎÒÃÇÕâ
ºÇºÇ£¬¿½±´Îļþµ½Òƶ¯Ó²ÅÌÀï
Õâ¸öÎÊÌâÓÐµãÆæ¹Ö¡£¡£¡£
ÊÇ˵e/i²»Ë㹤¾ßô
impdp ºÍexpdp »ù±¾ºÍimp/exp ²î²»¶à£¬Ö»ÊÇËÙ¶È¿ìµã
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......