Re: Why I don't like RMAN repositories

From: Rich Jesse <>
Date: Wed, 11 Dec 2013 14:37:37 -0600 (CST)
Message-ID: <>

Tim writes:

> The sysadmins for tape management said, "Yeah, we've
> got everything going back 3 months, but you gotta tell me the file-name
> so I can find it and retrieve it".

Really??!?!? Tivoli allows one to tip-toe through the virtual tulips of the backup history of a server. And since I have RMAN put CFs -- I just realized that's a funny and somewhat appropriate abbreviation in this context -- in their own subdirectory, selective retrieval of them by timestamp is trivial, as are the other backups in the FRA.

> So, in the end, what I did was first make an image copy of everything in
> case I screwed up, which is always the best first step of any recovery
> process.

As mentioned by others, "+1"!

> But, it also proves that it would have been a easier and faster if we
> had recovery catalog information going back 30+ days *somewhere*.

In your case, yes. In our case, I still do not think so.

> Augment the belt with suspenders.
> Or don't. It's a choice.

And I'm glad we still have that choice!


Received on Wed Dec 11 2013 - 21:37:37 CET

Original text of this message