Re: orcle trobule shooting

Article View: comp.databases.oracle.server

Article #46

Back to comp.databases.oracle.server Previous Next

#46

From: Sybrand Bakker
Date: Sat, 23 Oct 2004 14:19

26 lines
1870 bytes

On 23 Oct 2004 06:23:04 -0700, arjdombivli@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 DBA

Technical Details

Message-ID: <90qkn058neditc17nkltab3qf1ut777ua0@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!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!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <gooiditweg@sybrandb.verwijderdit.demon.nl>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.marketplace,cern.oracle.cde
Subject: Re: orcle trobule shooting
Date: Sat, 23 Oct 2004 16:19:29 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <90qkn058neditc17nkltab3qf1ut777ua0@4ax.com>
Reply-To: postbus@sybrandb.verwijderdit.demon.nl
References: <1dc813f.0410230523.24aa571b@posting.google.com>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 26

Reply to Parent Message