Recreate capture process

select * from dba_queue_tables

BEGIN

  dbms_capture_adm.drop_capture(capture_name          => 'RSA_STREAMS_CAPTURE',
                                drop_unused_rule_sets => TRUE);

END;


BEGIN
  dbms_streams_adm.add_schema_rules(queue_name         => 'RSA_STREAMS_CAPTURE_Q',
                                    streams_type       => 'CAPTURE',
                                    streams_name       => 'RSA_STREAMS_CAPTURE',
                                    schema_name        => 'RSA_REP',
                                    include_dml        => TRUE,
                                    include_ddl        => FALSE,
                                    include_tagged_lcr => TRUE,
                                    inclusion_rule     => TRUE);

END;

list Opatch on non-default folder

/opatch lsinventory -invPtrloc /export/home/qeuser/AuthMgr/db/oraInst.loc

Using RMAN to deregister the missing archived log files

rman

connect target sys/<>
crosscheck archivelog all
delete expired archivelog all