Re: QUESTION - rman 8i - how to capture last backed up sequence number...?

Hmmm.... that returns a value one higher than the rman report. So I presume I won't need the +1 increment. But I'll work with it.

At this point, I'm thinking it may be just as 'reliable' to get the value straight from rman: run the report to a text file, isolate the line of the output file containing the target value, and somehow with shell scripting, capture those values and get them into my 'template' script that is generated with the backup. Only drawback with this method is that the only way I've found thus far to return that last sequence number is a full report of all backupsets (list backupset of archivelog all)... which takes a little bit of time and disk churning. Not a big deal, but if I can reliably get the same value from a quick and dirty select statement, so much the better.

Thanks for the suggestions, folks. If this all ends up being workable, I'll post an update. At this point, I'm confident.

ravisista_at_gmail.com wrote:
> Since the OP wants to include the output in the "until" clause, I think
> we need to bump the result by 1.
>
> SQL> select to_char(nvl(max(sequence#),0)+1) from v$backup_redolog;
>
> may do the trick. Try it and let us know.
Received on Thu Jun 08 2006 - 11:20:30 CDT