Re: Current Redo got deleted
Date: Mon, 23 Mar 2015 01:39:21 +0530
Message-ID: <CAFW4NVydZi9VJ-Me0J+ZQrjBzfmjxcZK9bAUkmwy338xY2x29w_at_mail.gmail.com>
Redo log was not duplexed .Alter database clear logfile command failed with some error ..i will check the same with the dba who was working on it ... Is only incomplete recovery of whole database only solution ? It is a big DB arounf 1TB size .
On Mon, Mar 23, 2015 at 12:16 AM, Tim Gorman <tim_at_evdbt.com> wrote:
> Sumit,
>
> Let me guess: Was the file-extension of the online redo log files called
> ".log", by any chance? Borrowing a legal term, that file-extension with
> online redo log files is an "attractive nuisance", because it practically
> begs someone with more permission than knowledge to delete them when they
> are trying to clear away space in a file-system. After all, how important
> is a file named ".log", right?
>
> Always use another file-extension, such as ".rdo" or ".dbf", to give even
> the dullest neatnik a reason to pause and think before using "rm".
>
> As for your first reaction, create an SR with Oracle Support and work with
> them closely on this.
>
> Support will step through the details with you, but if you are lucky the
> instance did not crash until a log switch was attempted, and hopefully a
> successful checkpoint occurred at that time. If that is the case, you
> might get away with a simple ALTER DATABASE CLEAR LOGFILE command. At
> worst, you'll have to do an incomplete recovery.
>
> Best wishes and best of luck,
>
> -Tim
>
>
>
> On 3/22/15 11:31, sumit Tyagi wrote:
>
> Hi Guys ,
>
> How to deal with this " Current redo got deleted & DB crashed " . What
> are the option we have as a DBA
>
> *--*
> *BR*
> *Sumit Tyagi*
>
>
>
-- *--* *BR* *Sumit Tyagi* *+91-7829543355* -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 22 2015 - 21:09:21 CET