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

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

vi /etc/oracle/ocr.loc

ocrconfig_loc=/dev/raw/raw15

ocrmirrorconfig_loc=/dev/raw/raw16

local_only=false

3.2.4导入OCR备份信息到新的OCR磁盘

./ocrconfig -import /tmp/ocrbak.dmp

./ocrcheck

3.2.5导入Vote信息到新磁盘

dd if=/tmp/vote.bak of=/dev/raw/raw17

dd if=/tmp/vote.bak of=/dev/raw/raw18

dd if=/tmp/vote.bak of=/dev/raw/raw19

./crsctl add css votedisk /dev/raw/raw17 -force

./crsctl add css votedisk /dev/raw/raw18 -force

./crsctl add css votedisk /dev/raw/raw19 -force

./crsctl query css votedisk

3.2.6删除原VoteDisk

./crsctl delete css votedisk /dev/raw/raw12 -force

./crsctl delete css votedisk /dev/raw/raw13 -force

./crsctl delete css votedisk /dev/raw/raw14 -force

./crsctl query css votedisk

3.2.7启动CRS确认迁移是否成功

./crsctl start crs

Attempting to start CRS stack

The CRS stack will be started shortly

crs_stat -t

3.3迁移参数文件

3.3.1新位置创建参数文件

DataBase cmesrel

export ORACLE_SID=cmesrel1

sqlplus / as sysdba

show parameter spfile;

create pfile='/tmp/pfilecmesrel_1204.ora' from spfile;

create spfile='+ARCHIVE/cmesrel/spfilecmesrel.ora'

pfile='/tmp/pfilecmesrel_1204.ora';

DataBase cmeshis

export ORACLE_SID=cmeshis1

sqlplus / as sysdba

show parameter spfile;

create pfile='/tmp/pfilecmeshis_1204.ora' from spfile;

create spfile='+ARCHIVE/cmeshis/spfilecmeshis.ora'

pfile='/tmp/pfilecmeshis_1204.ora';

3.3.2修改参数文件指定到新的参数文件(两节点)

from from