Re: orcle trobule shooting

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

Everyone else has told you that you gambled and lost.

But I am wondering why you refer to yourself as a DBA when you clearly acknowledge that (1) you do not have even the minimal skill set required to be a DBA; and (2) why if you are responsible for the database you did absolutely nothing required of a reasonably responsible person in that position.

You have failed at your task and should resign in shame.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)