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

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

2.4切换REDO LOG

DataBase cmesrel

select *From v$logfile

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE

5 ONLINE +ORADATA1/cmesrel/onlinelog/group_5.256.858767461 NO

6 ONLINE +ORADATA1/cmesrel/onlinelog/group_6.257.858767471 NO

7 ONLINE +ORADATA1/cmesrel/onlinelog/group_7.258.858767471 NO

8 ONLINE +ORADATA1/cmesrel/onlinelog/group_8.259.858767473 NO

alter database add logfile instance 'cmesrel1' group 1 '+ORADATA' size 200m;

alter database add logfile instance 'cmesrel1' group 2 '+ORADATA' size 200m;

alter database add logfile instance 'cmesrel2' group 3 '+ORADATA' size 200m;

alter database add logfile instance 'cmesrel2' group 4 '+ORADATA' size 200m;

alter sysetem switch logfile;

alter system checkpoint;

alter database drop logfile group 5;

alter database drop logfile group 6;

alter database drop logfile group 7;

alter database drop logfile group 8;

DataBase cmeshis

select *From v$logfile

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE

5 ONLINE +ORADATA1/cmeshis/onlinelog/group_5.511.858874955 NO

6 ONLINE +ORADATA1/cmeshis/onlinelog/group_6.512.858874957 NO

7 ONLINE +ORADATA1/cmeshis/onlinelog/group_7.513.858874957 NO

8 ONLINE +ORADATA1/cmeshis/onlinelog/group_8.514.858874959 NO

alter database add logfile instance 'cmeshis1' group 1 '+ORADATA' size 200m;

alter database add logfile instance 'cmeshis1' group 2 '+ORADATA' size 200m;

alter database add logfile instance 'cmeshis2' group 3 '+ORADATA' size 200m;

alter database add logfile instance 'cmeshis2' group 4 '+ORADATA' size 200m;

alter sysetem switch logfile;

alter system checkpoint;

alter database drop logfile group 5;

alter database drop logfile group 6;

alter database drop logfile group 7;

alter database drop logfile group 8;

2.5切换ARCHIVE LOG

DataBase cmesrel

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

System altered.

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