Re: Why I don't like RMAN repositories
Date: Wed, 11 Dec 2013 14:37:37 -0600 (CST)
Message-ID: <d64413bd67d2f73ed01b932e4afdc707.squirrel_at_society.servebeer.com>
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!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 11 2013 - 21:37:37 CET