Ê×Ò³ | ¹«Ë¾¼ò½é | Êý¾Ý»Ö¸´ | ±¸·Ý·þÎñ | ³É¹¦°¸Àý | ¼¼ÊõÖÐÐÄ | ¿Í»§·þÎñ | ·þÎñ±¨¼Û | Êý¾Ý»Ö¸´Èí¼þ | ÁªÏµÎÒÃÇ | ±±ÑDz©¿Í  
 
  ±±¾©×ܲ¿£º 4006-505-646
  Ìì ½ò ²¿£º 4006-505-646
  ÉÏ º£ ²¿£º 4006-505-646
  Éî ÛÚ ²¿£º 4006-505-646
  ¹ã ÖÝ ²¿£º 4006-505-646
  ÖØ Çì ²¿£º 4006-505-646
  ÄÏ ¾© ²¿£º 4006-505-646
  ÆäËüµØÇø£º 4006-505-646
±±ÑÇÊý¾Ý»Ö¸´Èí¼þWindowsרҵ°æ
ÈýÐÇÊÖ»úÊý¾Ý»Ö¸´Èí¼þV1.0
±±ÑÇÆ»¹ûÊÖ»úÊý¾Ý»Ö¸´Èí¼þV2.0
±±ÑÇÓ²Å̼Ïñ»úÊý¾Ý»Ö¸´Èí¼þ V
±±ÑÇvmwareÐéÄâ»úÊý¾Ý»Ö¸´Èí¼þ
±±ÑÇÕÕÆ¬Êý¾Ý»Ö¸´Èí¼þ
±±ÑÇÉãÏñ»úÊý¾Ý»Ö¸´Èí¼þ v2.1
±±ÑÇSybaseÊý¾Ý¿âÐÞ¸´Èí¼þ V2.
raid´ÅÅÌÕóÁÐÓ¦¼±·½°¸
HP EVA4400/6400/8400/P6000
iphone Í¨Ñ¶Â¼¶ªÊ§ÈçºÎ»Ö¸´£¿
xen server ´æ´¢¿â(sr)Ë𻵺ó
RAID6½á¹¹Ô­ÀíÏê½â£¨±±ÑÇÊý¾Ý
AIXÏÂɾ³ýLVºóµÄÏÖ³¡±£»¤ºÍÊý
RAIDË𻵺ó ¶ÔÊý¾ÝµÄÍêÕû±¸·Ý
Äúµ±Ç°µÄλÖãºÊ×Ò³ >> ¼¼ÊõÖÐÐÄ >> Êý¾Ý¿âÐÞ¸´ÎÄÀ¸ >> ÕýÎÄ

Linux 9iÏÂDataguardÅäÖÃ


¾ßÌå²½Ö裺
3.1  ÔÚstandbyµÄ/home/oracle/oradataÏ£¬Ô­À´ÓÐÒ»¸öoracleµÄÎļþ¼Ð£¨ÀïÃæÊǸÃÖ÷»úϵÄdbf£¬redologÎļþ£©£¬ÔÙн¨Ò»¸öprimaryÎļþ¼Ð¡£½«primaryÖ÷»úµÄoradata.tar½â¿ªµÄÎļþÈ«²¿Ö±½Ó£¨¼´primary²»ÒªÔÙÓÐÎļþ¼Ð£©·Åµ½primaryÏ£¬½«¸ÕÉú³ÉµÄ±¸ÓÿØÖÆÎļþ(/home/oracle/standby.ctl)Ò²·Åµ½primaryÏ¡£

3.2 ÔÚstandbyµÄORACLE_HOME/dbs/Ï£¬ÏȽ«ÒÔǰµÄorapworacle±¸·ÝÒ»ÏÂ(¸Ä¸öÃû×Ö¼´¿É)£¬ÔÙ½«primaryµÄ$ORACLE_HOME/dbs/ϵÄorapworacle Îļþftp·Åµ½standbyµÄORACLE_HOME/dbs/ÏÂ.
˵Ã÷һϣ¬ÎÒÔÚ²éÔÄeygleµÄ´ó×÷¼°ºÜ¶àÈ˵ÄÏà¹ØÎÄÕ£¬¶¼Ã»ÓÐÌáµ½ÕâÒ»µã£¬µ«Èç¹ûû×öÕâÒ»²½µÄ»°£¬ÔÙºóÃæµÄÆô¶¯±¸ÓÃÊý¾Ý¿âµÄʱºò£¬¼´ÔÚ
[oracle@eygle primary]$ sqlplus "/ as sysdba"
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect from session;
ÕâÒ»²½Ê±¾Í»á±¨ORA-01991 ´íÎó£¬ËµÊÇInvalid passwd file.ѯÎÊÎÒÃǵÄdba£¬ËµÊDZØÐëÒªÓÃprimaryµÄorapworacleÀ´Ìæ»»standbyµÄ. ÎÒÊÔ¹ý£¬ÕâÑù×öÁ˺ó¾ÍOKÁË¡£
ËùÒÔÎÒÕâÔÚÕâÀï¾Í°ÑprimaryµÄorapworacleÀ´Ìæ»»standbyµÄorapworaclÒ²µ±×÷Ò»²½±ØÐë²½Ö裬µ«ÎÒÕæµÄ²»Äܿ϶¨ÕâÒ»²½ÊÇ·ñÊDZØÐëµÄ£¬Èç¹û²»ÊDZØÐëµÄ£¬ÎªºÎÎÒ×öÕâÒ»²½£¬×ܻᱨ´í¡£Èç¹ûÊDZØÐëµÄ£¬ÎªºÎeygleºÍÆäËû´óÅ£µÄ´ó×÷ÀﶼûÓÐÌáµ½ÕâÒ»²½£¬ÄѵÀÊÇÒòΪÕâ¸öÌ«¼òµ¥Â𣿣¿ ÎÒÕæµÄÊÇÓÐЩÒÉ»ó¡£Èç¹ûÄÄλ´óÅ£¿´µ½Õ⣬Çë¸øÎÒÒ»¸ö¿Ï¶¨µÄ»Ø´ð£¬ÎÒ²»Ê¤¸Ð¼¤¡£

ÔÚstandbyÖ÷»úµÄ$oracle/home/adminÏÂÔ­À´ÓÐoracleĿ¼¡£ÏÖÔÚн¨
primaryĿ¼£¬ÔÙÔÚprimaryĿ¼ÏÂн¨bdump,cdump,udump.
PrimaryµÄ²ÎÊýÎļþ

oracle@primary_andy $cat  .bash_profile
# .bash_profile

# Get the aliases and functions
#if [ -f ~/.bashrc ]; then
#       . ~/.bashrc
#fi

# User specific environment and startup programs
#export BASH_ENV=$HOME/.bashrc

PATH=$PATH:/home/oracle/product/9.2.0/bin:$oracle_home/jre/bin:/opt/SUNWspro/bin:/usr/bin:/usr/ccs/bin:/usr/ucb:/etc:/usr/local/bin:/usr/bin/saved:
export PATH
unset USERNAME
ORACLE_OWNER=oracle
ORACLE_BASE=/home/oracle
export ORACLE_BASE
ORACLE_HOME=/home/oracle/product/9.2.0
export ORACLE_HOME
LANG=
LC_ALL=
ORACLE_SID=oracle
export ORACLE_SID

TNS_ADMIN=/home/Oracle/config/9.2.0; export TNS_ADMIN
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
#ORA_NLS33=$Oracle_HOME/ocommon/nls/admin/data; export ORA_NLS33
CLASSPATH=$Oracle_HOME/JRE:$Oracle_HOME/jlib:$Oracle_HOME/rdbms/jlib:/opt/j2sdk_nb/j2sdk1.4.2/bin
export CLASSPATH
TMPDIR=/tmp;export TMPDIR
umask 022
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/lib/tls:/lib/i686:/usr/openwin/lib:/usr/dt/lib
export LD_LIBRARY_PATH
export LD_PRELOAD=/home/oracle/libcwait.so;
export LD_ASSUME_KERNEL=2.4.19;
DISPLAY=1.1.1.3:0.0;export DISPLAY;
export PS1="\u@\H $"

#cat initoracle.ora_primary
*.aq_tm_processes=1
*.background_dump_dest='/home/oracle/admin/oracle/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/home/oracle/oradata/oracle/control01.ctl','/home/oracle/oradata/oracle/c
ontrol02.ctl','/home/oracle/oradata/oracle/control03.ctl'
*.core_dump_dest='/home/oracle/admin/oracle/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oracle'

±¾ÐÂÎŹ²5Ò³,µ±Ç°ÔÚµÚ3Ò³  1  2  3  4  5  

ÉÏһƪ£ºMySQL SQL ProfilerÐÔÄÜ·ÖÎöÆ÷
ÏÂһƪ£ºAIXÏÂ×Ö·û½çÃæ°²×°oracle 10g¹ý³Ì
·µ»ØÊ×Ò³ | ÁªÏµÎÒÃÇ | ¹ØÓÚÎÒÃÇ | ÕÐÆ¸ÐÅÏ¢ | ÓÑÇéÁ´½Ó | ÍøÕ¾µØÍ¼ | ºÏ×÷»ï°é
°æÈ¨ËùÓÐ ±±¾©±±ÑÇå·ÐǿƼ¼ÓÐÏÞ¹«Ë¾
È«¹úͳһ¿Í·þÈÈÏߣº4006-505-646
±±¾©×ܲ¿£º±±¾©Êк£µíÇøÓÀ·á»ùµØ·á»ÛÖз7ºÅвÄÁÏ´´Òµ´óÏÃB×ù205ÊÒ
¾©ICP±¸09039053ºÅ

D„