Re: Help Required - Urgent

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.com>
Date: Sun, 18 May 2003 16:58:51 GMT
Message-ID: <fZOxa.20312$rt6.6679_at_sccrnsc02>


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
> Additional information: 3
> Sun May 18 10:34:22 2003
> Errors in file /export/home/oracle/admin/or817/bdump/or817_lgwr_16307.trc:
> 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
> Additional information: 3
> Sun May 18 10:34:22 2003
> LGWR: terminating instance due to error 313
> Instance terminated by LGWR, pid = 16307
> Sun May 18 10:40:35 2003
> Starting ORACLE instance (normal)
> Sun May 18 10:40:51 2003
> LICENSE_MAX_SESSION = 0
> LICENSE_SESSIONS_WARNING = 0
> LICENSE_MAX_USERS = 0
> Starting up ORACLE RDBMS Version: 8.1.7.3.0.
> System parameters with non-default values:
> processes = 1000
> timed_statistics = TRUE
> event = 10262 trace name context forever, level
 102400
> shared_pool_size = 150000000
> large_pool_size = 78643200
> java_pool_size = 33554432
> control_files = /home2/oracle/oradata/or817/control01.ctl,

 /home2/o

> racle/oradata/or817/control02.ctl,
 /home2/oracle/oradata/or817/control03.ctl
> db_block_buffers = 125000
> db_block_size = 8192
> db_block_lru_latches = 4
> compatible = 8.1.7
> log_buffer = 8192000
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> dml_locks = 1000
> rollback_segments = RBS0, RBS1, RBS2
> max_enabled_roles = 30
> O7_DICTIONARY_ACCESSIBILITY= FALSE
> remote_login_passwordfile= EXCLUSIVE
> instance_name = OR817
> service_names = or817
> sort_area_size = 524288
> sort_area_retained_size = 65536
> db_name = or817
> open_cursors = 4000
> os_authent_prefix =
> background_dump_dest = /export/home/oracle/admin/or817/bdump
> user_dump_dest = /export/home/oracle/admin/or817/udump
> max_dump_file_size = 10000
> core_dump_dest = /export/home/oracle/admin/or817/cdump
> oracle_trace_enable = TRUE
> PMON started with pid=2
> DBW0 started with pid=3
> LGWR started with pid=4
> CKPT started with pid=5
> SMON started with pid=6
> RECO started with pid=7
> Sun May 18 10:40:58 2003
> alter database mount
> Sun May 18 10:41:02 2003
> Successful mount of redo thread 1, with mount id 2452916606.
> Sun May 18 10:41:02 2003
> Database mounted in Exclusive Mode.
> Completed: alter database mount
> Sun May 18 10:41:02 2003
> alter database open
> Beginning crash recovery of 1 threads
> Sun May 18 10:41:03 2003
> Thread recovery: start rolling forward thread 1
> 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
Received on Sun May 18 2003 - 18:58:51 CEST

Original text of this message