ASM迁移（beta版）
来源：互联网 发布：linux cp多个文件 编辑：程序博客网 时间：2024/06/05 02:11
环境：
sys@ORCL> select * from v$version where rownum=1;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prodsys@ORCL> !uname -aLinux 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 UNUSEDidle> 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 TEMP4j_.tmpidle> 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 TEMP4j_.tmpidle> 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_filesNAME 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_.ctlidle> 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 startedTotal System Global Area 419430400 bytesFixed Size 1219760 bytesVariable Size 146801488 bytesDatabase Buffers 268435456 bytesRedo Buffers 2973696 bytesRMAN> restore controlfile from '/home/oracle/asmctl02.ctl';Starting restore at 06-NOV-12using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=156 devtype=DISKchannel ORA_DISK_1: copied control file copyoutput filename=+DG1/orcl/controlfile/control01output filename=+DG2/orcl/controlfile/control02Finished restore at 06-NOV-12RMAN> alter database mount;database mountedreleased channel: ORA_DISK_1RMAN> backup as copy database format '+DG1';Starting backup at 06-NOV-12using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyinput datafile fno=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_8050fk2z_.dbfoutput filename=+DG1/orcl/datafile/system.261.798636159 tag=TAG20121106T112238 recid=2 stamp=798636197channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45channel ORA_DISK_1: starting datafile copyinput datafile fno=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_8050fk3w_.dbfoutput filename=+DG1/orcl/datafile/sysaux.262.798636203 tag=TAG20121106T112238 recid=3 stamp=798636232channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35channel ORA_DISK_1: starting datafile copyinput datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_8050jhm7_.dbfoutput filename=+DG1/orcl/datafile/example.263.798636239 tag=TAG20121106T112238 recid=4 stamp=798636252channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15channel ORA_DISK_1: starting datafile copyinput datafile fno=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_8050fkc6_.dbfoutput filename=+DG1/orcl/datafile/undotbs1.264.798636255 tag=TAG20121106T112238 recid=5 stamp=798636257channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08channel ORA_DISK_1: starting datafile copyinput datafile fno=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbfoutput filename=+DG1/orcl/datafile/users.265.798636261 tag=TAG20121106T112238 recid=6 stamp=798636261channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01Finished backup at 06-NOV-12RMAN-06497: WARNING: control file is not current, control file autobackup skippedRMAN> recover database;Starting recover at 06-NOV-12using channel ORA_DISK_1starting media recoveryarchive log thread 1 sequence 16 is already on disk as file +DG1/orcl/onlinelog/group_5.259.798634795archive log filename=+DG1/orcl/onlinelog/group_5.259.798634795 thread=1 sequence=16media recovery complete, elapsed time: 00:00:02Finished recover at 06-NOV-12RMAN> switch database to copy;datafile 1 switched to datafile copy "+DG1/orcl/datafile/system.261.798636159"datafile 2 switched to datafile copy "+DG1/orcl/datafile/undotbs1.264.798636255"datafile 3 switched to datafile copy "+DG1/orcl/datafile/sysaux.262.798636203"datafile 4 switched to datafile copy "+DG1/orcl/datafile/users.265.798636261"datafile 5 switched to datafile copy "+DG1/orcl/datafile/example.263.798636239"RMAN> alter database open resetlogs;database opened
⑥ 确认所有文件已经迁移到ASM中
sys@ORCL> select name,status from v$datafile;NAME STATUS-------------------------------------------------- -------+DG1/orcl/datafile/system.261.798636159 SYSTEM+DG1/orcl/datafile/undotbs1.264.798636255 ONLINE+DG1/orcl/datafile/sysaux.262.798636203 ONLINE+DG1/orcl/datafile/users.265.798636261 ONLINE+DG1/orcl/datafile/example.263.798636239 ONLINEsys@ORCL> select name from v$controlfile;NAME--------------------------------------------------+DG1/orcl/controlfile/control01+DG2/orcl/controlfile/control02sys@ORCL> 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.7986348296 rows selected.sys@ORCL> select name,status from v$tempfile;NAME STATUS-------------------------------------------------- -------+DG1/orcl/tempfile/temp.258.798635383 ONLINE
⑦ 最后验证
idle> startupASM instance startedTotal System Global Area 83886080 bytesFixed Size 1217836 bytesVariable Size 57502420 bytesASM Cache 25165824 bytesASM diskgroups mountedsys@ORCL> startupORACLE instance started.Total System Global Area 419430400 bytesFixed Size 1219760 bytesVariable Size 150995792 bytesDatabase Buffers 264241152 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.ASMCMD> lsctDB_Name Status Software_Version Compatible_version Instance_Nameorcl CONNECTED 10.2.0.1.0 10.2.0.1.0 orclorcl CONNECTED 10.2.0.1.0 10.2.0.1.0 orcl
小结：
这一次迁移，比起上一篇，改进：
⑴ 多增加了2个磁盘组，多了份故障保证，但由于空间方面，还是选择了external ASM
⑵ 对spfile没有进行迁移
⑶ 对控制文件也作了多路镜像：+DG1和+DG2
Good luck
by Think
2012/11/6
- ASM迁移（beta版）
- 理解ASM（七）ASM迁移
- asm迁移到asm
- asm迁移到asm
- RAC数据库迁移（ASM磁盘组迁移）
- 迁移数据库至ASM
- ASM磁盘数据迁移
- RMAN FileSystem 迁移 ASM
- ASM文件系统迁移
- 文件系统迁移至ASM
- ASM磁盘组异机迁移
- ASM迁移至文件系统
- 实验: 把数据库迁移到ASM（完全恢复）
- 通过辅助库（Auxiliary）做ASM迁移案例
- Oracle 数据库迁移数据的建议方法（ASM 到 本地硬盘，或者本地硬盘到 ASM）
- asm数据文件迁移(os–>asm)
- oracle RAC 更换存储迁移数据(在线迁移ASM磁盘组）测试
- ORACLE表空间迁移：ASM->ASM的迁移
- 分享几个jquery星型评级插件
- 由init、loadView、viewDidLoad、viewDidUnload、dealloc的关系说起
- 使用IDE与maven建立工程-1
- opencascade 计算点与TopoDS_Shape中各个点的距离
- android混淆编译 ---- 问题汇总
- ASM迁移（beta版）
- hdu1150 Machine Schedule
- 学习技巧
- JavaScript Try...Catch 语句
- 轻松搭建一个Windows SVN服务器
- HttpClient---Apache Jakarta Common
- TortoiseSVN使用帮助和下载
- 二 : using声明、using指示用于嵌套命名空间时的作用域
- C++ Traits
