CentOS 5ϰ²×°Oracle 11g
Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»»¿Õ¼äµÄÇé¿öÏ£¬Ò²¿ÉÒÔÕý³£ÔËÐÐOracleÊý
¾Ý¿â¡£
Òª¼ì²éÄÚ´æ¿Õ¼ä£¬µÇ¼½øÈëLinux£¬ÔÚÃüÁîÐз½Ê½£¨bash»·¾³£©ÏÂÖ´ÐÐÈçÏÂÃüÁ
grep MemTotal /proc/meminfo
Òª¼ì²é½»»»¿Õ¼ä£¬ÔÚÃüÁîÐÐÏÂÖ´ÐÐÈçÏÂÃüÁ
grep SwapTotal /proc/meminfo
CentOS 5ϰ²×°Oracle 11g
Ê×ÏÈÐèÒªµÄÈí¼þÓУº
1¡¢ linux_11gR1_database.zip //¿ÉÔÚOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµÃµ½£¬ÓÐ1.71GB¹»
´ó°É¡£
2¡¢ ±ðÍüÁË×¼±¸Ò»·ÝOracleµÄ¹Ù·½°ïÖúÎĵµ£¬ÊÇ×îȨÍþµÄ¡£
3¡¢ CentOS-5.2-i386-bin-DVD.iso //¿ÉÔÚCentOS¹Ù·½ÍøÕ¾ÏÂÔØµÃµ½£¬ÓÐ3.74GB³¬¼¶´ó¡£
ºÇºÇ£¡£¡£¡
ÕâЩ׼±¸¹¤×÷×öºÃÁËÖ®ºó£¬ÎÒÃǾͿªÊ¼°²×°Linux²Ù×÷ϵͳ£¬ÔÚÐéÄâ»úÖа²×°£¬Ïê
ϸ°²×°¹ý³ÌÕâÀï¾Í²»ÃèÊö£¬²»¹ý£¬ÖµµÃÌáÐѵÄÊÇÐéÄâ»úÔÚÅäÖÃÐéÄâÓ²¼þ»·¾³Ê±£¬ÄÚ´æ±ØÐë
´óÓÚ»òµÈÓÚ1G£¬Ó²Å̿ռäÖÁÉÙ15G¡£
ÔÚ°²×°ºÃÐéÄâL inux ϵͳ֮ºó£¬ÒòΪÊDzËÄñ¼¶µÄÂËùÒÔÖ»ÓÐÔÚͼÐνçÃæÏÂÀ´²Ù
×÷ÁË¡£½«ÊÂÏÈÏÂÔØºÃµÄ linux_11gR1_database.zip ¿½±´ÖÁLinuxÐéÄâ»úÀï±ß£¬½¨Á¢Ò»¸ö´æ
·ÅĿ¼È磺
/u01/linux_11gR1_database.zip
½«Æä½âѹ£¬ÔÚÖÕ¶ËÊäÈëЩÃüÁîÖ´ÐУº
[root@oracle u01]# unzip linux_11gR1_database.zip
½âѹºóµÄ´æ·ÅÎļþ¼ÐÃûΪ database
Ê×ÏȲ鿴ÄãLinuxÄں˰汾ÊÇ·ñ·ûºÏoracle°²×°Ìõ¼þ£º
[root@oracle u01]# cat /proc/version
È·¶¨Äں˰汾ºó£¬¼ì²é´Ë°æ±¾Linux»·¾³Ï°²×°OracleËùÐèÒªÓõ½µÄ°ü£º
[root@oracle u01]# rpm -qa | grep <package_name>
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libel
Ïà¹ØÎĵµ£º
server A: 10.85.10.44 SID=orcl
target server B: 10.85.10.43
oracle version:10.2.0.1
OS platform : windows XP
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AV ......
1. use database as archive log mode and set archive dest location
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/u04/arch/orcl' scope=spfile;
2. configuration retention days/size/distination
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=43200; --30 days
ALTER SYSTEM SET db_recovery_file_dest_ ......
1¡¢´¥·¢Æ÷µÄ¸ÅÄî
´¥·¢Æ÷Ò²ÊÇÒ»ÖÖ´øÃûµÄPL/SQL¿é¡£´¥·¢Æ÷ÀàËÆÓÚ¹ý³ÌºÍº¯Êý£¬ÒòΪËüÃǶ¼ÊÇÓµÓÐÉùÃ÷¡¢Ö´ÐкÍÒì³£´¦Àí¹ý³ÌµÄ´øÃûPL/SQL¿é¡£Óë°üÀàËÆ£¬´¥·¢Æ÷±ØÐë´æ´¢ÔÚÊý¾Ý¿âÖв¢ÇÒ²»Äܱ»¿é½øÐб¾µØ»¯ÉùÃ÷¡£
¶ÔÓÚ´¥·¢Æ÷¶øÑÔ£¬µ±´¥·¢Ê¼þ·¢ÉúµÄʱºò¾Í»áÏÔʽµØÖ´Ðиô¥·¢Æ÷£¬²¢ÇÒ´¥·¢Æ÷²»½ÓÊܲÎÊý¡£
´´½¨´¥·¢Æ÷µÄÓï·¨È ......
1 . set database to archivelog mode
Sql´úÂë
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE&n ......
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐзҳµÄÔʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN ......