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

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

System altered.

SQL> archive log list;

DataBase cmeshis

SQL> alter system set log_archive_dest_1='LOCATION=+ ARCHIVE' sid='cmeshis1';

System altered.

SQL> alter system set log_archive_dest_1='LOCATION=+ ARCHIVE' sid='cmeshis2';

System altered.

SQL> archive log list;

2.6收集TEMP FILE、DATAFILE信息(为后续迁移做前期记录)

DataBase cmesrel

SELECT tablespace_name,file_name FROM DBA_TEMP_FILES

TEMP1 +ORADATA1/cmesrel/datafile/temp01.dbf

SELECT tablespace_name,file_name FROM dba_data_files

…(略)

…

DataBase cmeshis

SELECT tablespace_name,file_name FROM DBA_TEMP_FILES

TEMP +ORADATA1/cmeshis/tempfile/temp02.dbf

TEMP +ORADATA1/cmeshis/tempfile/temp01.dbf

SELECT tablespace_name,file_name FROM dba_data_files

…(略)

…

三、停机迁移OCR、VoteDisk、参数文件、控制文件、Temp文件

3.1停止CRS（两节点）

./init.crs stop

3.2切换OCR、VOTEDISK

3.2.1备份OCR

./ocrconfig -export /tmp/ocrbak.dmp

3.2.2备份Vote

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

3.2.3修改OCR路径(两节点)