測試導(dǎo)數(shù)據(jù)驗證一個其它問題，但是突然導(dǎo)入的時候一直卡主了。然后一看日志發(fā)現(xiàn)原來impdp導(dǎo)入過程中產(chǎn)生大量歸檔日志，存儲歸檔的空間滿了所以才卡住了

10年的肇東網(wǎng)站建設(shè)經(jīng)驗，針對設(shè)計、前端、開發(fā)、售后、文案、推廣等六對一服務(wù)，響應(yīng)快，48小時及時工作處理。營銷型網(wǎng)站建設(shè)的優(yōu)勢是能夠根據(jù)用戶設(shè)備顯示端的尺寸不同，自動調(diào)整肇東建站的顯示方式，使網(wǎng)站能夠適用不同顯示終端，在瀏覽器中調(diào)整網(wǎng)站的寬度，無論在任何一種瀏覽器上瀏覽網(wǎng)站，都能展現(xiàn)優(yōu)雅布局與設(shè)計，從而大程度地提升瀏覽體驗。創(chuàng)新互聯(lián)公司從事“肇東網(wǎng)站設(shè)計”,“肇東網(wǎng)站推廣”以來，每個客戶項目都認真落實執(zhí)行。

tail /u01/app/oracle/diag/rdbms/zhanky/zhanky/trace/alert_zhanky.log（主要報錯如下）

[root@source?~]#?tail?/u01/app/oracle/diag/rdbms/zhanky/zhanky/trace/alert_zhanky.log?
....
************************************************************************
ARC3:?Error?19809?Creating?archive?log?file?to?'/u01/app/oracle/fast_recovery_area/ZHANKY/archivelog/2019_05_07/o1_mf_1_100_%u_.arc'
Errors?in?file?/u01/app/oracle/diag/rdbms/zhanky/zhanky/trace/zhanky_arc0_2423.trc:
ORA-19815:?WARNING:?db_recovery_file_dest_size?of?4385144832?bytes?is?100.00%?used,?and?has?0?remaining?bytes?available.
************************************************************************
You?have?following?choices?to?free?up?space?from?recovery?area:
1.?Consider?changing?RMAN?RETENTION?POLICY.?If?you?are?using?Data?Guard,
???then?consider?changing?RMAN?ARCHIVELOG?DELETION?POLICY.
2.?Back?up?files?to?tertiary?device?such?as?tape?using?RMAN
???BACKUP?RECOVERY?AREA?command.
3.?Add?disk?space?and?increase?db_recovery_file_dest_size?parameter?to
???reflect?the?new?space.
4.?Delete?unnecessary?files?using?RMAN?DELETE?command.?If?an?operating
???system?command?was?used?to?delete?files,?then?use?RMAN?CROSSCHECK?and
???DELETE?EXPIRED?commands.
************************************************************************
...

因為是測試環(huán)境所以只是開啟了歸檔其它啥都沒設(shè)置，于是就默認存放位置載db_recovery_file_dest_size 下，默認也是4G大小。

其實解決方法也簡單，只不過想起來好久沒寫博客所以記錄一下。主要歸檔滿了，我們可以通過設(shè)置限制的大小或者刪除歸檔日志來解決。但是因為我這邊測試空間不多所以采用第二種方法刪除歸檔日志。

先新開一個終端，rman target /? 運行以下命令。

[oracle@source?~]$?rman?target?/

Recovery?Manager:?Release?11.2.0.4.0?-?Production?on?Tue?May?7?20:48:26?2019

Copyright?(c)?1982,?2011,?Oracle?and/or?its?affiliates.??All?rights?reserved.

connected?to?target?database:?ZHANKY?(DBID=2622149390)

RMAN>?
RMAN>?delete?archivelog?all;?

released?channel:?ORA_DISK_1
allocated?channel:?ORA_DISK_1
channel?ORA_DISK_1:?SID=1163?device?type=DISK
List?of?Archived?Log?Copies?for?database?with?db_unique_name?ZHANKY
=====================================================================

Key?????Thrd?Seq?????S?Low?Time?
-------?----?-------?-?---------
97??????1????100?????A?07-MAY-19
.
.
.
.
????????Name:?/u01/app/oracle/fast_recovery_area/ZHANKY/archivelog/2019_05_07/o1_mf_1_100_gf3079ns_.arc
140?????1????144?????A?07-MAY-19
????????Name:?/u01/app/oracle/fast_recovery_area/ZHANKY/archivelog/2019_05_07/o1_mf_1_144_gf30osyo_.arc
Do?you?really?want?to?delete?the?above?objects?(enter?YES?or?NO)??yes
deleted?archived?log
archived?log?file?name=/u01/app/oracle/fast_recovery_area/ZHANKY/archivelog/2019_05_07/o1_mf_1_100_gf3079ns_.arc?RECID=97?STAMP=1007672299
deleted?archived?log
.
.
.
.
archived?log?file?name=/u01/app/oracle/fast_recovery_area/ZHANKY/archivelog/2019_05_07/o1_mf_1_144_gf30osyo_.arc?RECID=140?STAMP=1007672763
Deleted?45?objects


RMAN>?exit

后面在開就恢復(fù)正常了

[root@source?~]#?tail?/u01/app/oracle/diag/rdbms/zhanky/zhanky/trace/alert_zhanky.log?
Archived?Log?entry?139?added?for?thread?1?sequence?143?ID?0x9c4b270e?dest?1:
Thread?1?advanced?to?log?sequence?145?(LGWR?switch)
??Current?log#?1?seq#?145?mem#?0:?/u01/app/oracle/oradata/zhanky/redo01.log
Tue?May?07?21:06:03?2019
Archived?Log?entry?140?added?for?thread?1?sequence?144?ID?0x9c4b270e?dest?1:
Tue?May?07?21:06:12?2019
Thread?1?advanced?to?log?sequence?146?(LGWR?switch)
??Current?log#?2?seq#?146?mem#?0:?/u01/app/oracle/oradata/zhanky/redo02.log
Tue?May?07?21:06:13?2019
Archived?Log?entry?141?added?for?thread?1?sequence?145?ID?0x9c4b270e?dest?1:

本文題目：記一次導(dǎo)庫歸檔撐爆不負責任的做法
標題路徑：http://www.chinadenli.net/article22/gooejc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、標簽優(yōu)化、企業(yè)網(wǎng)站制作、網(wǎng)站制作、關(guān)鍵詞優(yōu)化、網(wǎng)站收錄

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)