apras_ckpt_5086.trc
/home/apras/orabase/admin/apras/bdump/apras_ckpt_5086.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /home/apras/orabase/ora92
System name:
HP-UX
Node name:
app2
Release:
B.11.11
Version:
U
Machine:
9000/800
Instance name: apras
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 5086, image: oracle@app2 (CKPT)
*** 2007-07-05 14:05:35.055
*** SESSION ID
4.1) 2007-07-05 14:05:35.048
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01110: data file 11: '/user01/oradata/apras/APRAS01.dbf'
ORA-01115: IO error reading block from file 11 (block # 1)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 22: Invalid argument
Additional information: 1
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01110: data file 11: '/user01/oradata/apras/APRAS01.dbf'
ORA-01115: IO error reading block from file 11 (block # 1)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 22: Invalid argument
Additional information: 1
alert_apras.log
Thread 1 advanced to log sequence 334
Current log# 3 seq# 334 mem# 0: /home/apras/orabase/oradata/apras/redo03.log
Wed Jul4 05:36:00 2007
Thread 1 advanced to log sequence 335
Current log# 1 seq# 335 mem# 0: /home/apras/orabase/oradata/apras/redo01.log
Wed Jul4 08:39:51 2007
Errors in file /home/apras/orabase/admin/apras/bdump/apras_ora_401.trc:
ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []
Wed Jul4 09:01:59 2007
drop tablespace aprastts37 including contents and datafiles
Wed Jul4 09:02:06 2007
Deleted file /user01/test/APRASTTS37.dbf
Completed: drop tablespace aprastts37 including contents and
Wed Jul4 16:09:27 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Wed Jul4 16:10:07 2007
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 167772160
sga_max_size
= 19329438160
large_pool_size
= 117440512
java_pool_size = 33554432
control_files
= /home/apras/orabase/oradata/apras/control01.ctl, /home/apras/orabase/oradata/apras/control02.ctl, /home/apras/orabase/oradata/apras/control03.ctl
db_block_size
= 8192
db_keep_cache_size = 1073741824
db_16k_cache_size= 0
db_32k_cache_size= 0
db_cache_size
= 10737418240
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 128
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= apras
dispatchers
= (PROTOCOL=TCP) (SERVICE=aprasXDB)
job_queue_processes= 10
parallel_max_servers = 16
hash_join_enabled= TRUE
hash_area_size = 524288000
background_dump_dest = /home/apras/orabase/admin/apras/bdump
user_dump_dest = /home/apras/orabase/admin/apras/udump
core_dump_dest = /home/apras/orabase/admin/apras/cdump
sort_area_size = 524288
db_name
= apras
open_cursors
= 300
star_transformation_enabled= FALSE
parallel_automatic_tuning= TRUE
query_rewrite_enabled= FALSE
pga_aggregate_target = 4294967296
aq_tm_processes
= 1
PMON started with pid=2, OS id=5080
DBW0 started with pid=3, OS id=5082
LGWR started with pid=4, OS id=5084
CKPT started with pid=5, OS id=5086
SMON started with pid=6, OS id=5088
RECO started with pid=7, OS id=5090
CJQ0 started with pid=8, OS id=5092
QMN0 started with pid=9, OS id=5094
Wed Jul4 16:10:07 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul4 16:10:08 2007
ALTER DATABASE MOUNT
Wed Jul4 16:10:12 2007
Successful mount of redo thread 1, with mount id 936091296
Wed Jul4 16:10:12 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Jul4 16:10:12 2007
ALTER DATABASE OPEN
Wed Jul4 16:10:15 2007
Beginning crash recovery of 1 threads
Wed Jul4 16:10:15 2007
Started redo scan
Wed Jul4 16:10:15 2007
Completed redo scan
1837 redo blocks read, 75 data blocks need recovery
Wed Jul4 16:10:15 2007
Started recovery at
Thread 1: logseq 335, block 45635, scn 0.0
Wed Jul4 16:10:15 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 335 Reading mem 0
Mem# 0 errs 0: /home/apras/orabase/oradata/apras/redo01.log
Wed Jul4 16:10:15 2007
Completed redo application
Wed Jul4 16:10:15 2007
Ended recovery at
Thread 1: logseq 335, block 47472, scn 0.4515454
75 data blocks read, 75 data blocks written, 1837 redo blocks read
Crash recovery completed successfully
Wed Jul4 16:10:16 2007
Thread 1 advanced to log sequence 336
Thread 1 opened at log sequence 336
Current log# 2 seq# 336 mem# 0: /home/apras/orabase/oradata/apras/redo02.log
Successful open of redo thread 1
Wed Jul4 16:10:16 2007
SMON: enabling cache recovery
Wed Jul4 16:10:16 2007
Successfully onlined Undo Tablespace 1.
Wed Jul4 16:10:16 2007
SMON: enabling tx recovery
Wed Jul4 16:10:16 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Wed Jul4 16:11:09 2007
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=5109
Wed Jul4 16:35:36 2007
Starting ORACLE instance (normal)
Thu Jul5 09:02:42 2007
Thread 1 advanced to log sequence 337
Current log# 3 seq# 337 mem# 0: /home/apras/orabase/oradata/apras/redo03.log
Thu Jul5 13:35:17 2007
Thread 1 advanced to log sequence 338
Current log# 1 seq# 338 mem# 0: /home/apras/orabase/oradata/apras/redo01.log
Thu Jul5 14:05:35 2007
Errors in file /home/apras/orabase/admin/apras/bdump/apras_ckpt_5086.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01110: data file 11: '/user01/oradata/apras/APRAS01.dbf'
ORA-01115: IO error reading block from file 11 (block # 1)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 22: Invalid argument
Additional information: 1
Thu Jul5 14:05:35 2007
Errors in file /home/apras/orabase/admin/apras/bdump/apras_ckpt_5086.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01110: data file 11: '/user01/oradata/apras/APRAS01.dbf'
ORA-01115: IO error reading block from file 11 (block # 1)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 22: Invalid argument
Additional information: 1
Thu Jul5 14:05:35 2007
CKPT: terminating instance due to error 1242
Instance terminated by CKPT, pid = 5086
Fri Jul6 09:36:52 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 1
Fri Jul6 09:37:25 2007
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 167772160
sga_max_size
= 19329438160
large_pool_size
= 117440512
java_pool_size = 33554432
control_files
= /home/apras/orabase/oradata/apras/control01.ctl, /home/apras/orabase/oradata/apras/control02.ctl, /home/apras/orabase/oradata/apras/control03.ctl
db_block_size
= 8192
db_keep_cache_size = 1073741824
db_16k_cache_size= 0
db_32k_cache_size= 0
db_cache_size
= 10737418240
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 128
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= apras
dispatchers
= (PROTOCOL=TCP) (SERVICE=aprasXDB)
job_queue_processes= 10
parallel_max_servers = 16
hash_join_enabled= TRUE
hash_area_size = 524288000
background_dump_dest = /home/apras/orabase/admin/apras/bdump
user_dump_dest = /home/apras/orabase/admin/apras/udump
core_dump_dest = /home/apras/orabase/admin/apras/cdump
sort_area_size = 524288
db_name
= apras
open_cursors
= 300
star_transformation_enabled= FALSE
parallel_automatic_tuning= TRUE
query_rewrite_enabled= FALSE
pga_aggregate_target = 4294967296
aq_tm_processes
= 1
PMON started with pid=2, OS id=14850
DBW0 started with pid=3, OS id=14852
LGWR started with pid=4, OS id=14854
CKPT started with pid=5, OS id=14856
SMON started with pid=6, OS id=14858
RECO started with pid=7, OS id=14860
CJQ0 started with pid=8, OS id=14862
QMN0 started with pid=9, OS id=14864
Fri Jul6 09:37:26 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jul6 09:37:26 2007
ALTER DATABASE MOUNT
Fri Jul6 09:37:30 2007
Successful mount of redo thread 1, with mount id 936225686
Fri Jul6 09:37:30 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jul6 09:37:30 2007
ALTER DATABASE OPEN
ORA-1110 signalled during: ALTER DATABASE OPEN...
Fri Jul6 09:43:29 2007
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=14896
Fri Jul6 09:49:32 2007
Restarting dead background process QMN0
QMN0 started with pid=9, OS id=14921
|