Re: Help Required - Urgent

From: Frank <fvanbortel_at_netscape.net>
Date: Sun, 18 May 2003 20:18:41 +0200
Message-ID: <3EC7CE81.20309_at_netscape.net>

Jim Kennedy wrote:

> call support
> "OraNew" <harinder.soin_at_sungard.com> wrote in message
> news:abce6ce7.0305180850.4e3fb2e1_at_posting.google.com...
> 

>>All,
>>I cannot bring my database back up when it went down with the following

> 
> error
> 

>>ORA-00313: open failed for members of log group 6 of thread 1
>>ORA-00312: online log 6 thread 1:

> 
> '/home2/oracle/oradata/or817/or817_log_6.ora'
> 

>>ORA-27037: unable to obtain file status
>>SVR4 Error: 2: No such file or directory
<snip!>

>>Recovery of Online Redo Log: Thread 1 Group 4 Seq 22217 Reading mem 0
>> Mem# 0 errs 0: /home2/oracle/oradata/or817/OR817_log_4.ora
>>Sun May 18 10:41:04 2003
>>Thread recovery: finish rolling forward thread 1
>>Thread recovery: 0 data blocks read, 0 data blocks written, 0 redo blocks

> 
> read
> 

>>Crash recovery completed successfully
>>Sun May 18 10:41:04 2003
>>Thread 1 advanced to log sequence 22218
>>Thread 1 opened at log sequence 22218
>> Current log# 6 seq# 22218 mem# 0:

> 
> /home2/oracle/oradata/or817/or817_log_6.ora
> 

>>Successful open of redo thread 1.
>>Sun May 18 10:41:05 2003
>>SMON: enabling cache recovery
>>SMON: enabling tx recovery
>>Sun May 18 10:41:10 2003
>>Errors in file /export/home/oracle/admin/or817/bdump/or817_p001_16507.trc:
>>ORA-07445: exception encountered: core dump [0000000100362F58] [SIGSEGV]

> 
> [Addres
> 

>>s not mapped to object] [1481000478] [] []
>>Sun May 18 10:41:12 2003
>>Errors in file /export/home/oracle/admin/or817/bdump/or817_p002_16509.trc:
>>ORA-07445: exception encountered: core dump [0000000100362F58] [SIGSEGV]

> 
> [Addres
> 

>>s not mapped to object] [1481002662] [] []
>>Sun May 18 10:41:16 2003
>>Errors in file /export/home/oracle/admin/or817/bdump/or817_p004_16513.trc:
>>ORA-07445: exception encountered: core dump [0000000100362F58] [SIGSEGV]

> 
> [Addres
> 

>>s not mapped to object] [1481005073] [] []
>>Sun May 18 10:41:16 2003
>>Errors in file /export/home/oracle/admin/or817/bdump/or817_p003_16511.trc:
>>ORA-07445: exception encountered: core dump [0000000100362F58] [SIGBUS]

> 
> [Invalid
> 

>> address alignment] [1053268869] [] []
>>Sun May 18 10:41:42 2003

> 
> 
> 

Take a backup - NOW!

And then (AFTER the -preferably cold- backup) try an incomplete recovery.
Why? Because you had troubles with the file /home2/oracle/oradata/or817/or817_log_6.ora.

This very file is used by the recovery process; it may have wrong info. Hence the shot to try an incomplete recovery, where log_6 is not used.

-- 
Regards, Frank van Bortel

Received on Sun May 18 2003 - 20:18:41 CEST