Re: Current Redo got deleted

From: Ram Raman <veeeraman_at_gmail.com>
Date: Mon, 23 Mar 2015 22:36:01 -0500
Message-ID: <CAHSa0M2PPvoH_9fCGxTndN0SCsnaS3QS9bEZFEqb=-_Xt1+24A_at_mail.gmail.com>

Wonder how the step #2 "MAKE A COMPLETE BACKUP of CURRENT STATE OF THE DATABASE" will work in the case of a big database where backing up the current state might take a long time. Especially when the users are screaming in the ears to get things up ASAP.

On Sun, Mar 22, 2015 at 4:48 PM, K Gopalakrishnan <kaygopal_at_gmail.com> wrote:

> Sumit--
>
> 1..OPEN AN SR -- SEV-1 with Oracle Support
> 2....MAKE A COMPLETE BACKUP of CURRENT STATE OF THE DATABASE
>
> a. Try to mimic an incomplete recovery -- Recover database using backup
> control file
> b. You can either use '_allow_resetlogs_corruption=true' and try opening
> the db with resetlogs
> c. alter database open reset logs;
> d. Rebuild the database --probably with datapump/ export
> e. Duplex the redologs / run the db in archive log mode.
>
>
>
> Sent from my iPhone
>
> On Sun, Mar 22, 2015 at 12:31 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com>
> 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*
>>
>>
>

-- 

You can become a doctor and then websearch for solutions; You cannot
websearch and become a doctor

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

Received on Tue Mar 24 2015 - 04:36:01 CET