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 |