I run into a problem with a customer which had no proper backup.
His last backup (meaning exp-dump) is from 1st Aug 2011.
However he lost due to batch DELETE statements all data.
My plan was now to get the redo-sql from the logs, import the dump and replay all sql from 1st Aug up to 2nd Sept (just before the batch DELETE happened).
However I am stuck because
V$LOG_HISTORY shows me logs back to February 2011 but no
V$ARCHIVED_LOG entries to know which logs to include into LogMiner.
So: How can i load this
V$LOG_HISTORY logs into the LogMiner to get the redo-sql or how else can I get the redo-sql or replay it based on the dump-file fromn 1st Aug?
Side notes: This is a single alone (like an orphant) oracle 9.2 installation on a linux server.