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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN report

Re: RMAN report

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 12 Apr 2007 10:43:09 -0700
Message-ID: <bf46380704121043s775fef77w82b5f08c0d75044e@mail.gmail.com>


On 4/12/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> export NLS_DATE_FORMAT='mm/dd/yyyy hh24:mi:ss'
>

rman …..
>
> list backup recoverable;
> Will list all backups with the checkpoint times for each backup.
>

Thanks Tom, that has all the files, but not quite what I am looking for.

At some time in the past while mucking about in RMAN I ran a report or script that would, given a particular recovery time, list all the files (and only those files) needed to restore and recover the database.

I should tell you to go and read a Perl book!
>

Not sure that woiuld help right now.

Though that does remind me that I need to check this out: http://www.polarisdb.com/rman.htm

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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 12 2007 - 12:43:09 CDT

Original text of this message

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