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.

delete_log

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’;

Leave a Reply