逻辑卷出现大量坏块，如何处理

时间：2010-06-08 来源：drew

同事加了/dev/raw/raw155逻辑卷，随后发现出现大量坏块。具体处理过程如下： 1.exp 做备份 2. 迁移数据，到TBS_BI_ODS07 alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100524      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100525      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100526      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100527      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100528      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100529      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100530      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100531      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100601      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100602      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100603      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100604      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100605      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100606      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100607      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100524      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100525      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100526      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100527      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100528      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100529      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100530      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100531      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100601      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100602      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100603      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100604      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100605      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100606      move tablespace tbs_bi_ods07;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100607      move tablespace tbs_bi_ods07;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100603_L12 move tablespace tbs_bi_ods07;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100604_L12 move tablespace tbs_bi_ods07;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100605_L12 move tablespace tbs_bi_ods07;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100606_L12 move tablespace tbs_bi_ods07;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100607_L12 move tablespace tbs_bi_ods07;
3.检测 select * from dba_extents where file=86 视图是否还存在对象，如果不存在，进行下一步，对数据文件进行删除。 4.alter tablespace TBS_BI_ODS09 drop datafile 86;
5.再进行操作，进行回迁。 alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100524      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100525      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100526      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100527      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100528      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100529      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100530      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100531      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100601      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100602      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100603      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100604      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100605      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100606      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_DT      partition   P20100607      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100524      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100525      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100526      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100527      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100528      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100529      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100530      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100531      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100601      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100602      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100603      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100604      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100605      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100606      move tablespace tbs_bi_ods09;
alter table statuser.DM_SVC_BIZ_CHANNEL_UA_DT    partition   P20100607      move tablespace tbs_bi_ods09;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100603_L12 move tablespace tbs_bi_ods09;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100604_L12 move tablespace tbs_bi_ods09;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100605_L12 move tablespace tbs_bi_ods09;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100606_L12 move tablespace tbs_bi_ods09;
alter table statuser.ODS_HTTP_ACCESS_LOG        partition   P20100607_L12 move tablespace tbs_bi_ods09;
6.对ODS_HTTP_ACCESS_LOG,DM_SVC_BIZ_CHANNEL_UA_DT,DM_SVC_BIZ_CHANNEL_DT上的索引，进行检查