Re: rman listing old backups

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Tue, 8 Sep 2015 08:25:43 -0700
Message-ID: <CAKsxbLp8ROoT94c8tJtmhtFsR_A1fOBdKiAW_MRQuaFFqfQkog_at_mail.gmail.com>

Ok sorry you are right that does sound confusing. When I log into rman catalog from the command line these old backups do not show up. But from EM where I configured it to use the catalog and I navigate to Availability --> Backup and Recovery --> Backup Reports, it shows these old backups. I am not sure what EM is doing different than a list backup from the command line. When I changed EM to not use the catalog then the old backups do not show up. Does this make more sense.

Reset logs has not happend for many years and no the DBID or the DB_NAME has not changed.

On Mon, Sep 7, 2015 at 9:02 PM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:

> You say :
>
> These backups only show when using the catalog, without it they do not
> show up.
>
>
>
> But in the first email you say :
>
> when I log into rman catalog and run a list backup summary those backups
> do not show up
>
>
>
> Which is it ?
>
> Are the backups shown when connected to the Catalog and not shown when not
> connected to the Catalog ?
>
>
>
> Has there been a RESETLOGS for the database after those backups ? Has the
> DBID and/or DB_NAME been changed ?
>
>
>
> Was the Catalog created and populated (with a REGISTER DATABASE or a
> RESYNC (full)) **after** a RESETLOGS ?
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jeff Chirco
> *Sent:* Tuesday, September 08, 2015 1:48 AM
> *To:* John Thomas; oracle-l_at_freelists.org
> *Subject:* Re: rman listing old backups
>
>
>
> These backups only show when using the catalog, without it they do not
> show up.
>
>
>
> On Mon, Sep 7, 2015 at 9:19 AM, John Thomas <jt2354_at_gmail.com> wrote:
>
> Have you tried connecting without the catalog and deleting from the
> command line?
>
> Just a thought.
>
> Regards
> J
>
>
>
> On Mon, 7 Sep 2015 17:13 Jeff Chirco <backseatdba_at_gmail.com> wrote:
>
> When I run a backup report from EM it is listing some very old backups
> that should be deleted based on my retention policy. But when I log into
> rman catalog and run a list backup summary those backups do not show up.
> I've run a crosscheck backup, backupset, copy and delete obsolete and
> expired backups but they still show up. I don't get it. How can I remove
> these backups? One of them is a failed backup from April.
>
> Jef
>
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
>

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

Received on Tue Sep 08 2015 - 17:25:43 CEST