Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't open database - Newbie

Re: Can't open database - Newbie

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 28 May 1999 21:19:27 -0400
Message-ID: <LmH33.2897$J3.103841@news15.ispnews.com>


Actually, if you want to be able to recover without data loss you should be running in archivelog mode.

farrellyr_at_my-deja.com wrote in message <7imd9u$nas$1_at_nnrp1.deja.com>...
>Thanks Barry, but we ended up restoring from our old backups. We didn't
>actually lose much information. Which is good. I didn't try to rebuild
>the control files, if something similar happens again I'll keep that
>option in mind. Anyway, things turned not to bad. Thanks again.
>
>In article <01bea895$3dc581a0$3af893cb_at_dba>,
> "Barry" <odbc_at_mailexcite.com> wrote:
>> ...... seems strange, I have'nt seen an ORA-00600 before but from the
>> what you describe, it is likely your control files could be corupted
>> because
>> the wrong init.ora was used. Have you tried rebuilding them ?
>>
>> farrellyr_at_my-deja.com wrote in article
><7ik95a$7jh$1_at_nnrp1.deja.com>...
>> > We are having a problem opening our database. Keep getting error
>ora-
>> > 00600. We have 2 databases running on the same server (NT4-SP4 -
>> > Oracle7.3), and we started our test database without specifying
>which
>> > init.ora file to use, and it used the same file as our production
>> > database.
>> SNIP
>> >
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Share what you know. Learn what you don't.
>> >
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri May 28 1999 - 20:19:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US