Re: Help Required - Urgent

Thanks ... I am rebuilding the database as we speak ...

Frank <fvanbortel_at_netscape.net> wrote in message news:<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.
Received on Sun May 18 2003 - 23:33:39 CEST