ʹÓÃOGGµÄ "Loading data from file to Replicat"µÄ·½·¨Ó¦¸Ã×¢ÒâµÄÎÊÌ⣺replicat½ø³ÌÊÇǰ̨½ø³Ì
Òò´Ë£¬×îºÃÊÇÔÚvncserverÖе÷ÓøÃreplicat½ø³Ì»òÕßÒÔnohup·½Ê½·ÅÔÚºǫ́ÔËÐС£ÏÂÃæµÄÊÇʹÓÃnohup·½Ê½·ÅÔÚºǫ́ÔËÐС£
[oracle@lei1 ~]$ ll rep_backgroud.sh -rwxr-xr-x 1 oracle oinstall 98 Jun 2 03:02 rep_backgroud.sh [oracle@lei1 ~]$ cat rep_backgroud.sh cd /u02/ggs --->×¢Òâ´ËÐУ¬²»¿ÉÊ¡ÂÔ£¬/u02/ggsÊÇOGGµÄ°²×°Ä¿Â¼ replicat paramfile /u02/ggs/dirprm/repftor.prm reportfile /u02/ggs/dirrpt/REPFTOR.rpt [oracle@lei1 ~]$ [oracle@lei1 ~]$ nohup sh /home/oracle/rep_backgroud.sh &
?
=====================¶Ï¿ªsecurecrt£¬ÔÙÖØÐÂÁ¬½Ósecurecrt================================
?
[root@lei1 ~]# ps -ef | grep rep oracle 22585 1 0 03:03 ? 00:00:00 sh /home/oracle/rep_backgroud.sh oracle 22586 22585 5 03:03 ? 00:00:02 replicat paramfile /u02/ggs/dirprm/repftor.prm reportfile /u02/ggs/dirrpt/REPFTOR.rpt root 22628 22603 0 03:04 pts/1 00:00:00 grep rep [root@lei1 ~]#
?
×¢Òâµã£º
1.ÈôÊÇÒÔǰ̨½ø³ÌµÄ·½Ê½Ö´ÐеĸÃreplicat½ø³Ì£¬ÖÐ;¶Ï¿ªÁËsecurecrt£¬È»ºóÔÚÄ¿µÄ±í£¨ÔÚ/u02/ggs/dirprm/repftor.prmÖж¨ÒåµÄ£©ÖÐÊÇ´æÔÚ²¿·Ö¼Ç¼µÄ¡£ÖØÐ·¢Æðreplicat½ø³Ìǰ£¬ÐèÒªtruncate¸ÃÄ¿µÄ±í¡£
2. OGG"Loading data from file to Replicat"·½·¨µÄºËÐÄÊÇ£º
extract½ø³Ì--->trail file£¨Â䵨Îļþ,ÔÚ³éÈ¡½ø³ÌµÄ²ÎÊýÎļþÖж¨ÒåλÖã©-->Ä¿µÄ¶Ëtable£¨rep½ø³ÌÓ¦ÓÃtrail file µ½Ä¿µÄ¶ËtableÖУ©
3.´ËʱµÄextract½ø³ÌÓ¦¸ÃÒ²ÊÇǰ̨½ø³Ì£¬²»¹ýÎÒ²âÊÔʱûÓжϿªsecurecrt£¬Ã»ÓÐÊÔÑé¹ý¡£
?