Re: Controlfiles just got overwritten
Date: Mon, 14 Jul 2014 15:55:33 -0700
Message-ID: <CAA2DszzuwVUmNDU-NQdG80PpFXUOKBCKc2M2KrQ8nTzP-BaTWA_at_mail.gmail.com>
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 <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> 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]
> Sent: Monday, July 14, 2014 6:48 PM
> To: Pande, Rajendra; andrew.kerber_at_gmail.com
> Cc: 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 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 15 2014 - 00:55:33 CEST