Database conncted but not opening.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database conncted but not opening.

  1. #1
    Join Date
    Jul 2004
    Location
    india
    Posts
    13

    Database conncted but not opening.

    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
    Nov 2000
    Location
    Israel
    Posts
    268
    As you can read from the error message, one of the redp logs files is corrupt and when oracle tries to read it it says that judging by its header, it is not log file.

    What you can do is 2 things:
    1. if you have multiplexed redo log files, simply shutdown the database, copy one of the members in the same redo log group on to the corrupt file and open the database.
    2. restore the file from backup and recover the database.


    Good Luck.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Re: Database conncted but not opening.

    Originally posted by secureall

    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,
    Try shutdown the db.
    rename the redolog file according to your naming convention:
    maybe from: e:\oracle\oradata\datacp\redoo01.lg
    to : e:\oracle\oradata\datacp\redo01.log

    then bring the db up.

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Secureall,
    Remember you were having problems with your redo logs last week? Did you ever go to Metalink to research your problem?

    We're all happy to help people in need but try to do some research before you blindly start posting threads. thanks!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

Posting Permissions

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


Click Here to Expand Forum to Full Width