OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
ĿǰÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ±(DBA)µÄ³õ¼¶Ö¤Êé¡£
ORACLEÅàѵ(OCA)ÈëѧÌõ¼þ
ÊìϤWindows»òLinux²Ù×÷ϵͳ¡£
ÓÐACCESS»òÆäËûÊý¾Ý¿â»ù´¡£¬ÓÐÒ»¶¨ÍøÂç²Ù×÷µÄ»ù±¾ÖªÊ¶£¬¾ßÓиßÖлòÒÔÉÏÓ¢Óïˮƽ¡£
ORACLEÅàѵ(OCA)¿¼ÊÔ¿ÆÄ¿
1Z0-007: Oracle Database 10g:SQL Fundamentals
1Z0-042: Oracle Database 10g Administration I
ORACLEÅàѵ(OCA)¿Î³ÌÄÚÈÝ
01) Oracle10g²úÆ·¼°ÐòÁнéÉÜ
02) ¹ØÏµÊý¾Ý¿â»ù´¡¼°OracleÌåϵ½á¹¹
03) ½ø³Ì¡¢ÊµÀý¼°Êý¾Ý¿âµÈ»ù´¡ÖªÊ¶
04) Oracle10gµÄ×Ô¶¯SGA¹ÜÀí
05) °²×°ºÍ´´½¨OracleÊý¾Ý¿âDBCA
06) Éý¼¶µ½Oracle10gÊý¾Ý¿âDBUA¡¢Æô¶¯¡¢¹Ø±ÕÊý¾Ý¿â
07) ÉîÈëÁ˽âOracleÊý¾Ý¿âµÄ³õʼ»¯¹ý³Ì¡¢OracleµÄ²ÎÊýÎļþ¹ÜÀí
08) ÎïÀí¼°Âß¼´æ´¢½á¹¹
09) ASM-Oracle10gµÄ×Ô¶¯´æ´¢¹ÜÀí
10) ±í¿Õ¼ä¼°Êý¾ÝÎļþµÄ¹ÜÀí
11) Oracle10g SYSAUX±í¿Õ¼ä
12) Oracle10g´æ´¢½á¹¹ÐÂÌØÐÔ
13) OracleµÄSchema¶ÔÏó¼°¹ÜÀí£¨table,index,constraintµÈ£©
14) LMT¡¢DMT¼°Oracle´æ´¢½á¹¹µÄ±äǨ
15) FLM¡¢ASSM¼°Oracle¿Õ¼ä¹ÜÀíµÄ±äǨ
16) ÍøÂç·þÎñ¼°¹ÜÀí
17) ¼àÌýÆ÷¼°·þÎñÅäÖÃ
18) ÈçºÎ½øÐÐÍøÂçÁ¬½Ó
19) Á¬½Óµ½Oracle·þÎñÆ÷
20) Oracle¹²Ïí·þÎñÆ÷ÔÀí¼°ÅäÖÃ
21) Oracle¹²Ïí
Ïà¹ØÎÊ´ð£º
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB
Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí
ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......