工程日志--数据库迁移到asm.doc

《工程日志--数据库迁移到asm.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、（项目名称）-工程日志（工程部）工程日志填报日期：２００1４／03／27客户名称产品名称参与人员到达现场[实施目的]数据库迁移到ASM[项目环境]源数据库目标数据库操作系统AIXAIX主机名Aix207Aix207数据库版本Oracle10.2.0.1.0Oracle10.2.0.1.0实例名ProdProd监听LISTENER/1521LISTENER/1521[项目实施]1查询磁盘信息[root@aix207/]#lsdev-cdiskhdisk0Available1S-08-00-8,016BitL

2、VDSCSIDiskDrivehdisk1Available1n-08-02OtherFCSCSIDiskDrivehdisk2Available1n-08-02OtherFCSCSIDiskDrivehdisk3Available1n-08-02OtherFCSCSIDiskDrivehdisk4Available1n-08-02OtherFCSCSIDiskDrivehdisk5Available1n-08-02OtherFCSCSIDiskDrivehdisk6Defined1n-08-02Othe

3、rFCSCSIDiskDrive[root@aix207/]#lsattr-Elhdisk1clr_qnoDeviceCLEARSitsQueueonerrorTruelocationLocationLabelTruelun_id0x1000000000000LogicalUnitNumberIDFalsemax_transfer0x40000MaximumTRANSFERSizeTruenode_name0x50020f200000c39aFCNodeNameFalsepvid0056f03ea9b90

4、1f60000000000000000PhysicalvolumeidentifierFalseq_erryesUseQERRbitTrueq_typesimpleQueuingTYPETrue迪思杰（北京）数码技术有限公司Page17of17竭诚为您服务！（项目名称）-工程日志queue_depth1QueueDEPTHTruereassign_to120REASSIGNtimeoutvalueTruerw_timeout30READ/WRITEtimeoutvalueTruescsi_id0x1080

5、0SCSIIDFalsestart_timeout60STARTunittimeoutvalueTrueww_name0x50020f230000c39aFCWorldWideNameFalse2创建asm磁盘设备[root@aix207/]#smitvg[root@aix207/]#lsvgasmvgVOLUMEGROUP:asmvgVGIDENTIFIER:0056f03e00004c000000014501a5686fVGSTATE:activePPSIZE:64megabyte(s)VGPERMI

6、SSION:read/writeTOTALPPs:480(30720megabytes)MAXLVs:256FREEPPs:480(30720megabytes)LVs:0USEDPPs:0(0megabytes)OPENLVs:0QUORUM:2(Enabled)TOTALPVs:1VGDESCRIPTORS:2STALEPVs:0STALEPPs:0ACTIVEPVs:1AUTOON:yesMAXPPsperVG:32512MAXPPsperPV:1016MAXPVs:32LTGsize(Dynami

7、c):256kilobyte(s)AUTOSYNC:noHOTSPARE:noBBPOLICY:relocatable[root@aix207/]#mklv-y'lv_asm1'-t'raw'asmvg160lv_asm1[root@aix207/]#mklv-y'lv_asm2'-t'raw'asmvg160lv_asm2[root@aix207/]#mklv-y'lv_asm3'-t'raw'asmvg160lv_asm3[root@aix207/]#lsvg-lasmvgasmvg:LVNAMETY

8、PELPsPPsPVsLVSTATEMOUNTPOINTlv_asm1raw1601601closed/syncdN/Alv_asm2raw1601601closed/syncdN/Alv_asm3raw1601601closed/syncdN/A迪思杰（北京）数码技术有限公司Page17of17竭诚为您服务！（项目名称）-工程日志[root@aix207/]#chown-Roracle:oinstall/dev/rlv_as