Help Required - Urgent
From: OraNew <harinder.soin_at_sungard.com>
Date: 18 May 2003 09:50:18 -0700
Message-ID: <abce6ce7.0305180850.4e3fb2e1_at_posting.google.com>
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:
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
Starting up ORACLE RDBMS Version: 8.1.7.3.0. System parameters with non-default values:
O7_DICTIONARY_ACCESSIBILITY= FALSE
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:50:18 CEST
Date: 18 May 2003 09:50:18 -0700
Message-ID: <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:50:18 CEST