Re: Controlfiles just got overwritten

  • From: Maureen English <maureen.english@xxxxxxxxxx>
  • To: Justin Mungal <justin@xxxxxxx>
  • Date: Thu, 17 Jul 2014 15:01:37 -0800

I ended up recovering the database from a backup done the day before and 
rolling forward.

I also modified my instructions for recreating a standby database.  Instead of 
'cp -p' to copy
my standby control file to the appropriate directory on the standby server, I 
will now use 'cp -pi'.

I'm still feeling badly for making this mistake, but I'm amazed at how 
understanding my coworkers
have been.

- Maureen

On 7/16/2014 11:00 PM, Justin Mungal wrote:
How did it go? I've been in situations where the current control files were no 
longer valid. Sometimes recreating them
has been the simplest thing to do.


On Mon, Jul 14, 2014 at 5:23 PM, Maureen English <maureen.english@xxxxxxxxxx 
<mailto:maureen.english@xxxxxxxxxx>> 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
    --
    //www.freelists.org/__webpage/oracle-l 
<//www.freelists.org/webpage/oracle-l>



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


Other related posts: