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

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

SQL> shutdown immediate

SQL> startup nomount

restore controlfile to '+ORADATA/cmeshis/controlfile/control01.ctl'

'ORADATA1/ cmeshis/controlfile/control01.ctl';

3.4.3ASM中查看Controlfile文件名称(两数据库单独查看)

ASMCMD> ls

3.4.4修改参数文件中控制文件位置为新文件、Mount数据库

DataBase cmesrel alter system

control_files='+ORADATA/cmesrel/controlfile/current.271.8654424'

RMAN> alter database mount;

DataBase cmeshis alter system

control_files='+ORADATA/cmeshis/controlfile/current.271.8654424'

RMAN> alter database mount; from set set

3.4.5更改Datafile名称 DataBase cmesrel(黄色底纹部分，待最终确认修改)

alter database rename file '+ORADATA1/cmesrel/datafile/system.262.858768375'

to '+ORADATA/cmesrel/datafile/system.262.858768375';

…(详见MES_Prod_Storage切换His.txt)

…

alter database rename file '+ORADATA1/cmesrel/datafile/mes_dt34.dbf' to

'+ORADATA/cmesrel/datafile/mes_dt34.dbf';

DataBase cmeshis(黄色底纹部分，待最终确认修改)

alter database rename file '+ORADATA1/cmeshis/datafile/mes_dt200.dbf' to

'+ORADATA/cmesrel/datafile/mes_dt200.dbf';

…（详见MES_Prod_Storage切换His.txt）

…

alter database rename file '+ORADATA1/cmeshis/datafile/system.515.858875471'

to '+ORADATA/cmesrel/datafile/system.515.858875471';

3.4.6 Recover Database（两数据库单独执行）

RMAN> recover database;

3.4.7 Open Database（两数据库单独执行）

RMAN> alter database open;

3.5重建 TEMP

DataBase cmesrel

ALTER TABLESPACE TEMP1 ADD TEMPFILE '+ORADATA/cmesrel/datafile/temp01.dbf' SIZE 2048M AUTOEXTEND OFF;

alter tablespace TEMP1 drop tempfile '+ORADATA1/cmesrel/datafile/temp01.dbf'; DataBase cmeshis

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