Re: Controlfiles just got overwritten
- From: Justin Mungal <justin@xxxxxxx>
- To: Maureen English <maureen.english@xxxxxxxxxx>
- Date: Fri, 18 Jul 2014 16:03:11 -0500
Glad you got through it in one piece. Don't beat yourself up about it! You
handled the situation well.
On Thu, Jul 17, 2014 at 6:01 PM, Maureen English <maureen.english@xxxxxxxxxx
> wrote:
> 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>
>>
>>
>>
>>
Other related posts:
