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: BD <bobby_dread_at_hotmail.com>
Date: 8 Jun 2006 08:52:49 -0700
Message-ID: <1149781969.043319.172330@i39g2000cwa.googlegroups.com>


> You could always ( I *think* this was in 8i)...
>
> select max(sequence#) from v$archived_log where backup_count > 0;

Bummer. Works in 9i, not 8i. Oh well.

I'll see if I can make a shell script to do it the other way.

Thanks! Received on Thu Jun 08 2006 - 10:52:49 CDT

Original text of this message

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