SAP Note 18281 - CCMS log display after recovery with "Reset logs"

Symptom:

Oracle redo logs are displayed as saved (already archived), although they have not been (in CCMS, DB12, status of most recent logs).

Cause and prerequisites

A recovery was run with "Reset logs"; in Oracle version 7 and later, the log sequence number is reset to 1 (that is, the same numbers are used again). In CCMS, however, the information that a given log file has been archived was not reset.

Solution
This short ABAP report will delete the CCMS (brarchive) history.
report fixsdbah.
SDBAH is the header table, SDBAD the detail table:
exec sql.
delete from sdbah where
funct in ('sve','cpy','ssv','svd','cpd','ssd','dsv','dcp','cps','cds',
'SVE','CPY','SSV','SVD','CPD','SSD','DSV','DCP','CPS','CDS')
and beg > '19910000000000'
and beg < 'Datum des Restores in YYYYMMDDHHMMSS- Format'
endexec.
exec sql.
delete from sdbad where
funct in ('sve','cpy','ssv','svd','cpd','ssd','dsv','dcp','cps','cds',
'SVE','CPY','SSV','SVD','CPD','SSD','DSV','DCP','CPS','CDS')
and beg > '19910000000000'
and beg < 'Datum des Restores in YYYYMMDDHHMMSS- Format'
endexec.