Re: orcle trobule shooting
Date: Sat, 23 Oct 2004 14:20:17 GMT
Message-ID: <BMted.6987$i02.2297_at_fe1.news.blueyonder.co.uk>
"Access" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message
news:417a5c39$0$22741$ba620e4c_at_news.skynet.be...
>
> "ashok" <arjdombivli_at_indiatimes.com> wrote in message
> news:1dc813f.0410230523.24aa571b_at_posting.google.com...
>> 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
>
> What do you mean : "no backup is available" ?
>
>
it means he has no backup available, which means he is toast, database gone practically.
Might just have to offline drop those datafiles and see where you are Received on Sat Oct 23 2004 - 16:20:17 CEST