As seen below obsolete EXTRACT1_NAME is showing REQ_SCN = 0.
SQL>SELECT CAPTURE_NAME, CAPTURE_TYPE, STATUS, to_char(REQUIRED_CHECKPOINT_SCN,'999999999999999')as REQ_SCN ,to_char(OLDEST_SCN,'999999999999999')as OLDEST_SCN FROM DBA_CAPTURE;
CAPTURE_NAME CAPTURE_TYPE STATUS REQ_SCN OLDEST_SCN
-------------- ------------ ------- -------- ----------
OGG$CAP_EXTRACT-NAME LOCAL ENABLED 64983227 64983227
OGG$CAP_EXTRACT1-NAME LOCAL ENABLED 0 0
After unregistering as follows RMAN was able to delete the old archive logs:
UNREGISTER EXTRACT EXTRACT-NAME DATABASE
No comments:
Post a Comment