ASM迁移

文档

当前您的位置：首页 > 技术活动 > 技术中心 > 文档

ASM迁移 -CUUG

　　ASM迁移

　　环境：

　　sys@ORCL> select * from v$version where rownum=1;

　　BANNER

　　----------------------------------------------------------------

　　Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

　　sys@ORCL> !uname -a

　　Linux localhost.localdomain 2.6.18-308.el5xen #1 SMP Fri Jan 27 17:59:00 EST 2012 i686 i686 i386 GNU/Linux

　　① 规划

　　+DG1：用于存放数据文件、控制文件、联机日志

　　+DG2：用于存放联机日志

　　+RECOVERY:用于recovery area

　　idle> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;

　　GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

　　------------ ---------- --------------------------------- ---------- ----------

　　1 DG1 MOUNTED 3072 3016

　　2 DG2 MOUNTED 768 718

　　3 RECOVERY MOUNTED 2304 2250

　　② 修改RDBMS参数

　　idle> alter system set db_recovery_file_dest='+RECOVERY' scope=both;

　　System altered.

　　idle> alter system set db_create_file_dest='+DG1' scope=both;

　　System altered.

　　idle> alter system set db_create_online_log_dest_1='+DG1' scope=both;

　　System altered.

　　idle> alter system set db_create_online_log_dest_2='+DG2' scope=both;

　　System altered.

　　③ 日志文件迁移

　　idle> alter database add logfile group 4 ('+DG1','+DG2') size 80m;

　　Database altered.

　　idle> alter database add logfile group 5 ('+DG1','+DG2') size 80m;

　　Database altered.

　　idle> alter database add logfile group 6 ('+DG1','+DG2') size 80m;

　　Database altered.

　　日志组的状态为inactive时，删除才能成功

　　idle> alter system checkpoint;

　　idle> alter database drop logfile group 1;

　　Database altered.

　　idle> alter database drop logfile group 2;

　　Database altered.

　　idle> alter database drop logfile group 3;

　　Database altered.

　　idle> select group#,status from v$log;

　　GROUP# STATUS

　　---------- ----------------

　　4 INACTIVE

　　5 CURRENT

　　6 UNUSED

　　idle> select member from v$logfile;

　　MEMBER

　　-----------------------------------------------------------------

　　+DG1/orcl/onlinelog/group_4.256.798634749

　　+DG2/orcl/onlinelog/group_4.256.798634753

　　+DG1/orcl/onlinelog/group_5.259.798634795

　　+DG2/orcl/onlinelog/group_5.259.798634801

　　+DG1/orcl/onlinelog/group_6.260.798634825

　　+DG2/orcl/onlinelog/group_6.260.798634829

　　④ 临时文件迁移

　　idle> select file_name,tablespace_name from dba_temp_files;

　　FILE_NAME TABLESPACE_NAME

　　------------------------------------------------------- ------------------------------

　　/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j3 TEMP

　　4j_.tmp

　　idle> alter tablespace temp add tempfile '+DG1';

　　Tablespace altered.

　　idle> select file_name,tablespace_name from dba_temp_files;

　　FILE_NAME TABLESPACE_NAME

　　------------------------------------------------------- ------------------------------

　　+DG1/orcl/tempfile/temp.258.798635383 TEMP

　　/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j3 TEMP

　　4j_.tmp

　　idle> alter tablespace temp drop tempfile '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_8050j34j_.tmp';

　　Tablespace altered.

　　idle> select file_name,tablespace_name from dba_temp_files;

　　FILE_NAME TABLESPACE_NAME

　　------------------------------------------------------- ------------------------------

　　+DG1/orcl/tempfile/temp.258.798635383 TEMP

　　⑤ 迁移控制文件、数据文件

　　在整个迁移过程，只有这一步需要对数据库实例进行关闭和启动

　　idle> show parameter control_files

　　NAME TYPE VALUE

　　------------------------------------ ----------- ------------------------------

　　control_files string /u01/app/oracle/oradata/ORCL/c

　　ontrolfile/o1_mf_8050hgfp_.ctl

　　, /u01/app/oracle/flash_recove

　　ry_area/ORCL/controlfile/o1_mf

　　_8050hgqh_.ctl

　　idle> alter database backup controlfile to '/home/oracle/asmctl02.ctl';

　　Database altered.

　　idle> alter system set control_files='+DG1/ORCL/CONTROLFILE/control01','+DG2/ORCL/CONTROLFILE/control02' scope=spfile;

　　System altered.

　　idle> shutdown immediate;

　　Database closed.

　　Database dismounted.

　　ORACLE instance shut down.

　　RMAN> startup nomount;

　　Oracle instance started

　　Total System Global Area 419430400 bytes

　　Fixed Size 1219760 bytes

　　Variable Size 146801488 bytes

　　Database Buffers 268435456 bytes

　　Redo Buffers 2973696 bytes

　　RMAN> restore controlfile from '/home/oracle/asmctl02.ctl';

　　Starting restore at 06-NOV-12

　　using target database control file instead of recovery catalog

　　allocated channel: ORA_DISK_1

　　channel ORA_DISK_1: sid=156 devtype=DISK

　　channel ORA_DISK_1: copied control file copy

　　output filename=+DG1/orcl/controlfile/control01

　　output filename=+DG2/orcl/controlfile/control02

　　Finished restore at 06-NOV-12

　　RMAN> alter database mount;

　　database mounted

　　released channel: ORA_DISK_1

　　RMAN> backup as copy database format '+DG1';

　　Starting backup at 06-NOV-12

　　using channel ORA_DISK_1