解决案例：ORA-00205: error in identifying control file, check alert log for more info

最新推荐文章于 2024-05-16 15:21:27 发布

qq_24353335

最新推荐文章于 2024-05-16 15:21:27 发布

阅读量4.6w

点赞数 1

本文链接：https://blog.csdn.net/qq_24353335/article/details/75125294

版权

问题：startup 数据库报错，内容ORA-00205: error in identifying control file, check alert log for more info

解决办法：
第一步：查看日志 cd $ORACLE_BASE/diag/rdbms/zdzrac/zdzrac1/trace; tail -200 alert_zdzrac1.log
注释：200代表显示200行

第二步：查找原因是alter system set control_files = '/disk1/control01.ctl', '/disk2/control02.ctl','/disk3/control03.ctl' scope=spfile;导致控制文件路径发生改变

第三步：在另一个正常的节点上查找原控制文件的路径
SQL> select status,name from v$controlfile;

STATUS NAME
--------------------------------------------------------------------------------
+DATA/zdzrac/controlfile/current.256.947408805

第四步：通过修改spfilec参数文件中的控制文件路径来解决
oracle# create pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0714.ora' from spfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/spfilezdzrac1.ora';
oracle# vi /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0714.ora

zdzrac2.__db_cache_size=2801795072
zdzrac1.__db_cache_size=2801795072
zdzrac2.__java_pool_size=16777216
zdzrac1.__java_pool_size=16777216
zdzrac2.__large_pool_size=33554432
zdzrac1.__large_pool_size=33554432
zdzrac1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
zdzrac2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
zdzrac2.__pga_aggregate_target=838860800
zdzrac1.__pga_aggregate_target=838860800
zdzrac2.__sga_target=3539992576
zdzrac1.__sga_target=3539992576
zdzrac2.__shared_io_pool_size=0
zdzrac1.__shared_io_pool_size=0
zdzrac2.__shared_pool_size=654311424
zdzrac1.__shared_pool_size=654311424
zdzrac2.__streams_pool_size=0
zdzrac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/zdzrac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/zdzrac/controlfile/current.256.947408805' //更改控制文件路径
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
"/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0714.ora" 44L, 1489C

第五步：利用pfile文件重启数据库
startup pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0711.ora';

第六步：通过修改后的pfile创建spfile文件
SQL> create spfile from pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/init0714.ora' ';

第七步：关闭数据库，启动数据库
SQL> shutdown immediate
SQL> startup