Oracle dataguardÅäÖÃStep by Step
Ò»¡¢×¼±¸¹¤×÷
1.1 ÉèÖÃÖ÷¿âµÄforce loggingģʽ
SQL> alter database force logging;
Database altered.
1.2 ´´½¨Ö÷¿âÃÜÂëÎļþ
$ orapwd file=orapw$ORACLE_SID password=thunis entries=4
1.3 ÅäÖÃÖ÷¿âstandby redo log£¬²¢ÑéÖ¤½á¹û
SQL> alter database add standby logfile group 4('/u01/app/oradata/guard1/redo04.log') size 50m;
Database altered.
SQL> select group#, thread#, sequence#, archived, status from v$standby_log;
GROUP# THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- --- ----------
4 0 0 YES UNASSIGNED
1.4 ÅäÖÃÖ÷¿â³õʼ»¯²ÎÊýÎļþ
DB_NAME=guard1
DB_UNIQUE_NAME=guard1
LOG_ARCHIVE_CONFIG='DG_CONFIG=(guard1,guard2)'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/flash_recovery_area/GUARD1/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=guard1'
LOG_ARCHIVE_DEST_2='SERVICE=guard2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=guard2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
/*ÒÔϲ¿·ÖΪÖ÷»úÇл»Îª±¸¿âʹÓÃ*/
FAL_SERVER=guard2
FAL_CLIENT=guard1
DB_FILE_NAME_CONVERT='guard2','guard1'
LOG_FILE_NAME_CONVERT='/u01/app/oradata/guard2','/u01/app/oradata/guard1'
STANDBY_FILE_MANAGEMENT=AUTO
1.5 È·ÈÏÖ÷¿âµÄ¹éµµÄ£Ê½
SQL> startup mount
ORACLE instance started.
Total System Global Area 104857600 bytes
Fixed Size &n
Ïà¹ØÎĵµ£º
1)SQL ServerÁ´½Ó·þÎñÆ÷ Linked Server·½Ê½£¨SQLServer×÷ΪԴ·þÎñÆ÷£©£º
http://www.cnblogs.com/riccc/archive/2009/07/23/sql-server-linked-server.html
2)Oracle¸ß¼¶¸´ÖÆ£¨oracleÊý¾Ý¿âÖ®¼ä¸´ÖÆ£©£º
http://www.chinaunix.net/bbsjh/8/54.html
ÆäËû¼¼Êõ·½·¨£º
snapshot
Replication ......
RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......
1.ÊÂÎñ¸ÅÊö
ÊÂÎñ£¨Transaction£©ÊÇÊý¾Ý¿âÇø±ðÓÚÎļþϵͳµÄÌØÐÔÖ®Ò»¡£ÔÚÎļþϵͳÖУ¬Èç¹ûÄãÕý°ÑÎļþдµ½Ò»
°ë£¬²Ù×÷ϵͳͻȻ±ÀÀ£ÁË£¬Õâ¸öÎļþ¾ÍºÜ¿ÉÄÜ»á±»ÆÆ»µ¡£²»´í£¬È·Êµ»¹ÓÐһЩ“ÈÕ±¨Ê½”£¨journaled£©Ö®
ÀàµÄÎļþϵͳ£¬ËüÃÇÄܰÑÎļþ»Ö¸´µ½Ä³¸öʱ¼äµã¡£²»¹ý£¬Èç¹ûÐèÒª±£Ö¤Á½¸öÎļþͬ²½£¬ÕâЩÎļþϵͳ ......
oracle µÄÔ¼ÊøÖ÷ÒªÊÇÔÚÒµÎñÂß¼²ãÃæÎ¬»¤Êý¾ÝµÄÍêÕûÐÔ¡£Ö÷Ҫͨ¹ý³ÌÐòÔ±ÔÚÓ¦ÓóÌÐòÖÐ¹æ¶¨Ô¼Êø»òÕßͨ¹ý¶¨Òå´¥·¢Æ÷À´Î¬»¤Êý¾ÝÍêÕûÐÔ£¬×îºóÊÇͨ¹ýʹÓÃoracle×Ô´øµÄÔ¼ÊøÀ´Î¬»¤Êý¾ÝÍêÕûÐÔ¡£ÄÜʹÓÃoracle×Ô´øµÄÔ¼Êø´ïµ½ÒªÇó¾Í¾¡Á¿Ê¹ÓÃoracle×Ô´øµÄÔ¼Êø£¬ÒòΪʹÓô¥·¢Æ÷µÈÓû§×Ô¶¨ÒåÔ¼Êø¶¼»áÓ°ÏìÊý¾Ý¿âµÄÐÔÄÜ¡£ÀýÈ磺ʹÓô¥·¢ ......
µ¼ÈëÊý¾ÝµÃʱºò£¬Óöµ½Ò»¸öÎÊÌ⣬Ïë°ÑÁÐÃû˳Ðò¸Ä±äһϡ£ÔÚÍøÉÏËÑË÷µ½ÕâÆªÎÄÕ£¬Ã»È¥ÊÔÑé¡£ÌùÉÏÀ´£¬ÒÔºóÓлú»áÊÔÑéÏ¡£
£¨http://www.im80hou.com/html/oracle/2009/0710/712.html£©
°´ÕÕ¹ØÏµÊý¾Ý¿âµÄÀíÂÛ£¬ÐÐÓëÁж¼ÊÇÎÞÐòµÄ£¬µ«ÔÚʵ¼ÊÓ¦ÓÃÖÐÓÐʱÐèҪȷ¶¨ÁеÄ˳Ðò¡£µ«ÔÚOracleÖУ¬Ò»µ©±í¶¨ÒåºÃ£¬ÔÙÏëÐÞ¸ÄÁеÄ˳Ðò¿ ......