-
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,
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|