Re: recovery of oracle database
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 1 Apr 2010 11:16:26 -0700 (PDT)
Message-ID: <f4b27bcc-e51c-4a57-869e-d59bda25af68_at_v16g2000vba.googlegroups.com>
On Apr 1, 1:43 pm, pathik <dhnpat..._at_gmail.com> wrote:
> My oracle9i server got currupted and we have recovered data from hard
> disks. Now I want to reinstall the server on the machine, and install
> oracle9i server on it. I have got all Data file, control files etc
> intact. how can I recover the database.
Date: Thu, 1 Apr 2010 11:16:26 -0700 (PDT)
Message-ID: <f4b27bcc-e51c-4a57-869e-d59bda25af68_at_v16g2000vba.googlegroups.com>
On Apr 1, 1:43 pm, pathik <dhnpat..._at_gmail.com> wrote:
> My oracle9i server got currupted and we have recovered data from hard
> disks. Now I want to reinstall the server on the machine, and install
> oracle9i server on it. I have got all Data file, control files etc
> intact. how can I recover the database.
What do you mean, "intact"? Do you mean you have all the files, but don't know if they are consistent? Were the files the result of a cold backup? If the instance was actively using the database files when the server went down, then you *might* have recovery issues.
I would start with the backup and recovery docs, namely:
http://www.oracle.com/pls/db92/db92.to_toc?pathname=server.920%2Fa96519%2Ftoc.htm&remark=docindex Received on Thu Apr 01 2010 - 13:16:26 CDT