Re: orcle trobule shooting

Article View: comp.databases.oracle.server

Article #47

Back to comp.databases.oracle.server Previous Next

#47

From: Howard J. Rogers
Date: Sat, 23 Oct 2004 14:22

23 lines
1857 bytes

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

Please. Don't be silly. If you have no backup; if you have no archives; if
you've lost data files, control files and online redo logs, your database
is toast. Period. End of discussion.

Regards
HJR

Technical Details

Message-ID: <417a6935$0$24889$afc38c87@news.optusnet.com.au>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed-east.nntpserver.com!nntpserver.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail

References: <1dc813f.0410230523.24aa571b@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: fa4f9,1f83a6dafd96062b
X-Google-Thread: f5464,1f83a6dafd96062b
X-Google-Thread: f99a8,1f83a6dafd96062b
X-Google-Thread: fe428,1f83a6dafd96062b
X-Google-Thread: 103117,1f83a6dafd96062b
X-Google-Attributes: gidfa4f9,gidf5464,gidf99a8,gidfe428,gid103117,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed-east.nntpserver.com!nntpserver.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail
Message-ID: <417a6935$0$24889$afc38c87@news.optusnet.com.au>
From: "Howard J. Rogers" <hjr@dizwell.com>
Subject: Re: orcle trobule shooting
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.marketplace,cern.oracle.cde
Followup-To: comp.databases.oracle.server
Date: Sun, 24 Oct 2004 00:22:57 +1000
References: <1dc813f.0410230523.24aa571b@posting.google.com>
Organization: Dizwell Informatics
User-Agent: KNode/0.7.7
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Lines: 23
NNTP-Posting-Host: 203.164.5.160
X-Trace: 1098541366  24889 203.164.5.160

Reply to Parent Message