Article View: comp.databases.oracle.server
Article #45Re: orcle trobule shooting
From: David Sharples
Date: Sat, 23 Oct 2004 14:20
Date: Sat, 23 Oct 2004 14:20
29 lines
2232 bytes
2232 bytes
"Access" <idmwarpzone_NOSPAM_@yahoo.com> wrote in message news:417a5c39$0$22741$ba620e4c@news.skynet.be... > > "ashok" <arjdombivli@indiatimes.com> wrote in message > news:1dc813f.0410230523.24aa571b@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
Technical Details
Message-ID:
<BMted.6987$i02.2297@fe1.news.blueyonder.co.uk>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!pe1.news.blueyonder.co.uk!blueyonder!fe1.news.blueyonder.co.uk.POSTED!53ab2750!not-for-mailReferences:
<1dc813f.0410230523.24aa571b@posting.google.com> <417a5c39$0$22741$ba620e4c@news.skynet.be>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!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!pe1.news.blueyonder.co.uk!blueyonder!fe1.news.blueyonder.co.uk.POSTED!53ab2750!not-for-mail From: "David Sharples" <x@x.com> Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.marketplace,cern.oracle.cde References: <1dc813f.0410230523.24aa571b@posting.google.com> <417a5c39$0$22741$ba620e4c@news.skynet.be> Subject: Re: orcle trobule shooting Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: <BMted.6987$i02.2297@fe1.news.blueyonder.co.uk> Date: Sat, 23 Oct 2004 14:20:17 GMT NNTP-Posting-Host: 82.39.104.202 X-Trace: fe1.news.blueyonder.co.uk 1098541217 82.39.104.202 (Sat, 23 Oct 2004 15:20:17 BST) NNTP-Posting-Date: Sat, 23 Oct 2004 15:20:17 BST