Re: Corrupt Control File Information

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Fri, 21 Apr 2006 12:33:55 -0700
Message-ID: <Hsa2g.11853$TK1.2253@fed1read06>

"aman.oracle.dba" <aman.oracle.dba_at_gmail.com> wrote in message news:1145647791.508053.253860_at_i39g2000cwa.googlegroups.com...
> Hi DBAs,
> I am working on 24 X 7 database.
> I have 3 control files in database if one is currupted then where can I
> see this problem.
> even if u delete all of them still database is working but cannot
> shutdown. Pls tell me where can I find corrupt control file
> information.
>
> thank you in Advance
>

Ahm... You deleted all your control files?!?!?!

(Trying to contain my laughter)

Have you ever heard of the alert log?

Do you know where all your datafiles are? You'll have to recreate your control file. Good luck!

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup

Received on Fri Apr 21 2006 - 14:33:55 CDT