(Update): Controlfiles just got overwritten

I was in the process of recreating the standby database...long story...and didn't realize that I was on the production server when I went to copy my standby control files to the appropriate directories.

After spending an hour and a half trying to do the easy recover, we ended up doing a full recover of the database. Since I had restarted the database after it crashed and it thought it was a standby database, the system datafiles were messed up. I'm sure there was a better solution, but we did what we knew would work.

Yes, that practicing of recovery is a really good idea...even if you think you know what you're doing, you should practice, practice, practice!

• Maureen

On 7/14/2014 4:21 PM, Kenny Payton wrote:
> Maureen,
>
> Hopefully you were able to recover from the mishap. I learned a similar lesson early on in my career, maybe 3 months
> into my first DBA job, where I over wrote production datafiles while cloning to a lessor environment. I made two
> changes following this mishap, I started included including the sid name in my datafiles ( when using filesystems ) and
> committed to practicing backup and restore scenarios.
>
> The biggest key here has already been stated, the best thing you can do is try to stay calm and proceed carefully.
>
> Best of luck,
> Kenny
>
>
>
> On Jul 14, 2014, at 6:55 PM, Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com <mailto:riyaj.shamsudeen_at_gmail.com>> wrote:
>
>> Hi
>> Recovery will start from the current state of the datafile, as he will have to use the backup control file option.
>> So, yesterday's archive log files are not required at all. However, to avoid data loss, he must apply current online
>> redo log file also.
>>
>> Cheers
>>
>> Riyaj Shamsudeen
>> Principal DBA,
>> Ora!nternals - http://www.orainternals.com <http://www.orainternals.com/> - Specialists in Performance, RAC and EBS
>> Blog: http://orainternals.wordpress.com/
>> Oracle ACE Director and OakTable member <http://www.oaktable.com/>
>> Co-author of the books: Expert Oracle Practices <http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL,
>> <http://tinyurl.com/ahpvms8><http://tinyurl.com/ahpvms8>Expert RAC Practices 12c. <http://tinyurl.com/expert-rac-12c>
>> Expert PL/SQL practices <http://tinyurl.com/book-expert-plsql-practices>
>>
>> <http://tinyurl.com/book-expert-plsql-practices>
>>
>>
>>
>> On Mon, Jul 14, 2014 at 3:49 PM, <rajendra.pande_at_ubs.com <mailto:rajendra.pande_at_ubs.com>> wrote:
>>
>> How much is the redo volume between yesterday and today
>> One really safe option would be to get controlfile from yesterday and recover
>> As the datafiles already have the changes I suspect the recovery will go pretty fast
>>
>> Regards
>>
>>
>> -----Original Message-----
>> From: Maureen English [mailto:maureen.english_at_alaska.edu <mailto:maureen.english_at_alaska.edu>]
>> Sent: Monday, July 14, 2014 6:48 PM
>> To: Pande, Rajendra; andrew.kerber_at_gmail.com <mailto:andrew.kerber_at_gmail.com>
>> Cc: oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>> Subject: Re: Controlfiles just got overwritten
>>
>> I have a backup of the controlfiles from yesterday...it was in recreating the standby that caused my problem...I
>> was on the wrong server.
>>
>> - Maureen
>>
>> On 7/14/2014 2:41 PM, rajendra.pande_at_ubs.com <mailto:rajendra.pande_at_ubs.com> wrote:
>> > If you create the controlfile now you will need to run rudimentary
>> > recovery and then open database with reset logs
>> >
>> > Can you not failover to DR and then rebuild the primary
>> >
>> > Or open the DR make the old primary new DR and then do a switch again
>> >
>> >
>> > Regards
>> >
>> >
>> >
>> Please visit our website at
>> http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
>> for important disclosures and information about our e-mail
>> policies. For your protection, please do not transmit orders
>> or instructions by e-mail or include account numbers, Social
>> Security numbers, credit card numbers, passwords, or other
>> personal information.
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Maureen English
Lead Database Administrator
University of Alaska
Fairbanks, AK
(907) 450-8329
--
http://www.freelists.org/webpage/oracle-l