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 ......
1.ÊÂÎñ¸ÅÊö
ÊÂÎñ£¨Transaction£©ÊÇÊý¾Ý¿âÇø±ðÓÚÎļþϵͳµÄÌØÐÔÖ®Ò»¡£ÔÚÎļþϵͳÖУ¬Èç¹ûÄãÕý°ÑÎļþдµ½Ò»
°ë£¬²Ù×÷ϵͳͻȻ±ÀÀ£ÁË£¬Õâ¸öÎļþ¾ÍºÜ¿ÉÄÜ»á±»ÆÆ»µ¡£²»´í£¬È·Êµ»¹ÓÐһЩ“ÈÕ±¨Ê½”£¨journaled£©Ö®
ÀàµÄÎļþϵͳ£¬ËüÃÇÄܰÑÎļþ»Ö¸´µ½Ä³¸öʱ¼äµã¡£²»¹ý£¬Èç¹ûÐèÒª±£Ö¤Á½¸öÎļþͬ²½£¬ÕâЩÎļþϵͳ ......
oracle top N
1.ÔÚORACLEÖÐʵÏÖSELECT TOP N
ÓÉÓÚORACLE²»Ö§³ÖSELECT TOPÓï¾ä£¬ËùÒÔÔÚORACLEÖо³£ÊÇÓÃORDER BY¸úROWNUMµÄ×éºÏÀ´ÊµÏÖSELECT TOP NµÄ²éѯ¡£
¼òµ¥µØËµ£¬ÊµÏÖ·½·¨ÈçÏÂËùʾ£º
SELECT¡¡ÁÐÃû£±£®£®£®ÁÐÃû£î¡¡from
......
¹éµµÈÕÖ¾Îļþ£ºÊÇ´¦Óڷǻ£¨INACTIVE£©µÄ״̬µÄÖØ×öÈÕÖ¾ÎļþµÄ±¸·Ý¡£Ëü¶ÔORACLEÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÆðÖÁ¹ØÖØÒªµÄ×÷Óá£ÊÇÁª»úÖØ×öÈÕÖ¾ÎļþµÄÒ»¸ö¸±±¾£¬Óë±»¸´ÖƵijÉÔ±Íê³ÉÒ»Ñù£¬¼´ÖØ×ö¼Ç¼Ïàͬ£¬ÈÕÖ¾ÐòÁкÅÏàͬ¡£
Ò»¡¢Êý¾Ý¿âµÄ¹éµµÓë·Ç¹éµµÄ£Ê½£º
1£® µ±Êý¾Ý¿â´¦ÓÚNOACRCHIVELOGģʽʱ£¬²»¶ÔÖØ×öÈÕÖ¾Îļþ½ ......
ÉñÃØµÄ ORACLE DUAL±í
DUAL ? ÓÐʲôÉñÃØµÄ? µ±ÄãÏëµÃµ½ORACLEϵͳʱ¼ä, ¼ò¼òµ¥µ¥ÇÃÒ»ÐÐSQL¡¡
¡¡¡¡
¡¡¡¡²»¾ÍµÃÁËÂð? ¹ÊŪÐþÐé….¡¡
¡¡¡¡
¡¡¡¡SQL> select sysdate from dual;¡¡
¡¡¡¡
¡¡¡¡SYSDATE¡¡
¡¡¡¡
¡¡¡¡———¡¡
¡¡¡¡
¡¡¡¡28-SEP-03¡ ......