Re: RMAN Backup Check/verification
- From: Tim Gorman <tim@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 02 Mar 2005 21:11:36 -0700
Funny thing about RMAN; the REPORT and LIST commands still don't tell you
what you really need to know. For instance, REPORT NEEDS BACKUP only tells
you what datafiles have not been backed up. Does that really answer the
question of "Have I backed up what needs to be backed up"?
I've posted an early version of a report that tells you what you really need
to know (i.e. can I recover from an online backup and recover to a specified
point-in-time?) on http://www.EvDBT.com/tools.htm. There are several
variations on this in the script "rman_chk_nocatalog.sql" (for use in the
target database), "rman_chk_catalog.sql" (for use in the recovery catalog
database), and "rman_chk_test.sql".
on 3/2/05 1:00 PM, Sami Seerangan at dba.orcl@xxxxxxxxx wrote:
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquery.h
> tm#440167
>
>
>
> On Wed, 2 Mar 2005 11:36:06 -0800 (PST), Sanjay Mishra
> <smishra_97@xxxxxxxxx> wrote:
>>
>> Hi
>>
>> I am new to RMAN and now starting working on it. I got
>> the inital task as to make sure that if RMAN backup is
>> working fine. Can I run any script that can check the
>> Catalog database and give me the result that it is
>> going fine. RMAN is putting backup to Veritas
>> Netbackup
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
