RE: RMAN report

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 12 Apr 2007 13:27:57 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08D0B@EXCNYSM0A1AJ.nysemail.nyenet>

Jared,  

Would this help?  

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.  

Tom  

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

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Thursday, April 12, 2007 12:26 PM
To: Oracle-L Freelists
Subject: RMAN report  

I *know* there is an RMAN report or a SQL query that can be run to show exactly which files will be needed to do a database restore.

Problem is, I can't remember how to do it, and can't seem to find it either via google or (gasp) reading the docs.

Does someone here recall how to do this?

Thanks,

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

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

Received on Thu Apr 12 2007 - 12:27:57 CDT