ÈçºÎÕýȷɾ³ýORACLE¹éµµÈÕÖ¾Îļþ
ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSÏ°ÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²»ÖªµÀÕâЩÎļþÒѾ²»´æÔÚÁË!ÕâʱºòÎÒÃÇÒª×öÊÖ¹¤µÄÇå³ýµÄ»°£¬ÏÂÃæÎÒ¾¹ýʵÑ飬¿ÉÒÔ³¢ÊÔÕâÖÖ·½·¨£º
1. ½øÈërman
2. connect target /
3. crosscheck archivelog all;
4. delete expired archivelog all;
ÕâʱºòÎÒÃÇÔÙÈ¥OEMÖп´¾ÍÒ»¶¨¿´²»µ½£¬Èç¹ûÄãµÄ´ÓÀ´Ã»ÓÐ×ö¹ýÕâ¸ö¶¯×÷µÄ»°£¬ÎÒÃÇ¿ÉÒԱȽϴÓÕâ¸ö¶¯×÷Ç°µÄcontrolfileºó¶¯×÷ºóµÄcontrolfileµÄ´óС!
ORACLEÕýȷɾ³ý¹éµµ²¢»ØÊÕ¿Õ¼äµÄ·½·¨
ORACLEÕýȷɾ³ý¹éµµ²¢»ØÊÕ¿Õ¼äµÄ·½·¨
Ò»¸öORACLE¹éµµÈÕÖ¾¾³£Âú£¬±íÏÖΪ/oraarchive Õâ¸öÎļþ¿Õ¼äÕ¼ÓÃ100£¥´ó¼ÒÒ»¶¨±§Ô¹ORACLEΪºÎûÓй鵵ά»¤¹¤¾ß£¬ºÜ¶àÈËÖ±½Óɾ³ýÁËÊ£¬´íÁË£¬ORACLEÓУ¬¶øÇÒºÜÖÇÄÜ£¬¿ÉÒÔÕýÈ·µÄɾ³ý¹éµµºÍFLASHBACK£¬²»¹ýÇмÇ,ORACLE¹éµµÈÕÖ¾¶ÔÓÚORACLEµÄÊý¾Ý»Ö¸´ºÍ±¸·Ý·Ç³£ÖØÒª£¬²»µ½Íò²»µÃÒѲ»ÒªÉ¾³ý¹éµµÈÕÖ¾¡£
ɾ³ý¹éµµÈÕÖ¾µÄ¹ý³Ì
ÒÔORACLEÓû§Éí·ÝµÇ¼µ½Êý¾Ý¿â·þÎñÆ÷Ö÷»ú»òͨ¹ýÍøÂçÁ¬½Ó
½øÈëORACLEÊý¾Ý±¸·Ý¹¤¾ß
rman target/
»òrman target/@orcl
ÔÚÃüÁî´°¿ÚÀïÃæÖ´ÐÐ
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
˵Ã÷
SYSDATA-7£¬±íÃ÷µ±Ç°µÄϵͳʱ¼ä7ÌìÇ°£¬before¹Ø¼ü×Ö±íʾÔÚ7ÌìÇ°µÄ¹éµµÈÕÖ¾£¬Èç¹ûʹÓÃÁËÉÁ»Ø¹¦ÄÜ£¬Ò²»áɾ³ýÉÁ»ØµÄÊý¾Ý¡£
ͬÑùµÀÀí£¬Ò²¿ÉÒÔɾ³ý´Ó7ÌìÇ°µ½ÏÖÔÚµÄÈ«²¿ÈÕÖ¾£¬²»¹ýÕâ¸öÃüÁîÒª¿¼ÂÇÇå³þ£¬×öÍêÕâ¸öɾ³ý£¬×îºÃÂíÉϽøÐÐÈ«±¸·ÝÊý¾Ý¿â
DELETE ARCHIVELOG from TIME 'SYSDATE-7'; ɾ³ý´Ó7ÌìÇ°µ½ÏÖÔÚµÄÈ«²¿ÈÕÖ¾,É÷ÓÃ
UNIX/LINUXÏÂÒ²¿ÉÒÔͨ¹ýFINDÕÒµ½7ÌìÇ°µÄ¹éµµÊý¾Ý£¬Ê¹ÓÃEXEC×Ó²Ù×÷ɾ³ý
find /oraarchive -xdev -mtime +7 -name "*.dbf" -exec rm -f {} ;
ÕâÑù×öÈÔÈ»»áÔÚRMANÀïÁôÏÂδ¹ÜÀíµÄ¹éµµÎļþ
ÈÔÐèÒªÔÚRMANÀïÖ´ÐÐÏÂÃæ2ÌõÃüÁî
crosscheck archivelog all;
delete expired archivelog all;
ËùÒÔ»¹²»ÈçÉÏÃæµÄ·½·¨ºÃÓ㬲»¹ýÓÃFINDµÄºÃ´¦¾ÍÊÇ£¬¿ÉÒÔÔÚÌõ¼þÉÏ£¬ºÍEXEC×ÓÏîÉÏ×öºÜ¶à²Ù×÷£¬ÊµÏÖ¸ü¸´ÔӵŦÄÜ
3.¼òÒª½éÉÜÒ»ÏÂreport obsoleteÃüÁî
ʹÓÃreport obsoleteÃüÁ¸æ¹ýÆÚ±¸·Ý
RMAN> report obsolete;
RMAN retention
Ïà¹ØÎĵµ£º
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......
Oracle ÈýÖÖ¼¯ºÏÊý¾ÝÀàÐ͵ıȽÏ:
PL/SQLÖÐûÓÐÊý×éµÄ¸ÅÄËûµÄ¼¯ºÏÊý¾ÝÀàÐͺÍÊý×éÊÇÏàËƵġ£ÔÚ7.3ÒÔÇ°µÄ°æ±¾ÖÐÖ»ÓÐÒ»ÖÖ¼¯ºÏ£¬³ÆΪPL/SQL±í£¬ÔÚÕâÖ®ºóÓÖÓÐÁ½ÖÖ¼¯ºÏÊý¾ÝÀàÐÍ:ǶÌ×±íºÍvarray¡£ÆäÖÐvarray¼¯ºÏÖеÄÔªËØÊÇÓÐÊýÁ¿ÏÞÖƵģ¬index_by±íºÍǶÌ×±íÊÇûÓÐÕâ¸öÏÞÖƵġ£index-by±íÊÇÏ¡ÊèµÄ£¬Ò²¾ÍÊÇ˵ϱê¿ÉÒÔ²»Á¬Ðø ......
RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤Æڼƻ®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......
1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......