Printable View
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.
Try shutdown the db.Quote:
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,
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!