Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: Database not opening,redo log problem.

    Hi all,

    m facing an acute problems related with redo log files.
    Actually through sql database is getting connected but after tht if i fire query (select * from tab) it shows errors tht database is not opened.

    errors i faced are following..
    ora-00312 online log 1 thread 1;e:\oracle\oradata\datacp\redoo01.lg
    ora-00316:log of thread 1, type 65535 in heaser is not log file
    pls help urgently.

    thx in advance,

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > it shows errors tht database is not opened.
    So open the Oracle database before you fire query thru sql database
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    Location
    Bangalore, INDIA.
    Posts
    3

    Smile DB in mount stage

    Hi,

    The Database will OPEN only when:
    Datafiles, Control files and Redo logs are in sync.

    Connection with Oracle database, is in MOUNT stage and not OPEN. That is why your query fails.

    As per the given error numbers I think, the online log is corrupted or is an old version.

    Suggestion:
    Find and install the correct version of the log or reset the logs. Please refer to the Oracle9i Database Administrator's Guide for recovery procedures.

    Hope it is of some help.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    A write on recovery practices is at

    http://otn.oracle.com/deploy/availab...R_Overview.htm
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •