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,
Re: Database conncted but not opening.
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,
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.