删除lv时，未删除lv上面的表空间问题解决

原创

丶stone 2012-11-22 18:42:38 ©著作权

文章标签 的文章 lv 文章分类 服务器

©著作权归作者所有：来自51CTO博客作者丶stone的原创作品，请联系作者获取转载授权，否则将追究法律责任

上篇文章写道删除lv，在最后启动RAC的时候实例无法启动，原因为 lv上面的表空间未删除，就把lv删了。

[root@cmsdb1]# ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    cmsdb1
ora.cmsdb1.gsd application    ONLINE    ONLINE    cmsdb1
ora.cmsdb1.ons application    ONLINE    ONLINE    cmsdb1
ora.cmsdb1.vip application    ONLINE    ONLINE    cmsdb1
ora....B2.lsnr application    ONLINE    ONLINE    cmsdb2
ora.cmsdb2.gsd application    ONLINE    ONLINE    cmsdb2
ora.cmsdb2.ons application    ONLINE    ONLINE    cmsdb2
ora.cmsdb2.vip application    ONLINE    ONLINE    cmsdb2
ora.ztjc.db    application    ONLINE    OFFLINE    cmsdb1
ora....c1.inst application    ONLINE    OFFLINE    cmsdb1
ora....c2.inst application    ONLINE   OFFLINE    cmsdb2

[oracle@cmsdb2]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Nov 21 19:29:36 2012

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size                  2068296 bytes
Variable Size             385876152 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14708736 bytes
Database mounted.
SQL> alter database open;

alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 22 - see DBWR trace file
ORA-01110: data file 22: '/dev/vgdata/rDevice_data_10g'

解决方案：

1.startup mount 挂载数据库

SQL> startup mount
ORACLE instance started.

2.确认是否为归档模式

归档模式：

SQL> alter database datafile /dev/vgdata/rDevice_data_10g offline;

Database altered.

非归档模式：

SQL> alter database datafile /dev/vgdata/rDevice_data_10g offline drop;

Database altered.

3.启动数据库

SQL> alter database open;