Oracle跨平台迁移-ORACLE OCP认证考试 (2).docx

《Oracle跨平台迁移-ORACLE OCP认证考试 (2).docx》由会员分享，可在线阅读，更多相关《Oracle跨平台迁移-ORACLE OCP认证考试 (2).docx（21页珍藏版）》请在第一文库网上搜索。

1、一、迁移WindoWS数据库至IinUX上1、WindoWS上的控制文件、日志文件与Iir1UX上的不一样，所以无需拷贝2、数据文件头不一样，需要修改，转换3、查看大小码se1ect*fromv$transportab1e_p1atform4、迁移数据文件，大码可以互转，小码可以互转，大小码之间不能互转5、迁移表空间，大小码之间也可以迁移，但是字符集不一样不能迁移!届a鼠导鼠抬。厚|工作表直啜建器se1ect*fromv$pdbs;se1ect*fromv$transportab1e_p1atformA查询结果X好鸟磁星SQ1提取的所有行：21,用时0.006秒由P1ATFORM-IDiP1T

2、FOBM-NAENDIAN.FORMATzjCON_ID11So1aristmOE(32-bit)Big022So1aristjaOE(64-bit)Big037MicrosoftWindowsIA(32-bit)1itt1e04101inuxIA(32-bit)1itt1e056AIX-BasedSystems(64-bit)Big063HP-UX(64-bit)Big075HPTru64UNIX1itt1e084HP-UXIA(64-bit)Big09111inuxIA(64-bit)1itt1e01015HPOpenVMS1itt1e0118MicrosoftWindowsIA(64-b

3、it)1itt1e0129IBMZSerieSBased1inuxBig013131inUXx8664-bit1itt1e01416App1eMacOSBig01512MicrosoftWindowsx8664-bit1itt1e01617So1arisOperatingSystem(x86)1itt1e01718IBMPowerBased1inuxBig01819HPIAOpenVMS1itt1e01920So1arisOperatingSystem(x86-64)1itt1e02021App1eMacOS(x86-64)1itt1e021221inuxOS(S64)Big06、经过查看，W

4、indOWS迁移到IinUX是可以进行的7、需要正常关库8、修改etcoratab文件Eorac1eOdb+ASMcdb2orac1edboradedbaduporac1edborac1edborac1e9dborac1edbaduporac1edborac1edb+asmcdb2orac1edb+asmcdb2admin$Isorc1orc12rcatadmin$orc12Sorc!2Sadump$adump$orc12orc12Sadmin$Cdrc12IscdadumpIscd.orc1orc12rcatadmin$Isorc1orc12rcatorac1edbadmin$cdorac1

5、edborac1e$IsadninCfgtoo11ogscrsdatafast_recovery_areaproductauditcheckpointsdiagoradataorac1edbOraC1R$cdoradata/orac1edboradataSIsORC1orc12rcatorac1edbOradata$catecoraab#BaCkUPfi1eisu01apporac1ecrsdatadbouputoratab.bak.db.orac1e1ineAgent# Thisfi1eisusedbyorac1eui1ties.itiscreatedbyroot.sh# andupdate

6、dbyeitherDatabaseconfigurationAssistantwhi1ecreating# adatabaseorasmconfigurationAssistantwhi1ecreatingasminstance.# Aco1on,:,isusedasthefie1dterminator.Anew1ineterminates#theentry.1inesbeginningwithapoundsign,arecomments.# Entriesareoftheform:# $ORAC1E_SID：$ORAC1E_HOME：NY：# Thefirstandsecondfie1dsa

7、rethesystemidentifierandhome# directoryofhedatabaserespective1y.Thethirdfie1dindicates# othedbstaruti1itythathedatabaseshou1d,Y,orshou1dno,#N,bebroughtupatsystemboottime.# Mu1tip1eentrieswiththesame$ORAC1E_SIDarenota11owed.# #rear:u01apporac1e/product/12.1.O/dbhomeJ.:Ncdb2:u01apporac1e/product/19.3.

8、0/dbhome_1:Norc12:/u01/app/orac1e/product/19.3.0/dbhome_2:N+ASM：/u01/app/orac1e/product/19.3.O/qrid：N*1ineaddedbyAgenorc1:/u01/app/orac1e/product/19.3.Obhomej.:N#1ineaddedbyAgenorac1edboradaa$orac1e/orac1e-re1easeorainst.Iocoratabrootdb二*vietc/oratabrootdb#rootdb*roodbroodb#viec/oratabYootOdbIsanaco

9、nda-ks.(:fgDocuments,initia1-setup-ks.cfqorac1e-too1sDesktopDown1oadsMUSTCPicturesrootdbJ*rootdb-#vietc/oratabroo9db#su-orac1eOraC1edbSIsdb.rspDesktopDocunentsDown1oadsMusicPicturesPub1icorac1edb.oraenvORAC1E_SIDorac1e?orc12Theorac1ebasehasbeensettou01apporac1eorac1edbSorac1edb$orac1edb$orac1edbSora

10、c1edbSISdb.rspDeskiorac1edb1opDocunentsDown1oadsMusicPicturesPub1icOraC1edb$orac1edb$cdSorac1ehomeorac1edbdbhome21$Isaddnodede1nsta11dbcopmnracgapexdemodkoracorerdbmsassistantsdiagnostics1iborainst.Iocre1notesbindudapordroot.shCfqtoo11oqsdrdaasrIbordsrocrt.sh.o1dc1onedvoqOSSroot.sh.o1d.1CSenv.oraidO

11、U1root.sh.o1d.2CSShasnowo*mroot.sh.o1d.3CtXhsnetworkper1p1sq1runinsta11erCVinsta11r11sSchaqent.confdataInstantc1ientCdbcprecompQQpatchsdk-dbjavadbsinventoryC)1aps1axjavavmOPatchRsq1deve1operorac1edbdtinome21$cd.,orac1edb19.3.0$cd.:QraCIedbproduct!Is12.1.019.3.Oorac1edbproduct$Cd.orac1edborac1eSIspro

12、ductpub1icTemp1atesTemp1atesTemp1atesSq1jsq1patchsq1p1usSrVn1suptoo1sucpusmIft1adninCfgtoo11ogsauditcheckpointsorac1edbOraCIe$u01apporac1eorac1eadborac1e$+asm/cdb2orc1/orac1edborac1e$crsdatafast_recovery_areadiagoradataPWdcdadmin/orc12/rcatcdadmin/orac1edborac1edbaduporac1edborac1edborac1edborac1edb

13、adunporac1edborac1e9db+ASMcdb2admin$cdorc12oc12J5Isorc12$Cdadumpadump$Isadump$cd.orc12SIsorc12$cd.admin$Isorc1orc12rcatorac1edbadmin!$Is+asmcdb2orc1orc12rcatorac1edbadmin$cd.orac1edborac1ej$IsackninCfgtoo11ogscrsdatafast_recovery_areaproductauditcheckpointsd1agOradataorac1edborac1e，Cdoradata/orac1edbOradataI