DATA BASE will not open HELLLLLP!

I am getting this error.  The logfiles in question has the "CURRENT" logfile.  I tried to open by resetting logs and tried to force a checkpoint.  I continue to get the error below.  

ORACLE instance started.

Total System Global Area 7348420608 bytes
Fixed Size                  2082528 bytes
Variable Size            1358956832 bytes
Database Buffers         5972688896 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_7.log'
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_8.log'
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_9.log'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
mjimison1956Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
Check the alert log for additional errors.  Both of these Oracle errors reference other errors.

Are there other members of the group that are not getting the error?

Multiplexing the redo logs on the same file system tends to defeat the purpose.
0
adrian_angCommented:
Do the files from log group 3  exist in /oracle/redo/investt7/ ?
Are there any errors in the alert log file?

If it's not a critical database and data loss is acceptable , then you can clear the problematic redo logs using:

ALTER DATABASE CLEAR LOGFILE GROUP 3;










0
mjimison1956Author Commented:
This is interesting ...  I get this error, but when I look in the file system I see the log files on the linux server.  By the way this is vesion 10.2.0.2.

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;
ALTER DATABASE CLEAR LOGFILE GROUP 3
*
ERROR at line 1:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_9.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_8.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 1: '/oracle/redo/investt7/redo6_7.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

adrian_angCommented:
Descriptions of different scenarios are here:

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen008.htm

Make sure that after your actions you can always be at the starting point(with the problem), make a backup of the broken database before you proceed with restore or any other activity.





0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsoneSenior Oracle DBACommented:
Did you look at the size of the files?

Do this:

ls -l /oracle/redo/investt7/redo6_9.log /oracle/redo/investt7/redo6_8.log /oracle/redo/investt7/redo6_7.log

I'm wondering if they are symbolic links and the targets of the links have been deleted.
0
schwertnerCommented:
You have to log as 'root" user and
do
% chown oracle  /oracle      +R

Possibly you have added some subdirectories to this
directory and have lost access right.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.