logminer issue

 There is a dll executed against the table on 26-JAN-2014 15:48:00.

I checked the log sequence number from alert log which came out to be between 15:00:00 and 16:00:00 as 1004159 until sequence 1004163;

Following steps were performed thereafter:

RMAN RESTORE

RMAN> run

 {

 allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/oraprod05_01/app/oracle/admin/rmancfg/tdpo.opt)';

 restore archivelog from sequence 1004159 until sequence 1004163;

 release channel t1;

 }2> 3> 4> 5> 6>

allocated channel: t1

channel t1: sid=794 devtype=SBT_TAPE

channel t1: Data Protection for Oracle: version 5.5.2.0

Starting restore at 27-JAN-2014 11:41:24

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=1004159