Error RMAN-08137, when delete archivelog in oracle
When I delete some archivelogs in order to release some diskspace, I encountered error,
like this: RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream
capture process archived log file name=+ASMARCH01/tacs/archivelog/2019_01_29/thread_
1_seq_39651.20643.998844943 thread=1 sequence=39651 , As shown in the following figure.
Reason :
There exist dataguard configuration between this oracle database and other database,
and this oracle database is primiary. the remote standby database hasn’t applied some local
archivelog, and local primary database disallow to delete the archivelog. Therefor RMAN-08137
appeared.
Solution:
delete noprompt force archivelog all completed before ‘sysdate-time’;