Re: (Update): Controlfiles just got overwritten

From: George Leonard - Business Connexion <George.Leonard_at_bcx.co.za>
Date: Tue, 15 Jul 2014 04:26:04 +0000
Message-ID: <E9B7317E-7D6B-4AA6-9A30-952BBCE7CEB2_at_bcx.co.za>



old saying

Your backup processes is only as good as your last recovery test.

And as the guys sid, the most important thing, sit down, calm down, relax, (I'e personally added, don't matter how big or small, open a SR with Oracle), we do this type of recovery hopefully only once, they have guys that help customers daily with it, experience and work arounds are their business.

Yours Sincerely



George Leonard
Oracle Engineered System Specialist

Mobile: +27.82 655 2466
eMail: george.leonard_at_bcx.co.za<mailto:george.leonard_at_oracle.com> Web: http://www.bcx.com<mailto:george.leonard_at_oracle.com>

[cid:6EA60917-E50D-422D-BF1F-E8C59EADC861]

On 15 Jul 2014, at 5:51 AM, Maureen English <maureen.english_at_alaska.edu<mailto:maureen.english_at_alaska.edu>> wrote:

Thanks to all for the suggestions, comments, support!

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> <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> <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> <mailto:andrew.kerber_at_gmail.com>    Cc: oracle-l_at_freelists.org<mailto: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> <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









-- http://www.freelists.org/webpage/oracle-l
image003.gif
Received on Tue Jul 15 2014 - 06:26:04 CEST

Original text of this message