[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

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
0
mjimison1956
Asked:
mjimison1956
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now