请教：

xuejun74

启动数库时显示：
Total System Global Area  138412032 bytes
Fixed Size                  1218124 bytes
Variable Size              79694260 bytes
Database Buffers           50331648 bytes
Redo Buffers                7168000 bytes
ORA-00205: error in identifying control file, check alert log for more info

日文件里：
ORA-00202: control file: '/home/oracle/ora10/product/10.1.10/db_1/dbs/cntrlzxj_data.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

但cntrlzxj_data.dbf这个文件没有

请问怎么解决？

sinopec_付强

ORA-00202
这个错误应该是控制文件出了问题。

xuejun74

home/oracle/ora10/product/10.1.10/db_1/dbs/cntrlzxj_data.dbf
它要找的这个文件不存在。

sinopec_付强

看一下你的spfile是否正常。

xuejun74

spfilezxjdata.ora,这个文件吗？

sinopec_付强

查看一下内容。

xuejun74

6.zxjdata.__db_cache_size=398458880
zxjdata.__java_pool_size=4194304
zxjdata.__large_pool_size=4194304
zxjdata.__shared_pool_size=150994944
zxjdata.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/zxj_data/adump'
*.background_dump_dest='/opt/oracle/admin/zxj_data/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/zxj_data/control01.ctl','/opt/oracle/oradata/zxj_data/control02.ctl','/opt/oracle/oradata/zxj_data/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/zxj_data/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='zxj_data'
*.db_recovery_file_dest='/home/oracle/ora10/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=zxjdataXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=187695104
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=563085312
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/zxj_data/udump'

sinopec_付强

再查看一下controlfile的内容

xuejun74

[oracle@localhost dbs]$ cat initzxj_data.ora
large_pool_size=4194304
shared_pool_size=48265318
core_dump_dest='/opt/zxj_data/admin/zxj_data/cdump'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='zxj_data'
db_recovery_file_dest='/home/oracle/ora10/flash_recovery_area'
db_recovery_file_dest_size=2147483648
dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=12777216
processes=150
undo_management='auto'
undo_tablespace='undotbs1'
user_dump_dest='/opt/oracle/admin/zxj_data/udump'
NLS_DATE_FORMAT="Mon DD YYYY HH24:MI:SS"
NLS_DATE_LANGUAGE=AMERICAN

是这个文件吗？

renxiao2003

看看文件在不在啊。