Re: Controlfiles just got overwritten
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: riyaj.shamsudeen@xxxxxxxxx
- Date: Mon, 14 Jul 2014 20:21:08 -0400
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>
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 - Specialists in Performance, RAC
> and EBS
> Blog: http://orainternals.wordpress.com/
> Oracle ACE Director and OakTable member
> Co-author of the books: Expert Oracle Practices, Pro Oracle SQL, Expert RAC
> Practices 12c. Expert PL/SQL practices
>
>
>
>
> On Mon, Jul 14, 2014 at 3:49 PM, <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]
> Sent: Monday, July 14, 2014 6:48 PM
> To: Pande, Rajendra; andrew.kerber@xxxxxxxxx
> Cc: 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 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
>
>
>
Other related posts:
