Re: disaster recovery

On May 19, 2:44 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Ben wrote:
>
> > Sybrand is too rude to be better at anything for my taste. I'd rather
> > shake hands with a tasmanian devil than have to put up with his
> > condecsending comments.
>
> 1) Tasmanian devils do not have hands...
> 2) Sybrand is right - if you have no controlfile(s) in your backup,
> (and your online ones are lost, so I understand) you are skrewed...
> Maybe Sybrands language is not always as political correct as you
> wish, but hey, he's not in politics, now is he?
> Neither am I, btw, and -apart from being countrymen- I am not
> associated with Sybrand in any way.

He's right about a lot of things, I just don't like him. I'm not necessarily politically correct myself, you don't have to be if your not an asshat along with it.

> Sorry for the delay(s), I'm less online than I want, lately.
>
> How are the attempts to get your datafiles back online
> going on? Any chance you might recover some (all?!?) files
> from disk?

well, my attempts at recovering the controlfile and spfile from backup pieces via pl/sql would probably have went better if it weren't for problems with the tape library and veritas. I did however get to use a auto snap of the controlfile on disk and got the database mounted and ready for use with rman & controlfile. But alas veritas still has problems and is not being very cooperative in getting me my datafiles back. It's looking like we might have to fall back on an old copy of the database and then import some crucial data from exports that were made the night before the failure.

> That would make your life real easy... Just mount, recover,
> and you're probably done (assuming your development was
> not executing heavy jobs during black out).

The files weren't accessible after the failure to mount. The entire file system had to be re-created and we had an older (6 months) copy of the database on some disks that didn't get wiped out. Those will probably be our fall back.

>
> You could try to restore the spfile from the backup piece
> (if you know where rman stored it).
> Nevertheless, without control file... Did you try with
> using backup controlfile? That would signal RMAN that
> you are using an out of date controlfile, and that the
> control file(s) should be rewritten according to data
> from the datafiles.
>
> FvB

Thanks for all the info once again. Received on Mon May 19 2008 - 14:47:02 CDT