Re: Current Redo got deleted

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Mon, 23 Mar 2015 02:22:03 +0530
Message-ID: <CAFW4NVyX_4Rxrwo0qzeWroa6z2dNJ+mgDZRLhzriHCbxXNCGcA_at_mail.gmail.com>

Issue was resolved already by performing Incomplete recovery it was not a live prod DB . But i want to know what other options can we have .

On Mon, Mar 23, 2015 at 2:11 AM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

> On 22/03/2015 2:09 PM, sumit Tyagi wrote:
>
>> 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 .
>>
>
> If you are not sure what you are doing, stop all activity immediately and
> open a service request with Oracle.
>
> Trying to proceed without professional help will likely dig a deeper hole
> for you.
>
> And ask yourself why the 'big DB' was so horribly mis-configured to have
> only one redo log. What other things did the DBA [team] do wrong?
>
> /Hans
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Mar 22 2015 - 21:52:03 CET