Recover is looking for an obsoleted sequence??
Alan3Aug 25 2010 — edited Aug 27 2010I'm trying to recover a database strictly from my RMAN compressed backup files. This is mainly for testing the backups.
The backups are handled through jobs on EM Grid - a L0 every Sunday and L1 throughout the week with a 7-day recovery window.
I have copied all my backup files to a clean server, restored the spfile, the control files, and the database.
All that seems to work fine until I 'recover database'
---------------------------------------------------------------------
unable to find archive log
archive log thread=1 sequence=114979
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/oradata/ORADB/system01.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/25/2010 17:47:00
RMAN-06054: media recovery requesting unknown log: thread 1 seq 114979 lowscn 271439926
---------------------------------------------------------------------
The deal here - the earliest sequence I find in my backup files is 196783 - and that is from 08/04/2010...
Why would it be looking for a sequence that is outside my recovery window? Sequence 114979 would be well over a year old.
Keep in mind, I'm using a fairly standard 'Oracle suggested' backup here... either I'm restoring wrong or my backup strategy is completely useless.
Please advise.
Thanks!