Re: recovery of oracle database
From: pathik <dhnpathik_at_gmail.com>
Date: Thu, 1 Apr 2010 11:46:49 -0700 (PDT)
Message-ID: <4059825e-cdaf-42ba-833c-bb21dbc11d95_at_8g2000yqz.googlegroups.com>
On Apr 1, 11:16 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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%2Fa965...
Date: Thu, 1 Apr 2010 11:46:49 -0700 (PDT)
Message-ID: <4059825e-cdaf-42ba-833c-bb21dbc11d95_at_8g2000yqz.googlegroups.com>
On Apr 1, 11:16 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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%2Fa965...
intact means I have all the files are there recovered on separate HDD, but after reload of OS on server what will happen. whether I have to reload oracle9i RDDMS and reload dataabse on it or simply add all the RDBMS files. Received on Thu Apr 01 2010 - 13:46:49 CDT