路過MIS的睏貓

將模式改成Archive log mode後，多了一個flash_recovery_area的資料夾，聽說會把每日有異動的部分存在這底下。
圖一

圖二

而這邊應該是..應該是DB存放的地方吧..
也弄不清楚...


一開始是說
Archive process error: ORA-16038: log 2 sequence# 1245 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'.

Archive process error: ORA-16014: log 2 sequence# 1245 not archived, no available destinations
ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'

http://tw.knowledge.yahoo.com/question/question?qid=1607052104241

依建議後移動如圖二的所有資料夾至別處，然後把變成2G，卻還是出現如下訊息：
ORA-16038: log 3 sequence# 1150 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'

有什麼好做法嗎?