Re: (Update): Controlfiles just got overwritten
- From: George Leonard - Business Connexion <George.Leonard@xxxxxxxxx>
- To: "maureen.english@xxxxxxxxxx" <maureen.english@xxxxxxxxxx>
- Date: Tue, 15 Jul 2014 04:26:04 +0000
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@xxxxxxxxx<mailto:george.leonard@xxxxxxxxxx>
Web: http://www.bcx.com<mailto:george.leonard@xxxxxxxxxx>
[cid:6EA60917-E50D-422D-BF1F-E8C59EADC861]
On 15 Jul 2014, at 5:51 AM, Maureen English
<maureen.english@xxxxxxxxxx<mailto:maureen.english@xxxxxxxxxx>> 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@xxxxxxxxx<mailto:riyaj.shamsudeen@xxxxxxxxx>
<mailto:riyaj.shamsudeen@xxxxxxxxx>> 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@xxxxxxx<mailto:rajendra.pande@xxxxxxx>
<mailto:rajendra.pande@xxxxxxx>> 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@xxxxxxxxxx
<mailto:maureen.english@xxxxxxxxxx>]
Sent: Monday, July 14, 2014 6:48 PM
To: Pande, Rajendra; andrew.kerber@xxxxxxxxx<mailto:andrew.kerber@xxxxxxxxx>
<mailto:andrew.kerber@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxx<mailto:rajendra.pande@xxxxxxx>
<mailto:rajendra.pande@xxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
--
Maureen English
Lead Database Administrator
University of Alaska
Fairbanks, AK
(907) 450-8329
--
//www.freelists.org/webpage/oracle-l
Other related posts:
