Re: RMAN Backup Check/verification

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 02 Mar 2005 21:11:36 -0700
Message-ID: <BE4BDC88.241C5%tim@evdbt.com>

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_at_gmail.com 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_at_yahoo.com> 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

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

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

Received on Wed Mar 02 2005 - 23:13:36 CST