Re: disaster recovery

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 19 May 2008 20:44:38 +0200
Message-ID: <68fcd$4831ca96$524b5c40$378@cache4.tilbu1.nb.home.nl>


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.

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?
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).

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 Received on Mon May 19 2008 - 13:44:38 CDT

Original text of this message