安装好oracle rac个各种组件后,使用的是裸设备。创建数据库,报错,其中一个实例不能启动,crs_stat -t检查,如下图:
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
ora.test.db application ONLINE ONLINE rac2
ora....t1.inst application ONLINE ONLINE rac1
ora....t2.inst application ONLINE OFFLINE
手工启动这个实例,crs_start ora.test.test2.inst, 同样报错:
rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2
CRS-0215: Could not start resource 'ora.test.test2.inst'.
检查这个实例对应的alert日志,发现如下错误:
。。。
Errors in file /oracle/ora10g/admin/test/bdump/test2_smon_2225.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4585)
ORA-01110: data file 1: '/oracle/ora10g/oradata/system01.dbf'
Thu Oct 28 11:19:35 2010
Errors in file /oracle/ora10g/admin/test/bdump/test2_smon_2225.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4585)
ORA-01110: data file 1: '/oracle/ora10g/oradata/system01.dbf'
Thu Oct 28 11:19:45 2010
Errors in file /oracle/ora10g/admin/test/bdump/test2_smon_2225.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 4585)
ORA-01110: data file 1: '/oracle/ora10g/oradata/system01.dbf'
。。。。
想要用sqlplus的方式启动这个实例,然后恢复一下,可是设置了 set ORACLE_SID=test2
sqlplus sys/oracle@test2 as sysdba 后:
报如下错误:
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor
tnsping test2是可以ping通的,请各位大侠指点,搞了好久了,急!!!!
谢谢各位!!!1