Re: Current Redo got deleted

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: dba.tyagisumit@xxxxxxxxx
  • Date: Sun, 22 Mar 2015 16:48:02 -0500

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@xxxxxxxxx>
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*
>
>

Other related posts: