oracle 10.2.0.1
sles9 sp2
part of alter.log :
Errors in file /opt/oracle/admin/history/bdump/history_smon_6925.trc:
ORA-01115: Message 1115 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [3770]
ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [/opt/oracle/oradata/history/system01.dbf]
ORA-27091: Message 27091 not found; No message file for product=RDBMS,
facility=ORA
ORA-27072: Message 27072 not found; No message file for product=RDBMS,
facility=ORA
Linux Error: 5: Input/output error
Additional information: 4
Additional information: 3769
Additional information: -1
Fri Sep 1 16:14:00 2006
Waiting for Job queue slaves to complete
Fri Sep 1 16:14:00 2006
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Sep 1 16:14:04 2006
ALTER DATABASE CLOSE NORMAL
ORA-1115 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Sep 1 16:14:08 2006
Errors in file /opt/oracle/admin/history/bdump/history_smon_6925.trc:
ORA-01115: Message 1115 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [3770]
ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [1] [/opt/oracle/oradata/history/system01.dbf]
ORA-27091: Message 27091 not found; No message file for product=RDBMS,
facility=ORA
ORA-27072: Message 27072 not found; No message file for product=RDBMS,
facility=ORA
Linux Error: 5: Input/output error
Additional information: 4
Additional information: 3769
Additional information: -1
Fri Sep 1 16:21:23 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as
USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 402653184
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 50331648
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 2046820352
control_files = /opt/oracle/oradata/history/control01.ctl,
/opt/oracle/oradata1/history/control02.ctl,
/opt/oracle/oradata2/history/control03.ctl
db_block_size = 8192
__db_cache_size = 1543503872
compatible = 10.2.0.1.0
db_files = 65534
db_file_multiblock_read_count= 16
db_recovery_file_dest = /opt/oracle/flash_recovery_area
db_recovery_file_dest_size= 107374182400
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=historyXDB)
job_queue_processes = 10
background_dump_dest = /opt/oracle/admin/history/bdump
user_dump_dest = /opt/oracle/admin/history/udump
core_dump_dest = /opt/oracle/admin/history/cdump
audit_file_dest = /opt/oracle/admin/history/adump
sort_area_size = 1048576
db_name = history
open_cursors = 300
pga_aggregate_target = 679477248
Fri Sep 1 16:21:27 2006
WARNING:Oracle instance running on a system with low open file descriptor
limit. Tune your system to increase this limit to avoid
severe performance degradation.
PMON started with pid=2, OS id=6935
PSP0 started with pid=3, OS id=6937
MMAN started with pid=4, OS id=6939
DBW0 started with pid=5, OS id=6941
LGWR started with pid=6, OS id=6943
CKPT started with pid=7, OS id=6945
SMON started with pid=8, OS id=6947
RECO started with pid=9, OS id=6949
CJQ0 started with pid=10, OS id=6951
MMON started with pid=11, OS id=6953
Fri Sep 1 16:21:28 2006
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=6955
Fri Sep 1 16:21:28 2006
starting up 1 shared server(s) ...
Fri Sep 1 16:21:29 2006
ALTER DATABASE MOUNT
Fri Sep 1 16:21:34 2006
Setting recovery target incarnation to 2
Fri Sep 1 16:21:34 2006
Successful mount of redo thread 1, with mount id 228937929
Fri Sep 1 16:21:34 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Sep 1 16:21:34 2006
ALTER DATABASE OPEN
Fri Sep 1 16:22:43 2006
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Fri Sep 1 16:22:44 2006
Started redo scan
Fri Sep 1 16:22:44 2006
Errors in file /opt/oracle/admin/history/udump/history_ora_6961.trc:
ORA-00600: internal error code, arguments: [3005], [1], [2016], [34412],
[0], [0], [], []
Fri Sep 1 16:22:45 2006
Aborting crash recovery due to error 600
Fri Sep 1 16:22:45 2006
Errors in file /opt/oracle/admin/history/udump/history_ora_6961.trc:
ORA-00600: internal error code, arguments: [3005], [1], [2016], [34412],
[0], [0], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Fri Sep 1 16:30:37 2006
sos , i need to recover it .
i haven't backup. Database is archivelog mode , has a month's archivelog.
can anyone give me some suggestion?
_________________________________________________________________
???????????????????????????? MSN Messenger: http://messenger.msn.com/cn
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
