Re: RMAN-05019 Warning Oracle reccommended backup

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Thu, 13 Sep 2007 09:05:02 -0700 (PDT)
Message-ID: <956167.18646.qm@web38913.mail.mud.yahoo.com>

This list command output seems a red herring, as these are datafile copies, not RMAN backupsets. I do not believe that the RMAN recommended backup in OEM makes datafile copies, does it? I know you can setup OEM to do datafile copies, but I don't think it's the recommended method.

Also, the dates are like 3 weeks old, so I'm not sure these are related to the problem at hand.

Yeah, let's see those backup logs.

RF
--- hrishy <hrishys_at_yahoo.co.uk> wrote:

> Hi Jared
>
> Thanks for taking a look at this
>
> Here is output you were asking for
> RMAN> list copy of datafile 1, 2, 3;
>
> using target database control file instead of
> recovery
> catalog
>
> List of Datafile Copies
> Key File S Completion Time Ckp SCN Ckp Time Name
> ------- ---- - --------------- ----------
> --------------- ----
> 30 1 A 24-AUG-07 5011977798 23-AUG-07
> +FLASH/ax/datafile/sys
> tem.2130.631249999
> 32 2 A 24-AUG-07 5011977798 23-AUG-07
> +FLASH/ax/datafile/und
> otbs1.2123.631249633
> 23 3 A 24-AUG-07 5011977798 23-AUG-07
> +FLASH/ax/datafile/sys
> aux.2127.631249883
>
> > I don't see any output from a LIST command in your
> > post.
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl
> Evangelist
> >
>
>
>
>

>

>
> Want ideas for reducing your carbon footprint? Visit
> Yahoo! For Good

>
http://uk.promotions.yahoo.com/forgood/environment.html
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!

Oracle Database 11g New Features (Oracle Press)

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

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

Received on Thu Sep 13 2007 - 11:05:02 CDT