Re: orcle trobule shooting
From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sat, 23 Oct 2004 16:19:29 +0200
Message-ID: <90qkn058neditc17nkltab3qf1ut777ua0_at_4ax.com>
Date: Sat, 23 Oct 2004 16:19:29 +0200
Message-ID: <90qkn058neditc17nkltab3qf1ut777ua0_at_4ax.com>
On 23 Oct 2004 06:23:04 -0700, arjdombivli_at_indiatimes.com (ashok) wrote:
>dear all!
>
>I am working as dba. I am facing problem,one of hard is crashed. No
>backup
>is available.Databse is nonarchival mode. The disk which has gone
>bad,contains
>two tablespaces,and two indexdatafiles and 2 control files replica of
>each other.and 3 redologfils.
>How to bring database up and how to create indexdatafiles,control
>files, and redo logfiles. database in archival mode.
>
>
>regards
>arj
Think logically. You have no backup and you are running in noarchivelog mode. So what magic should we recommend to help you recover the database?
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Oct 23 2004 - 16:19:29 CEST