Re: Current Redo got deleted
From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Sun, 22 Mar 2015 16:48:02 -0500
Message-ID: <CAN5iexGZNmZgH1J6BsNjXkAYVFcUm+2eL_TEoqxLRp_JBQ=d4Q_at_mail.gmail.com>
Sumit--
Date: Sun, 22 Mar 2015 16:48:02 -0500
Message-ID: <CAN5iexGZNmZgH1J6BsNjXkAYVFcUm+2eL_TEoqxLRp_JBQ=d4Q_at_mail.gmail.com>
Sumit--
1..OPEN AN SR -- SEV-1 with Oracle Support 2....MAKE A COMPLETE BACKUP of CURRENT STATE OF THE DATABASE
- Try to mimic an incomplete recovery -- Recover database using backup control file
- You can either use '_allow_resetlogs_corruption=true' and try opening the db with resetlogs
- alter database open reset logs;
- Rebuild the database --probably with datapump/ export
- 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*
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 22 2015 - 22:48:02 CET