Re: Controlfiles just got overwritten

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 14 Jul 2014 17:33:09 -0500
Message-ID: <CAJvnOJYVS-ppeAqA8Dm6w1JX3iMWaL171V2Hn-KPPvr0rzZsFg_at_mail.gmail.com>

What OS? Did the DB crash? If this is Linux, I understand that there is something a way to do it if the files were locked... I dont know the details, something with the inodes as I recall, but I could be completely wrong about that.... If not, I would run a create controlfile script rather than restoring from backup.

On Mon, Jul 14, 2014 at 5:23 PM, Maureen English <maureen.english_at_alaska.edu
> wrote:

> I just did one of the stupidest things in my life and overwrote our
> production
> database control files with a copy of the standby controlfile.
>
> I have a backup of the real control files from yesterday afternoon, but
> we've
> been up and running all day. Is there an easy way to recover my control
> files
> and be back running any time soon?
>
> - Maureen
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 15 2014 - 00:33:09 CEST