RE: RMAN Recovery - I'm missing a step or something

You need to specify a time or sequence after the backup completes so that the database can be recovered to a consistent state. RMAN would have been looking for the previous full backup as its starting point to recover to a sequence that happened while the backup was running.

Thanks,
T. J.
 
The information contained in this message is privileged and confidential information intended only for the use of the individual or entity identified above. If the receiver of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by replying to his/her e-mail address noted above and delete the original message, including any attachments. Thank you.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Tuesday, November 08, 2011 8:55 AM To: 'Howard Latham'
Cc: 'oracle-l_at_freelists.org'
Subject: RE: RMAN Recovery - I'm missing a step or something

Well, that *is* curious....
If I leave off the seq #, the restore begins correctly.

Have I forgotten some piece of Oracle recovery basics? I thought I should be able to recover to any log sequence# in the backup using "...until sequence xxx"?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205

"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

--
http://www.freelists.org/webpage/oracle-l