- 论坛徽章:
- 0
|
我的数据库启动报错了，ORA-00205
启动时是这样的：
SQL> startup
ORACLE instance started.
Total System Global Area 4211081216 bytes
Fixed Size 2076592 bytes
Variable Size 973078608 bytes
Database Buffers 3221225472 bytes
Redo Buffers 14700544 bytes
ORA-00205: error in identifying control file, check alert log for more info
alert log是这样的：
Thu Nov 12 15:04:00 2009
alter database open
Thu Nov 12 15:04:00 2009
ORA-1507 signalled during: alter database open
...
Thu Nov 12 15:04:11 2009
Starting ORACLE instance (normal)
Thu Nov 12 15:04:29 2009
Shutting down instance: further logons disabled
Thu Nov 12 15:04:29 2009
Stopping background process CJQ0
Thu Nov 12 15:04:29 2009
Stopping background process MMNL
Thu Nov 12 15:04:31 2009
Stopping background process MMON
Thu Nov 12 15:04:32 2009
Shutting down instance (normal)
License high water mark = 1
Thu Nov 12 15:04:32 2009
Stopping Job queue slave processes
Thu Nov 12 15:04:32 2009
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Nov 12 15:04:34 2009
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Nov 12 15:05:12 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =97
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.2.0.
System parameters with non-default values:
processes = 800
sessions = 885
shared_pool_size = 536870912
large_pool_size = 218103808
java_pool_size = 218103808
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
control_files = /dev/rdy_ctl1_110m, /dev/rdy_ctl2_110m
db_block_size = 8192
db_cache_size = 3221225472
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/oradata/arch1
log_archive_dest_2 = LOCATION=/oradata/arch2
log_archive_dest_state_1 = DEFER
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
thread = 1
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=dyoraXDB)
job_queue_processes = 10
cursor_sharing = SIMILAR
background_dump_dest = /opt/app/admin/dyora/bdump
user_dump_dest = /opt/app/admin/dyora/udump
core_dump_dest = /opt/app/admin/dyora/cdump
audit_file_dest = /opt/app/admin/dyora/adump
db_name = dyora
open_cursors = 300
pga_aggregate_target = 536870912
PMON started with pid=2, OS id=1286156
PSP0 started with pid=3, OS id=1277986
MMAN started with pid=4, OS id=1024108
DBW0 started with pid=5, OS id=978970
LGWR started with pid=6, OS id=389164
CKPT started with pid=7, OS id=598218
SMON started with pid=8, OS id=585918
RECO started with pid=9, OS id=1417274
CJQ0 started with pid=10, OS id=897126
MMON started with pid=11, OS id=553148
Thu Nov 12 15:05:13 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=462964
Thu Nov 12 15:05:13 2009
starting up 1 shared server(s) ...
Thu Nov 12 15:05:13 2009
ALTER DATABASE MOUNT
Thu Nov 12 15:05:13 2009
ORA-00202: Message 202 not found; No message file for product=RDBMS, facility=ORA; arguments: [/dev/rdy_ctl1_110m]
ORA-27086: Message 27086 not found; No message file for product=RDBMS, facility=ORA
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 8
Additional information: 594072
Thu Nov 12 15:05:13 2009
ORA-205 signalled during: ALTER DATABASE MOUT。。。
应该是控制文件出现问题了，但具体怎么把它搞好啊？？？ |
|
免费注册
发表于 2009-11-19 10:31
发表于 2009-11-22 19:49