oracle ORA-00205和09968故障的处理

数据迁移重新部署，在新系统中导入旧系统数据后，oracle系统不能正常startup,依次出现00205和09968故障，环境是centos4.6,oracle 9208,处理如下:

 

1 查看ORACLE_SID是不是一样

2 查看log日志
  find /soft/ora9 -name '*.log' -ls
  cat /soft/ora9/product/9.2/rdbms/log/alert_oracle.log
  cat /soft/ora9/admin/oracle/bdump/alert_oracle.log

  ORA-00202: controlfile: 'ora_control1'
  ORA-27037: unable to obtain file status
  Linux Error: 2: No such file or directory
  Additional information: 3
  Fri May 23 21:39:28 2008
  ORA-205 signalled during: ALTER DATABASE   MOUNT...

 

3 找一个正确的pfile，修改使其不用坏的controlfile: 'ora_control1'后，以该正确的pfile启动，
  startup pfile='/soft/ora9/admin/oracle/pfile/init.ora.423200815338'
  shutdown后删除不正常的spfile，
  cd /soft/ora9/product/9.2/dbs/
  mv spfileoracle.ora spfileoracle.ora.bak
  create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.423200815338'；

4 再启动oracle出现ORA-01102: cannot mount database in EXCLUSIVE mode
  查看其log,发现：
  scumnt: failed to lock /soft/ora9/product/9.2/dbs/lkORACLE exclusive
  Fri May 23 22:28:46 2008
  ORA-09968: scumnt: unable to lock file
  Linux Error: 11: Resource temporarily unavailable
  Additional information: 29627
  Fri May 23 22:28:46 2008
  ORA-1102 signalled during: ALTER DATABASE   MOUNT...

处理方法：
  fuser -u /soft/ora9/product/9.2/dbs/lkORACLE
  fuser -k /soft/ora9/product/9.2/dbs/lkORACLE
  fuser -u /soft/ora9/product/9.2/dbs/lkORACLE

5 shutdown;su - oracle -c "lsnrctl start"
  startup ok;测试：alter user system identified by 121qaz2k;
 
6 建立备份pfile
create pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524' from spfile;
create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524';

7 修改其配置，再次建立controlfile中已经坏的file1,
  删除坏的controlfile1: rm -rf /soft/ora9/oradata/oracle/control01.ctl
  修改/soft/ora9/admin/oracle/pfile/init.ora.20080524，

  增加/soft/ora9/oradata/oracle/control01.ctl后存为
  /soft/ora9/admin/oracle/pfile/init.ora.20080524h
  关闭db b,

cp /soft/ora9/oradata/oracle/control02.ctl /soft/ora9/oradata/oracle/control01.ctl
  以新的pfile启动db:

  startup pfile="/soft/ora9/admin/oracle/pfile/init.ora.20080524h"
  再次建立spfile
  create spfile='/soft/ora9/product/9.2/dbs/spfileoracle.ora' from pfile='/soft/ora9/admin/oracle/pfile/init.ora.20080524h';
  关闭db后重启动db,测试ok