Thanks Tim for your advice and Link. I am working on it and will update for any issues Thanks Again Sanjay --- Tim Gorman <tim@xxxxxxxxx> wrote: > 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 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l