記一次導庫歸檔撐爆不負責任的做法

測試導數據驗證一個其它問題，但是突然導入的時候一直卡主了。然后一看日志發現原來impdp導入過程中產生大量歸檔日志，存儲歸檔的空間滿了所以才卡住了

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.
************************************************************************
...

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

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

先新開一個終端，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

后面在開就恢復正常了

[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: