OracleÖг£ËµµÄHA¡¢RAC¡¢DataguradµÄÇø±ð
HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨Èí¼þµÄ¸ß¿ÉÓã¬Ó²¼þµÄ¸ß¿ÉÓã¬ÍøÂçµÄ¸ß¿ÉÓõȵȡ£¾ßÌåʵÏֵķ½°¸°üÀ¨²Ù×÷ϵͳµÄ¼¯Èº£¬Êý¾Ý¿âµÄ¼¯Èº£¬Ó²¼þµÄÈßÓà£¬ÍøÂçµÄÈßÓàµÈµÈ¡£
×öHA·½ÃæµÄÈí¼þ£¬ÓÐIBMµÄHACMP£¨ºÜ¶à³£ÓÃAIXµÄÈË£¬³£ËµµÄHA¾ÍÖ¸HACMP£¬ÂÒ°¡£©¡¢SUNµÄSun
Cluster¡¢HPµÄMC/SGµÈ¡£
ÔÚ2000ÄêÒÔǰ£¬´ó¼Ò̸HA£¬´ó²¿·Öʱºò˵µÄÊDzÙ×÷ϵͳһ¼¶µÄË«»úÈȱ¸£¬Ö÷Á÷²úÆ·µ±Ê±ÓÐIBM
HACMP4.1£¬HPµÄMC/SGɶ°æ±¾ÍüÁË£¬sunµÄϵͳºÜ¶àÈ˲»ÓÃVCS£¬ÓõÄÊÇÒ»¸ö½ÐdatawareµÄ¶«Î÷¡£ÏÖÔںܶàÈËÑÛÖеÄHAÒ²»¹ÊÇÕâÑù¡£
ʱÖÁ½ñÈÕ£¬HA°üÀ¨µÄ¶«Î÷¿É¾Í¶àÁË£¬ÏȲ»ËµÆäËû·½Ã棬µ¥¾ÍÊý¾Ý¿â£¬µ¥¾ÍOracle£¬ÓëHAÏà¹ØµÄ²úÆ·ÏȺóÓУº¸ß¼¶¸´ÖÆ
£¨AdvanceRepication)¡¢OPS/RAC(Real Application Cluster£©¡¢Êý¾ÝÎÀÊ¿£¨Data
Guard£©¡¢oracleÁ÷£¨Oracle Streams£©¡¢·ÖÇø£¨Oracle
Partition£©ÕâÑùÊý¿î²úÆ·¡£ÕÕÕâô˵£¬RACÖ»ÊÇHAÕâ¸ö¸ÅÄîϵÄÒ»¸ö¾ßÌå²úÆ·¶øÒÑ£¡Ä¿Ç°ÎªÖ¹£¬Ö»ÓÐRACºÍ·ÖÇøÊÇOracleÒªÊÕÈ¡
licenceµÄ£¬ÆäËûµÄ£¬Ö»Òª¸ø¾Ñé·á¸»µÄµÚÈý·½ÊµÊ©·½¸¶Ò»¶¨µÄ¹æ»®/Éè¼Æ¼°²¿Êð·ÑÓþͿÉÒÔÁË£»µ±È»£¬Ò²¿ÉÒÔ×Ô¼ºÕÕ×ÅÎĵµÒÀºù«»Æ°£¬µ«ÊÇÕâÑùŪ³öµÄ»·
¾³ÊÇ·ñÄÜ´ïµ½¸ß¿ÉÓþÍÄÑ˵ÁË¡£ÊÂʵÉÏ£¬´ó²¿·ÖÈËËù˵µÄHA£¬»¹ÊÇÏÁÒåÉϵÄHA£¬Ò²¾ÍÊÇOSÒ»¼¶µÄË«»úÈȱ¸¡£
RAC
ÊÇreal application
clusterµÄ¼ò³Æ£¬ËüÊÇÔÚ¶à¸öÖ÷»úÉÏÔËÐÐÒ»¸öÊý¾Ý¿âµÄ¼¼Êõ£¬¼´ÊÇÒ»¸ödb¶à¸öinstance¡£ËüµÄºÃ´¦ÊÇ
¿ÉÒÔÓɶà¸öÐÔÄܽϲîµÄ»úÆ÷¹¹½¨³öÒ»¸öÕûÌåÐÔÄܺܺõļ¯Èº£¬²¢ÇÒʵÏÖÁ˸ºÔؾùºâ£¬ÄÇôµ±Ò»¸ö½Úµã³öÏÖ¹ÊÕÏʱ£¬ÆäÉϵķþÎñ»á×Ô¶¯×ªµ½ÁíÍâµÄ½ÚµãÈ¥Ö´ÐУ¬Óû§Éõ
ÖÁ¸Ð¾õ²»µ½Ê²Ã´¡£
Ë«»úÈȱ¸£¨HA£©ºÍRACÓÐÉ¶Çø±ðÄØ?
1¡¢¶ÔÓÚÓ²¼þÀ´Ëµ£¬»ù±¾ÉÏÒ»Ñù£¬¹²Ïí´æ´¢¡¢¹âÏËÏߣ¨Ò²Óл¹ÓÃSCSIÏߵģ©¡¢¶ą̀СÐÍ»ú£¨¿ÉÒÔ×ö¶à½ÚµãµÄÏ໥Èȱ¸£¬Ò²¿ÉÒÔ×ö¶à½ÚµãµÄRAC£©¡¢¹âÏ˽»»»»ú
£¨Èç¹ûÊÇÓùâÏË¿¨µÄ»°£©£»µ«×öRAC£¬ÔÚÖ÷»úÖ®¼ä£¬×îºÃʹÓøߴø¿íÍøÂç½»»»»ú£¨ËäÈ»²»ÓÃÒ²¿ÉÒÔ×ö³É£©£»Òò´ËÓ²¼þ³É±¾Ïà²î²»´ó¡£
2¡¢Èí¼þÄØ£¬²î±ð¿É²»Ð¡¡£Èç¹ûÊÇË«»úÈȱ¸£¬±ØÐëÂò²Ù×÷ϵͳ¼¶µÄË«»ú¹ÜÀíÈí¼þ£»Èç¹ûÊÇRAC£¬Ä¿Ç°»¹Êǽ¨Ò鹺ÂòË«»ú¹ÜÀíÈí¼þ£¨¾¡¹Ü10gµÄcrs+asm¿É
Ïà¹ØÎĵµ£º
¶þ¡¢Ê¹ÓÃPrograms
¡¡¡¡ÔÚÂÛ̳ÖÐż¶û¼û¹ýÓÐÈËÌÖÂÛÈçºÎÔÚORACLEÖÐÖ´ÐвÙ×÷ϵͳÃüÁ»òÊÇORACLEÊý¾Ý¿âÍâµÄÓ¦Óá£Ó¦¸Ã˵ÔÚ9i¼°Ö®Ç°µÄ°æ±¾ÖУ¬ËäȻ˵²¢·ÇÍêÈ«ÎÞ·¨ÊµÏÖ£¨Æäʵ»¹ÊÇÓжàÖÖ·½Ê½Äܹ»±äÏàʵÏֵģ©£¬²»¹ý¸´ÔÓµÄʵÏÖ·½Ê½ÈÃDBAʹ¾¢ÁËÁ¦£¬ÉË͸ÁËÐÄ£¬·Ñ¾¢ÁËʶù¡£
¡¡¡¡½øÈë10g°æ±¾Ö®ºó£¬¾ÍÍêÈ«²»±ØÈç´Ë·ÑÉñ£¬ÒòΪÓÐÁËDBMS ......
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
Ç°ÃæÒ»Ö±³¢ÊÔoracleµÄÁª»ú±¸·Ý¶¼Ã»Óгɹ¦£¬³öÏÖÁË0 file(s) copied£¬½ñÌìÖÕÓÚ·¢ÏÖÁËÎÊÌâËùÔÚ£¬Ìصͼ¶µÄ´íÎó¾ÍÊÇ£¬ÔÀ´Host copyÓï¾äÒªÔÚÔËÐÐÃüÁî´°¿ÚÏÂÔËÐвŻáÉúЧ£¬Ç°ÃæÒ»Ö±¶¼Ì«Ï°¹ßÔÚpl/sqlÖнøÐвÙ×÷ÁË¡£
oracle9iÁª»ú±¸·ÝµÄ¹ý³Ì
sql>alter tablespce mytp begin backup;
sql>host copy f:\oracle\oradata\myt ......
¡¡C:\>sqlplus /nolog
¡¡¡¡SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 1ÔÂ 19 14:46:21 2005
¡¡¡¡Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
¡¡¡¡SQL> connect chanet/chanet@oradb;
¡¡¡¡ÒÑÁ¬½Ó¡£
¡¡¡¡SQL> CREATE TABLE IMAGE_LOB (T_ID VARCHAR2 (5) NOT NULL,T_IMAGE ......
ÔÚ/etc/rc.d/init.d/ ´´½¨oracle10gÎļþ
touch oracle10g
chmod a+x oracle10g
[root@test~]# vi /etc/rc.d/init.d/oracle10g
#!/bin/bash
#chkconfig:345 51 49
#description:starts the oracle database deamons
#
ORACLE_HOME=/oracle/product/10.2.0/db_1
ORACLE_OWNER=oracle
case "$1" in
start)
echo ......