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

Sir,

here I don't have any backup that is the problem.
I don't corrupt datafile.
pls help........................

On 30 Apr 2006 05:08:45 -0700, "aman.oracle.dba"
<aman.oracle.dba (AT) gmail (DOT) com> wrote:

If you don't have a backup no one can help you.

--
Sybrand Bakker, Senior Oracle DBA

aman.oracle.dba wrote:
Why don't you have a backup? Taking backups should be job#1 of the DBA
in charge of that database. Without a good backup *and* recovery
strategy, you may lose your company's vital data.

Cheers,
Brian



--
================================================== =================

Brian Peasland
oracle_dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

aman.oracle.dba wrote:
Stop trolling the newsgroup with these posts, as they will do you more
harm than good. This is not a true scenario (exactly like your last
attempt at posting in this group) so stop acting as though it were.
Keep this up and when a true emergency arises and you, as a junior DBA,
need to get information none will be available as you've cried 'wolf'
needlessly far too many times to ever be trusted.

Now, post the TRUTH of this matter if you truly want assistance.
Otherwise you'll open yourself up to the same ridicule you received
with your last submission.


David Fitzjarrell

I did recover my data
I was working on my personnal personal database and just want to
prepare for any situation.

Thank You

I recovered my database

Thank You