ÆôÓÃoracleµÄarchiveģʽ
¾Ñ飺
alter system set log_archive_dest=’D:\oracle\archivelog’ scope=spfile;
alter system set log_archive_start=true scope=spfile;
Ö®ºó£¬
create pfile from spfile
¿ÉÑéÖ¤¼ÓÉÏû
Ò»¡¢²é¿´Êý¾Ý¿âÔËÐÐģʽ
¿ÉÒÔÓ󬼶Óû§£¨INTERNAL£©ÔÚSQLPLUSÖÐʹÓÃÃüÁîARCHIVE LOG LIST²é¿´
SQL> archive log list
Database log mode ¡¡¡¡¡¡¡¡¡¡¡¡No Archive Mode
Automatic archival¡¡¡¡¡¡¡¡¡¡¡¡Disabled
Archive destination¡¡¡¡¡¡¡¡¡¡ /export/home/oracle/product/8.1.7/dbs/arch
Oldest online log sequence ¡¡ 28613
Current log sequence¡¡¡¡¡¡¡¡¡¡28615
Șͧ
SQL> SELECT NAME,LOG_MODE from V$DATABASE;
NAME¡¡¡¡¡¡¡¡LOG_MODE
——–¡¡¡¡————
BIGSUN¡¡¡¡¡¡NOARCHIVELOG
Èç¿´µ½ÈçÉÏÇé¿ö£¬ÔòÖ¤Ã÷ÊǷǹ鵵£¨NOARCHIVELOG£©Ä£Ê½¡£
¶þ¡¢¹Ø±ÕÊý¾Ý¿â
֪ͨÏà¹ØÈËÔ±ºó£¬·¢²¼ÈçÏÂÃüÁî¹Ø±ÕÊý¾Ý¿â£º
SQL> shutdown immediate
Èý¡¢ÉèÖÃÏàÓ¦µÄ³õʼ»¯²ÎÊý
²ÎÊýÎļþÒ»°ã´æ·ÅÔÚ$ORACLE_HOME/dbsĿ¼Ï£¬¸ñʽΪ£ºinitSID.ora£¬ÆäÖÐSIDΪÊý¾Ý¿âÃû¡£¿ÉÒÔʹÓÃVIÃüÁî½øÐб༡£
1¡¢ÉèÖù鵵·¾¶
a)LOG_ARCHIVE_DESTºÍLOG_ARCHIVE_DUPLEX_DEST²ÎÊý
ÕâÁ½¸ö²ÎÊýÖ¸Ã÷Á˹鵵ÈÕÖ¾´æ·ÅµÄÁ½¸ö·¾¶£¬Èç¹ûÖ»ÉèÖõÚÒ»¸ö£¬Ôò¹éµµÈÕÖ¾Ö»´æ·Åµ½Ò»¸ö·¾¶¡£
Àý£º
log_archive_dest=/disk1/archive
log_archive_duplex_dest=/disk2/archive
b)LOG_ARCHIVE_DEST_n²ÎÊý
ÆäÖÐnΪ1-5µÄÕûÊý£¬±ØÐè´ÓµÍµ½¸ßÉèÖã¬ÏÂÃæ¾ÙÀý˵Ã÷£º
log_archive_dest_1=”LOCATION=/archive MANDATORY REOPEN”
log_archive_dest_2=”SERVICE=standby_db1 MANDATORY REOPEN=600″
log_archive_dest_3=”LOCATION=/archive2 OPTIONAL”
LOCATION¹Ø¼ü×Ö˵Ã÷ÊDZ¾»úµÄÒ»¸öĿ¼£¬¶øSERVICE¹Ø¼ü×Ö˵Ã÷ÊÇÒѾÔÚNet8ÖнøÐÐÁËÅäÖõÄÆäËûÊý¾Ý¿âÖ÷»úµÄ±ðÃû¡£
MANDATORY¹Ø¼ü×Ö˵Ã÷Áª»úÈÕÖ¾Îļþ±ØÐëÒª³É¹¦¹éµµµ½Õâ¸öĿ¼ºó²ÅÄܱ»¸²Ð´£¨Áª»úÈÕÖ¾ÎļþÊÇÖظ´Ê¹ÓõÄÎļþ£©¡£È±Ê¡Îª¿ÉÑ¡£¨OPTIONAL£©£¬¼
Ïà¹ØÎĵµ£º
ÒòΪ¹«Ë¾µÄÕÆÉϳÇÊÐϵͳÔÚ¶à¸öµØÊÆͬʱÉÏÏߣ¬¶øΪÁËÈÃÿ¸ö³ÇÊеÄ3G¿ìѶ¾ßÓеØÊÆÌØÉ«ÐÔ£¬Ã¿¸öµØÊÆÓÐ×Ô¼ºµ¥¶ÀµÄÊý¾Ý¿âϵͳ£¬¶øÿ¸öµØÊƵĿìѶÓÖһЩ¹²Í¬µÄ£¬Æ©ÈçͻȻ³öÁËÒ»Ìõ¹ú¼ÊÐÂÎÅ£¬ÄÇôÊDz»ÊÇÿ¸öµØÊƵĺǫ́±à¼¶¼ÒªÂ¼ÈëÒ»±é£¬ÕâÑùÎÞÒÉÊÇ×öÁËÐí¶àÎÞÓù¦£¬ËùÒÔ¹«Ë¾¿¼ÂǼÜÉèÒ»¸ö×ÜÕ¾£¬×ÜÕ¾ÉÏÓÐרÃŵÄÈ˸ºÔð£¬Ã¿Ì츺Ôð¼ÈëÒ» ......
»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½
µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉ ......
Ò»£¬Ó²¼þÅäÖÃ×îµÍÒªÇó£º
32루X86£©£º
¸öÈËÈÏΪÖÁÉÙ1GÄڴ棨linux ÉÏ512M ¿ÉÒÔ£¬µ«Ì«¹ýÓÚÃãÇ¿ÁË£¬ÄÇÑùÈÝÒ×ËÀ»ú»ò¿¨×¡²»¶¯£¬»áÈÃÈË×¥¿ñµÄ;
windows 512M µÄ¿Ï¶¨²»ÐУ©
10GµÄ¿ÉÓô ......