VVR¶ÔOracleÊý¾Ý¿â½øÐÐÈÝÔÖ
Ëæ×ÅÈ«ÇòÐÅÏ¢»¯Ê±´úµÄµ½À´£¬ÐÅÏ¢Êý¾ÝÔ½À´Ô½³ÉΪÆóÒµ¹Ø×¢µÄ½¹µã£¬¼´ÔÚ¸÷ÖÖ×ÔÈ»ÔÖº¦»òÕßÈËΪÆÆ»µµÄÇé¿öÏ£¬ÈçºÎ±£Ö¤Éú²úÊý¾ÝµÄ°²È«ºÍ¹Ø¼üÒµÎñµÄ²»ÖжÏÔËÐС£
´«Í³µÄ±£»¤·½·¨ÀëÏß±¸·Ý¡¢±¸·Ý½éÖÊÒìµØ±£´æÔÚÒ»¶¨³Ì¶ÈÉÏ¿ÉÒÔ½â¾öÉÏÊöÎÊÌ⣬µ«ÎªÁËÄܹ»¶ÔÒµÎñϵͳÌṩ¸ü¸ßµÄʵʱÐԺͿɿ¿ÐÔ£¬±£Ö¤¹Ø¼üÒµÎñ7x24²»Öжϣ¬
Ó¦¶Ô¼¤ÁÒµÄÊг¡¾ºÕùºÍÌá¸ß¿Í»§ÂúÒâ¶È£¬ÆóÒµ±ØÐëÔÚITϵͳΧÈÆ“Á¬Ðø”£¨BC£©Ö÷Ìâ½øÐй¹½¨£¬ÊµÊ©ÒµÎñÁ¬Ðø/ÈÝÔÖ±¸·Ý¼Æ»®£¬°üÀ¨ÒµÎñÁ¬ÐøÐÔ¡¢¸ß¿ÉÓÃÐÔ¹Ü
Àí¡¢ÈÝÔÖ¡¢Êý¾Ý¸´Öƺͻָ´·½°¸¡¢°²È«µÈ£¬ÏÂÃæ¾Í¶ÔÊý¾Ý¸´ÖƼ¼Êõ×öÒ»¸ö¼òµ¥µÄ½éÉÜ¡£
¸ù¾ÝÊý¾Ý¸´ÖÆÔËÐеÄλÖ㬿ÉÒÔ½«Êý¾Ý¸´ÖÆ·½Ê½·ÖΪÒÔÏÂËÄÖÖ£º
»ù
ÓÚ´æ´¢(Storage-Based)£º´ú±í³§ÉÌÓÐEMC SRDF¡¢IBM PPRC/GDPS ¡¢HP BusinessCopy¡¢HDS
TrueCopyµÈ£¬Ìصã¶ÔÖ÷»ú͸Ã÷£¬¶ÔÓ¦ÓÃϵͳµÄÓ°Ïì½ÏС£¬¼¼Êõ³ÉÊ죬Óн϶àµÄ³É¹¦°¸Àý£¬µ«ÊÇͶ×ʽϴ󣬶ÔÍøÂçÁ¬½ÓµÄÒªÇóÒ²½Ï¸ß¡£
»ùÓÚ·þÎñÆ÷£¨Host-based£©£º´ú±í³§ÉÌÖ÷ÒªÊÇSymantec¹«Ë¾µÄVeritas Volume Replicator (VVR)£¬ÊÇ´æ´¢¾íµÄ¸´ÖƼ¼Êõ¡£ÐèÒªÕ¼ÓÃÖ÷»úÒ»¶¨µÄϵͳ×ÊÔ´¡£
»ù
ÓÚ´æ´¢½»»»»ú(SAN-Based)£ºÔËÐÐÓÚ¹Ò½ÓÔÚ´æ´¢ÍøÂçÉϵÄרÓÃÉ豸ÖУ¬´ú±í³§ÉÌÓÐCISCOµÄSANTap£¬FalconStor
IPStor£¬Topio SANsafe£¬DataCore SANsymphony, Asynchronous Internet
Mirroring (AIM)µÈ¡£
»ùÓÚÊý¾Ý¿â/Èí¼þÓ¦Óà :´ú±í³§ÉÌÓÐOracle DataGuard£¬Quest
SharePlex£¬IBM-DB2µÄÔ¶³ÌQ¸´ÖÆ£¬SYBASEµÄ¸´ÖÆ·þÎñÆ÷(Replication Server)
µÈ£¬ÕâЩ¼¼Êõ¶¼ÊǶÔÊý¾ÝÂß¼²Ù×÷µÄ¸´ÖÆ£¬ÊôÓÚÂß¼Êý¾Ý¸´ÖÆ£¬¶øÆäËü3ÖÖ¸´ÖƵÄÊÇÊý¾Ý¾íÖеÄÊý¾Ý±ä»¯£¬ÊôÓÚÎïÀíÊý¾Ý¸´ÖÆ¡£µäÐ͵ÄÂß¼Êý¾Ý¸´ÖÆÊÇͨ¹ýÊý¾Ý¿âÈÕ
־ʵÏֵģ¬ÓŵãÊÇÓ²¼þͶ×ÊС£¬¶ÔÉú²úϵͳµÄÓ°Ïì±È½ÏС£¬¶ÔÖ÷¡¢±¸ÓÃϵͳµÄÓ²¼þƽ̨ûÓÐÑ¡ÔñÐÔ£»¿ÉÒÔÔÚ¹ãÓòÍø·¶Î§ÄÚʹÓᣵ«Ëü¶ÔÊý¾Ý¿âϵͳÓÐÑϸñµÄÒªÇ󣬲¢
ÇÒÖ÷¡¢±¸ÓÃϵͳ±ØÐëʹÓÃÏàͬµÄÊý¾Ý¿â°æ±¾¡£
ÉÏÃæ½éÉܵÄÖ÷ÒªµÄ¸÷³§ÉÌ·½°¸ºÍ²úÆ·¿ÉÒԲμûÏÂͼ£º
±¾ÎÄÖ÷Òª½éÉÜ»ùÓÚÖ÷»úºÍÂß¼¾íµÄÊý¾Ý¸´ÖÆVVR¡£
VERITASµÄVVR£¨Veritas Volume
Replicator£©ÊÇÓÃÓÚÓÐЧµÄÔÖÄѻָ´µÄÊý¾Ý¸´ÖÆÈí¼þ£¬¿ÉÒÔÁ¬Ðø¶ÔÓ¦ÓÃÊý¾Ý½øÐÐÒ»¸ö»òÕ߶à¸öµÄ¿½±´±£»¤¡£¾ßÓеÄÓŵãÖ÷ÒªÓУº¸ßÐÔÄÜ£¬¾àÀë²»ÏÞ£¬Ö§³Ö
Òì¹¹µÄ´æ´¢ºÍ²Ù×÷ϵͳ£¬¶ÔÊý¾ÝµÄÁ¬Ðø±£
Ïà¹ØÎĵµ£º
³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it ......
ÔÚwindowsÏÂsqlplusÍêÈ«Õý³££¬¿ÉÊǵ½linuxÏ£¬sqlplusÖÐÎÄÏÔʾ¾Í³öÎÊÌâÁË£¬×ÜÊÇÏÔʾ“??”£¬Õâ¸öÎÊÌâÓÖÔõô½â¾öÄØ£¿
¾¹ýÔÚÍøÂçÉϲé×ÊÁÏ£¬ÒÔ¼°³¢ÊÔ£¬µÃµ½µÄ½â·¨ÈçÏ£º
ÆäʵºÜ¼òµ¥ÎÒÃÇÖ»ÒªÉèÖÃÍ˳ösqlplus,ÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿NLS_LANG
export NLS_LANG="SIMPLI ......
OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе ......
¡¡¡¡1´´½¨Ð±í
¡¡¡¡1.1´Ó²éѯµ½µÄ±í´´½¨±í
¡¡¡¡create table temp as select stuName,stuNo,stuSex from stuInfo where stuAge>25;
¡¡¡¡1.2´´½¨Ð±í
¡¡¡¡/*ѧÉúÐÅÏ¢±í*/
¡¡¡¡create table stuInfo(
¡¡¡¡stuName varchar2(10) ,
¡¡¡¡stuNo varchar2(10),
¡¡¡¡stuSex varchar2(4),
¡¡¡¡stuAge number(2),
¡¡¡¡st ......