ÈçºÎÕýȷɾ³ý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
Ïà¹ØÎĵµ£º
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§ http://ip:5560/isqlplus
DBAÓû§ &nb ......
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......
OracleϵÁУºLOB´ó¶ÔÏó´¦Àí
Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
&nbs ......
Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......
1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/ ......