Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recover is looking for an obsoleted sequence??

Alan3Aug 25 2010 — edited Aug 27 2010
I'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!
This post has been answered by Philippe Florent on Aug 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2010
Added on Aug 25 2010
45 comments
3,575 views