MES数据库存储迁移Action_PROD(11)

Oracle RAC 迁移解决方案(存储迁移)

ALTER TABLESPACE TEMP ADD TEMPFILE '+ORADATA/cmeshis/tempfile/temp02.dbf' SIZE 4096M AUTOEXTEND OFF;

alter tablespace TEMP drop tempfile '+ORADATA1/cmeshis/tempfile/temp01.dbf'; alter tablespace TEMP drop tempfile '+ORADATA1/cmeshis/tempfile/temp02.dbf';

四、删除原Diskgroup

4.1删除DG

drop diskgroup ORADATA1 including contents;

drop diskgroup ARCHIVE1 including contents;

4.2修改ASM参数文件(两节点)

vi /oracle/product/10.2.0/db_1/dbs/init+ASM1.ora

asm_diskgroups='ORADATA','ARCHIVE'

五、验证集群服务、数据完整性

5.1验证集群服务

crs_stat –t

ps –ef |grep ora

tail –f *alert*.log

5.2验证数据完整性

Application check

Data check