Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: QUESTION - rman 8i - how to capture last backed up sequence number...?

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

From: <ravisista_at_gmail.com>
Date: 8 Jun 2006 08:13:59 -0700
Message-ID: <1149779639.205782.181900@h76g2000cwa.googlegroups.com> 





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 - 10:13:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US