Re: rman crosscheck question

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 11 Apr 2008 07:48:21 -0700 (PDT)
Message-ID: <a4f917b2-d5fe-4439-a5cc-f228638e72b5@l64g2000hse.googlegroups.com>


On Apr 11, 10:20 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> What would cause this with rman 10.2.0.3?
>
> I use Tivoli tdpo for my media manager. They provide a utility -
> tdposync - which crosschecks backup pieces in the tdpo library against
> the rman catalog to see if it has any that are no in the rman catalog.
> It's sort of the inverse of rman's crosscheck.
>
> Tdposync shows some backup pieces that it can't find in the rman
> repository, so I go into rman and run "crosscheck backup". It finds
> nothing wrong. I verify this by running "list expired backup" and it
> lists nothing. I go back into tdposync and the backup pieces that it
> listed 2 minutes prior are no longer listed.
>
> Any ideas? Does rman crosscheck do more to the catalog than what is
> listed in the documentation? Does it perhaps silently fix something?

Can you create a reproducible test case? That might give some of here at cdos a better stab at helping you with your question.

The crosscheck backup command will ( potentially ) make some changes to rows in v$backup_set ( maybe v$datafile_copy ) for a control file or rc_backup_set (etc) for a recovery catalog afaik mostly concentrating on the status codes ( available ... still valid in backup media or expired ).

In general I think you should be driving from the rman side instead of the tivoli side. Perhaps your question can be submitted into tivoli support if you really need to use tdposync?

Keeping a control file backup based catalog or a real recovery catalog healthy and useful by running crosscheck on a repeating/periodic basis ( varies by your requirements ) is potentially an area that you want to check out and maybe make some changes in how you are operating right now. Received on Fri Apr 11 2008 - 09:48:21 CDT

Original text of this message