Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery Question

Re: Recovery Question

From: Cristian Cudizio <>
Date: Mon, 23 Jul 2007 06:36:14 -0700
Message-ID: <>

On Jul 23, 3:17 pm, Paul <> wrote:
> God I love helpful people - do you want me to spend an hour explaining
> why we can't back up the data or do you just assume that in every
> single situation you are right and the poster is an idiot? I stated
> the data is not backed up for a reason, I even said don't bother
> mentioning it.
> We do not 'maintain the data' for anybody. We supply software to
> customers. They maintain their own databases. Every now and again they
> have a problem, either with the data, or with performance. As some of
> our customers have very large databases, these are the best databases
> for us to use for either problem investigation, or for performance
> tuning. So we use them. They are not backed up as quite frankly we do
> not give a stuff what happens to this data - we do not need to recover
> it. Their databases contain confidential data, and part of the
> agreement is that we have to either anonymise their database prior to
> them shipping it, or we cannot back it up. Is that clear?
> Now that I have wasted the time explaining that, back to the original
> point.
> The original database was running, with all data files
> stored in d:\oracle\oradata\<Instance>. The instance was not running
> when it died. It is the 32-bit version of WIndows and Oracle.
> The machine has been rebuilt,but I now need all of the data to be in f:
> \oracle\oradata\<instance>
> I cannot just recreate the instance, then overwrite all of the files,
> because as far as the control files are concerned the data files all
> live in drive d: When I tried copying the original control files
> across it gave the error "could not identifiy control file".
> I do actually have an export of the data prior to the point at which
> the machine died - all that actually happened by the way is that the
> disk with the Oracle Home on it died completely.
> I could quite easily recreate the instance and import the data, but I
> hoped that I could find somebody helpful to allow me to expand my
> experience.
> I do not see that this would be a different process whether using 32-
> bit or 64-bit,and I do not really see what ports have to do with
> anything either. I realise that people here have vastly greater
> experience than myself, which is why I was hoping for a bit of help,
> maybe others would rather just put people trying to learn down rather
> than coming up with any helpful suggestions.

I'm not sure to have completely understand: if you have your origina control files you don't have to recreate them, where controlfiles are is written into spfile (you can use textual pfile to start with), then you have to start database in mount mode, make
alter database rename datafile ...
then you can open database.
To increase your experience use with i've written and what is written on manuals (exact sintax)

If windows 2003 , it is 32 bit or 64 has not a size limit of 2GB if you use NTFS that limit is of fat32 and i hope you have not a server with fat32 filesystem.


 Cristian Cudizio Received on Mon Jul 23 2007 - 08:36:14 CDT

Original text of this message