裸设备迁移方案

《裸设备迁移方案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Sxdb的数据库，由于本人过失，将数据文件加到了r5上，特准备了一下迁移方案！测试在redhat5下面进行的，同样是采用逻辑卷的方式的。一、测试过程1、查看一下数据据文件SQL>selectstatus,file_namefromdba_data_fileswheretablespace_name='USERSSTATUSFILE_NAME-----------------------------------------AVAILABLE/dev/raw/raw11AVAILABLE/dev/raw/raw12

2、AVAILABLE/dev/raw/raw13AVAILABLE/dev/raw/raw14AVAILABLE/dev/raw/raw15假如要将raw15迁移到别的存储上面去[root@uptestoradata]#vgdisplayoravg

3、grepFreeFreePE/Size51830/20.25GB2、新建lv[root@updataoradata]#lvcreate-nusers06-L20482moravg[root@updataoradata]#raw/dev/raw/raw16/dev/ma

4、pper/oravg-users06[root@updataoradata]#chownoracle:oinstall/dev/mapper/oravg-users06[root@updataoradata]#chownoracle:oinstall/dev/raw/raw16[root@updataoradata]#chmod660/dev/raw/raw16建好了后，就可以迁移了3、迁移裸设备首先将要迁移的文件离线SQL>alterdatabasedatafile'/dev/raw/raw15'offlin

5、e打开rman,进行迁移复制[oracle@updatau02]$rmantarget/RMAN>copydatafile'/dev/raw/raw15'to'/dev/raw/raw16';Startingbackupat05-MAY-12usingtargetdatabasecontrolfileinsteadofrecoverycatalogallocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=18devicetype=DISKchannelORA_DISK_1

6、:startingdatafilecopyinputdatafilefilenumber=00005name=/dev/raw/raw15outputfilename=/dev/raw/raw15tag=TAG20120505T051439RECID=3STAMP=782457346channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:05:15Finishedbackupat05-MAY-124.对数据库文件renameonlineSQL>shutdow

7、nimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupmountORACLEinstancestarted.TotalSystemGlobalArea701485056bytesFixedSize2216664bytesVariableSize322964776bytesDatabaseBuffers373293056bytesRedoBuffers3010560bytesDatabasemounted.SQL

8、>alterdatabaserenamefile'/dev/raw/raw15'to'/dev/raw/raw16';SQL>alterdatabasedatafile'/dev/raw/raw16'online;*ERRORatline1:ORA-01113:file16needsmediarecoveryORA-01110:datafile16:'/dev/raw/raw16'提示需要恢复SQL>recoverdatafile'/dev/raw/raw16';Mediarecoverycomplete.SQ

9、L>alterdatabasedatafile'/dev/raw/raw16'online;Databasealtered.SQL>alterdatabaseopen;Databasealtered.做了一个resizeSQL>alterdatabasedatafile'/dev/raw/raw16'resize20480m;这种迁移，一定要求在归档模式下进行的！二、aix上面的方案关