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

>>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"?

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Tuesday, November 08, 2011 8:55 AM
To: 'Howard Latham'
Cc: 'oracle-l@xxxxxxxxxxxxx'
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


Other related posts: