ORA-01200: actual file size of 51199 is smaller than correct size of ..

         DBCA  建库之后成功 ， 但是最后在点击OK按钮结束的时候， 报一个错误：   大概意思是实例2 没有正常启动， 查看一下状态发现其他状态都是ok的  ： 


rac01$crs_stat -t 
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac02      
ora....l1.inst application    ONLINE    ONLINE    rac01      
ora....l2.inst application    ONLINE    OFFLINE              
ora....01.lsnr application    ONLINE    ONLINE    rac01      
ora.rac01.gsd  application    ONLINE    ONLINE    rac01      
ora.rac01.ons  application    ONLINE    ONLINE    rac01      
ora.rac01.vip  application    ONLINE    ONLINE    rac01      
ora....02.lsnr application    ONLINE    ONLINE    rac02      
ora.rac02.gsd  application    ONLINE    ONLINE    rac02      
ora.rac02.ons  application    ONLINE    ONLINE    rac02      
ora.rac02.vip  application    ONLINE    ONLINE    rac02      





查看节点2 的alert log 文件， 发现问题点， 还是文件大小的问题 ： 

Fri Oct 28 08:16:19 2011
Setting recovery target incarnation to 1
Fri Oct 28 08:16:19 2011
Successful mount of redo thread 2, with mount id 1293466850
Fri Oct 28 08:16:19 2011
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Completed: ALTER DATABASE   MOUNT
Fri Oct 28 08:16:21 2011
ALTER DATABASE OPEN
Picked broadcast on commit scheme to generate SCNs
Fri Oct 28 08:16:21 2011
Errors in file /u01/app/admin/orcl/bdump/orcl2_dbw0_30631.trc:
ORA-01186: file 1 failed verification tests
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/product/oradata/orcl/system01.dbf'
ORA-01200: actual file size of 51199 is smaller than correct size of 70400 blocks
Fri Oct 28 08:16:21 2011
File 1 not verified due to error ORA-01122
Fri Oct 28 08:16:21 2011
Errors in file /u01/app/admin/orcl/bdump/orcl2_dbw0_30631.trc:
ORA-01186: file 3 failed verification tests
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: '/u01/product/oradata/orcl/sysaux01.dbf'
ORA-01200: actual file size of 38399 is smaller than correct size of 57600 blocks
File 3 not verified due to error ORA-01122
Fri Oct 28 08:16:21 2011
ORA-1187 signalled during: ALTER DATABASE OPEN...
rac02$
rac02$ lvscan
  /etc/lvm/.cache: open failed: Permission denied
  Attempt to close device '/etc/lvm/.cache' which is not open.
  No volume groups found
rac02$



这里通过 lvresize 增加lv的大小，

[root@rac01 ~]# lvresize -L +200M   /dev/datavg01/system01.dbf
  Extending logical volume system01.dbf to 800.00 MB
  Logical volume system01.dbf successfully resized
[root@rac01 ~]# lvresize -L +300M  /dev/datavg01/sysaux01.dbf
  Extending logical volume sysaux01.dbf to 800.00 MB
  Logical volume sysaux01.dbf successfully resized 


查看lv大小变化及状态：
[root@rac02 raw]# lvscan
  ACTIVE            '/dev/datavg01/ocr.dbf' [20.00 MB] inherit
  ACTIVE            '/dev/datavg01/votingdisk' [20.00 MB] inherit
  ACTIVE            '/dev/datavg01/system01.dbf' [800.00 MB] inherit
  ACTIVE            '/dev/datavg01/sysaux01.dbf' [800.00 MB] inherit
  ACTIVE            '/dev/datavg01/users01.dbf' [12.00 MB] inherit
  ACTIVE            '/dev/datavg01/undotbs01.dbf' [200.00 MB] inherit
  ACTIVE            '/dev/datavg01/temp01.dbf' [200.00 MB] inherit
  ACTIVE            '/dev/datavg01/spfileorcl.ora' [12.00 MB] inherit
  ACTIVE            '/dev/datavg01/control01.ctl' [32.00 MB] inherit
  ACTIVE            '/dev/datavg01/control02.ctl' [32.00 MB] inherit
  ACTIVE            '/dev/datavg01/control03.ctl' [32.00 MB] inherit
  ACTIVE            '/dev/datavg01/redo01.log' [20.00 MB] inherit
  ACTIVE            '/dev/datavg01/redo02.log' [20.00 MB] inherit
  ACTIVE            '/dev/datavg01/redo03.log' [20.00 MB] inherit
  ACTIVE            '/dev/datavg01/ocr2.dbf' [120.00 MB] inherit
  ACTIVE            '/dev/datavg01/votingdisk2' [120.00 MB] inherit



之后在每个节点上查看状态， 发现状态都是online .    

rac01$crs_stat -t 
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac02      
ora....l1.inst application    ONLINE    ONLINE    rac01      
ora....l2.inst application    ONLINE    ONLINE    rac02      
ora....01.lsnr application    ONLINE    ONLINE    rac01      
ora.rac01.gsd  application    ONLINE    ONLINE    rac01      
ora.rac01.ons  application    ONLINE    ONLINE    rac01      
ora.rac01.vip  application    ONLINE    ONLINE    rac01      
ora....02.lsnr application    ONLINE    ONLINE    rac02      
ora.rac02.gsd  application    ONLINE    ONLINE    rac02      
ora.rac02.ons  application    ONLINE    ONLINE    rac02      
ora.rac02.vip  application    ONLINE    ONLINE    rac02      

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-709820/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-709820/