asked on

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

johnsone

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.

adrian_ang

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;

mjimison1956

ASKER

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

ASKER CERTIFIED SOLUTION

adrian_ang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johnsone

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.

schwertner

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.