Re: one datafile and redo log files both r corrupted

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 30 Apr 2006 01:14:44 -0700
Message-ID: <1146384884.048636.258300@j73g2000cwa.googlegroups.com>

>In my database both all redo log files and one datafile is corrupted
>My database is in archive log mode
>database is shutdown, how can I start it again without loosing commit
>data

You need to restore the corrupt data file from the last backup and then recover it using archived logs and online logs, if available. As of corrupt online redo logs, depending on their state (current, active or inactive,) you can get away with clearing the damaged log group (if it was inactive) or recreating it and doing incomplete recovery followed by ALTER DATABASE OPEN RESETLOGS. In any case, take fresh full backup of the database after successful recovery. Note that if you lost an active redo log group, then all transactions covered by it are lost as well.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Sun Apr 30 2006 - 03:14:44 CDT