Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

Oracleº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
        A         A      ZERO     ......

ORACLE UNDO ¡¶ÉîÈëdz³öORACLEµÚÆßÕ¡·

Èç¹û˵RedoÊÇÓÃÀ´±£Ö¤ÔÚ¹ÊÕÏʱÊÂÎñ¿ÉÒÔ±»»Ö¸´£¬ÄÇôUndoÔòÊÇÓÃÀ´±£Ö¤ÊÂÎñ¿ÉÒÔ±»»ØÍË»òÕß³·Ïú¡£
ÔÚÐ޸IJÙ×÷ÖУ¬¶ÔÓÚ»ØÍ˶εIJÙ×÷´æÔÚ¶à´¦£¬ÔÚÊÂÎñ¿ªÊ¼Ê±£¬Ê×ÏÈÐèÒªÔڻعö¶Î±í¿Õ¼ä»ñµÃÒ»¸öÊÂÎñ²Û£¬·ÖÅä¿Õ¼ä£¬È»ºó´´½¨Ç°¾µÏñ£¬´ËºóÊÂÎñµÄÐ޸IJÅÄܽøÐУ¬Oracle±ØÐëÒÔ´ËÀ´±£Ö¤ÊÂÎñÊÇ¿ÉÒÔ»ØÍ˵ġ£
Èç¹ûÓû§Ìá½»ÁËÊÂÎñ£¬Oracle»á ......

oracle ·ÖÎöº¯Êýover() £¨Ò»£©

 Ô­ÎĵØÖ·£ºhttp://blog.csdn.net/cnham/archive/2009/08/30/4500928.aspx
oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÍ¨¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ ......

Oracle Top N ºÍ OracleÖеÄlimitÎÊÌâ½â¾ö·½°¸

oracle top N
1.ÔÚORACLEÖÐʵÏÖSELECT TOP N
   ÓÉÓÚORACLE²»Ö§³ÖSELECT TOPÓï¾ä£¬ËùÒÔÔÚORACLEÖо­³£ÊÇÓÃORDER BY¸úROWNUMµÄ×éºÏÀ´ÊµÏÖSELECT TOP NµÄ²éѯ¡£
¼òµ¥µØËµ£¬ÊµÏÖ·½·¨ÈçÏÂËùʾ£º
      SELECT¡¡ÁÐÃû£±£®£®£®ÁÐÃû£î¡¡from
        ......

oracleµÄ9¸öname

OracleµÄ9¸ö_name
2008-07-17 23:47
1¡¢db_name Êý¾Ý¿âÃû
¡¡¡¡SQL> connect xys/manager as sysdba
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> show user
¡¡¡¡USER Ϊ "SYS"
¡¡¡¡SQL> show parameter db_name
¡¡¡¡NAME TYPE VALUE
¡¡¡¡---- -------- ------------
¡¡¡¡db_name string test1
¡¡¡¡db_nameÊÇÊý¾Ý¿âµÄÃû×Ö£¬or ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ