Re: RMAN report

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 12 Apr 2007 17:43:21 -0700
Message-ID: <bf46380704121743l16aee0c2p5871cd363aef8d77@mail.gmail.com>

On 4/12/07, Johnson, William L (TEIS) <WLJohnson_at_tycoelectronics.com> wrote:
>
> Try this…
>
> select distinct media from <rman schema account>.bp
>
> where start_time > to_date('03-17-2003 12:00:00', MM-DD-YYYY
> HH24:MI:SS')
>
> and start_time < to_date('03-18-2003 12:00:00', MM-DD-YYYY
> HH24:MI:SS');**
>
> and provide specify a window where you know the backup occurred…
>

Only with a catalog database.

I'm finding more reasons to re-think my decision to not use an RMAN Catalog.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Thu Apr 12 2007 - 19:43:21 CDT