本篇内容主要讲解“Oracle数据库怎么从Linux x86单机迁移到Solaries双节点RAC集群”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Oracle数据库怎么从Linux x86单机迁移到Solaries双节点RAC集群”吧!

1.清理RAC集群中测试数据

（1）关闭应用服务器所有应用

（2）删除数据库中所有用户数据

DROPUSER"XXXX"CASCADE;2.清理RAC集群中RMAN备份文件

oracle@cwgsdb1:~$rmantarget/RecoveryManager:Release11.2.0.4.0-ProductiononThuOct2510:34:392018Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:CAMS(DBID=2649374962)RMAN>deletebackup;usingtargetdatabasecontrolfileinsteadofrecoverycatalogallocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=4048instance=cams1devicetype=DISKListofBackupPiecesBPKeyBSKeyPc#Cp#StatusDeviceTypePieceName----------------------------------------------------1111AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_3.bak2211AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_4.bak3311AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_1.bak4411AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_2.bak5511AVAILABLEDISK+DATADG/cams/rman/rmanfullback_cams_20181025_6.bak6611AVAILABLEDISK+DATADG/cams/rman/rmanfullback_cams_20181025_7.bak7711AVAILABLEDISK+DATADG/cams/rman/rmanfullback_cams_20181025_5.bak8811AVAILABLEDISK+DATADG/cams/rman/rmanfullback_cams_20181025_8.bak9911AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_9.bak101011AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_10.bak111111AVAILABLEDISK/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-00121211AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_12131311AVAILABLEDISK/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-01141411AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_14151511AVAILABLEDISK/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-02161611AVAILABLEDISK/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-03171711AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_17181811AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_18191911AVAILABLEDISK+DATADG/cams/rman/rmanarch_cams_20181025_19202011AVAILABLEDISK/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-04Doyoureallywanttodeletetheaboveobjects(enterYESorNO)?YESdeletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_3.bakRECID=1STAMP=990407128deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_4.bakRECID=2STAMP=990407199deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_1.bakRECID=3STAMP=990407128deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_2.bakRECID=4STAMP=990407128deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanfullback_cams_20181025_6.bakRECID=5STAMP=990407239deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanfullback_cams_20181025_7.bakRECID=6STAMP=990407241deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanfullback_cams_20181025_5.bakRECID=7STAMP=990407238deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanfullback_cams_20181025_8.bakRECID=8STAMP=990407287deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_9.bakRECID=9STAMP=990407292deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_10.bakRECID=10STAMP=990407292deletedbackuppiecebackuppiecehandle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-00RECID=11STAMP=990407294deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_12RECID=12STAMP=990407671deletedbackuppiecebackuppiecehandle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-01RECID=13STAMP=990407673deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_14RECID=14STAMP=990414011deletedbackuppiecebackuppiecehandle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-02RECID=15STAMP=990414013deletedbackuppiecebackuppiecehandle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-03RECID=16STAMP=990410565deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_17RECID=17STAMP=990414012deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_18RECID=18STAMP=990414013deletedbackuppiecebackuppiecehandle=+DATADG/cams/rman/rmanarch_cams_20181025_19RECID=19STAMP=990414014deletedbackuppiecebackuppiecehandle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-2649374962-20181025-04RECID=20STAMP=990414016Deleted20objectsRMAN>listbackup;specificationdoesnotmatchanybackupintherepository3.清理RAC集群中逻辑备份文件

（1）查看所有在用directories

SQL>setlines300;SQL>colOWNERfora30;SQL>colDIRECTORY_NAMEfora30;SQL>colDIRECTORY_PATHfora50;SQL>select*fromdba_directorieswhereDIRECTORY_NAMEin('DIR_DP','DPDATA1');OWNERDIRECTORY_NAMEDIRECTORY_PATH--------------------------------------------------------------------------------------------------------------SYSDPDATA1/u01/app/oracle/dumpSYSDIR_DP/u01/app/oracle/admin/cams/dpdump/

（2）清理directories路径下文件

oracle@cwgsdb1:~$cd/u01/app/oracle/dumporacle@cwgsdb1:/u01/app/oracle/dump$lscamsData20181017.dmpcamsData20181017.logimpdp_camsData20181017.logoracle@cwgsdb1:/u01/app/oracle/dump$rm*oracle@cwgsdb1:/u01/app/oracle/dump$cd/u01/app/oracle/admin/cams/dpdump/oracle@cwgsdb1:/u01/app/oracle/admin/cams/dpdump$lschannel20181024173831.dmpchannel20181024173831.logcore20181024173831.dmpcore20181024173831.logcwap20181024173831.dmpcwap20181024173831.logoracle@cwgsdb1:/u01/app/oracle/admin/cams/dpdump$rm*oracle@cwgsdb1:/u01/app/oracle/admin/cams/dpdump$ls4.在第RAC第一个节点调整directory路径，指向NFS文件系统

（1）该服务器挂载NFS，查看NFS信息：

oracle@cwgsdb1:~$df-kFilesystem1024-blocksUsedAvailableCapacityMountedonrpool/ROOT/solaris2054062082654764810095807221%//devices0000%/devices/dev0000%/devctfs0000%/system/contractproc0000%/procmnttab0000%/etc/mnttabswap117260882912117231761%/system/volatileobjfs0000%/system/objectsharefs0000%/etc/dfs/sharetabfd0000%/dev/fdrpool/ROOT/solaris/var2054062084156001009580721%/varswap117259762800117231761%/tmprpool/VARSHARE20540620834321009580721%/var/sharerpool/export2054062083041009580721%/exportrpool/export/home2054062083201009580721%/export/homerpool/export/home/grid20540620811281009580721%/export/home/gridrpool/export/home/oracle2054062085921009580721%/export/home/oraclerpool/repo2054062082065660810095807217%/reporpool2054062083841009580721%/rpoolrpool/VARSHARE/zones2054062082881009580721%/system/zonesrpool/VARSHARE/pkg2054062083041009580721%/var/share/pkgrpool/VARSHARE/pkg/repositories2054062082881009580721%/var/share/pkg/repositories100.100.100.54:/impbackup51606140151169283386777231%/backup

（2）调整directory路径：

createorreplacedirectorydir_dpas'/backup/';grantread,writeondirectorydir_dptopublic;

（3）查看NFS文件权限：

oracle@cwgsdb1:~$ls-lrt/total1692dr-xr-xr-x2rootroot2Oct62015homedrwxr-xr-x2rootroot2Sep2822:47mediadrwxr-xr-x18rootsys18Sep2906:58kerneldrwxr-xr-x7rootsys23Sep2907:01platformdrwxr-xr-x3rootsys5Sep2907:01bootlrwxrwxrwx1rootroot10Sep2907:01sbin->./usr/sbinlrwxrwxrwx1rootroot9Sep2907:01bin->./usr/bindrwxr-xr-x2rootsys2Sep2907:01mntdrwxr-xr-x7rootroot7Sep2907:04systemdrwxr-xr-x3rootsys3Sep2907:04exportdrwxr-xr-x4gridoinstall7Sep3001:49softdrwxr-xr-x2rootroot2Oct201:36isodrwxr-xr-x3rootroot15Oct201:41repodrwxr-xr-x12rootbin335Oct201:54libdrwxr-xr-x43rootsys50Oct202:22vardrwxr-xr-x4rootroot4Oct221:02rpooldrwxr-xr-x3rootoinstall3Oct221:07u01drwx------21rootroot30Oct223:34rootdrwxr-xr-x35rootsys47Oct300:12usrdrwxr-xr-x2gridasmadmin7Oct304:52sharediskdrwxr-xr-x7rootsys7Oct307:31optdrwxr-xr-x4rootsys8Oct2401:13devicesdrwxr-xr-x193rootsys193Oct2401:13devdr-xr-xr-x1rootroot1Oct2401:14netdr-xr-xr-x1rootroot1Oct2401:14nfs4drwxrwxrwx2nobodynobody4096Oct2514:36backupdrwxr-xr-x98rootsys194Oct2516:40etcdrwxrwxrwt10rootsys862Oct2516:46tmpdr-xr-xr-x192rootroot480032Oct2516:47proc5.测试新directory备份权限

oracle@cwgsdb1:/backup$expdpdirectory=dir_dpschemas=hrdumpfile=hr.dmplogfile=hr.logparallel=2CLUSTER=NExport:Release11.2.0.4.0-ProductiononThuOct2517:18:542018Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.Username:systemPassword:Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsStarting"SYSTEM"."SYS_EXPORT_SCHEMA_02":system/********directory=dir_dpschemas=hrdumpfile=hr.dmplogfile=hr.logparallel=2CLUSTER=NEstimateinprogressusingBLOCKSmethod...ProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLE_DATATotalestimationusingBLOCKSmethod:448KB..exported"HR"."COUNTRIES"6.367KB25rows..exported"HR"."DEPARTMENTS"7.007KB27rows..exported"HR"."EMPLOYEES"16.80KB107rows..exported"HR"."JOBS"6.992KB19rows..exported"HR"."JOB_HISTORY"7.054KB10rows..exported"HR"."LOCATIONS"8.273KB23rows..exported"HR"."REGIONS"5.476KB4rowsProcessingobjecttypeSCHEMA_EXPORT/USERProcessingobjecttypeSCHEMA_EXPORT/SYSTEM_GRANTProcessingobjecttypeSCHEMA_EXPORT/ROLE_GRANTProcessingobjecttypeSCHEMA_EXPORT/DEFAULT_ROLEProcessingobjecttypeSCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessingobjecttypeSCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessingobjecttypeSCHEMA_EXPORT/TABLE/TABLEProcessingobjecttypeSCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTProcessingobjecttypeSCHEMA_EXPORT/TABLE/COMMENTProcessingobjecttypeSCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessingobjecttypeSCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDUREProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/INDEXProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessingobjecttypeSCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessingobjecttypeSCHEMA_EXPORT/VIEW/VIEWProcessingobjecttypeSCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessingobjecttypeSCHEMA_EXPORT/TABLE/TRIGGERProcessingobjecttypeSCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSMastertable"SYSTEM"."SYS_EXPORT_SCHEMA_02"successfullyloaded/unloaded******************************************************************************DumpfilesetforSYSTEM.SYS_EXPORT_SCHEMA_02is:/backup/hr.dmpJob"SYSTEM"."SYS_EXPORT_SCHEMA_02"successfullycompletedatThuOct2517:19:212018elapsed000:00:136.原生产环境日结关门

在业务人员完成当日业务后，机构关门，防止业务人员登录系统做业务。计划在数据库迁移完成之后执行日结跑批。

7.原生产环境关闭电票前置机应用

登陆电票前置机weblogic控制台，使用tail -f命令查看当前是否在刷日志，如果没有刷日志，则通过控制台关闭电票前置机应用。

8.原生产环境关闭应用

按照应用关闭的逻辑顺序，依次关闭原生产环境应用。

9.原生产环境数据库备份后下线

（1）原数据库备份命令

expdp\'/assysdba\'DIRECTORY=dpdata1DUMPFILE=camsData20181025.dmpSCHEMAS=xxxx,yyyylogfile=camsData20181025.log

（2）文件压缩

tarzcvfcamsData20181025.tar.gzcamsData20181025.dmpcamsData20181025.log

（3）将文件传输至新生产数据库服务器第一个节点中

scpcamsData20181025.tar.gzoracle@100.100.100.215:/u01/app/oracle/dump

（4）关闭老生产数据库

$lsnrctlstop$sqlplus/assysdbaSQL>shutdownimmediate;

（5）关闭定时任务，在任务之前加#

crontab-e

（6）修改旧数据库服务器IP地址为其他地址。

10.修改RAC集群的scan ip为生产数据库IP

按照测试环境验证过的流程，修改RAC集群的scan ip为生产数据库IP。

11.关闭生产环境归档

oracle@cwgsdb1:~$srvctlstopdatabase-dcamsoracle@cwgsdb1:~$srvctlstartdatabase-dcams-omountoracle@cwgsdb1:~$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononThuOct2520:13:322018Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>alterdatabasenoarchivelog;Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>archiveloglist;DatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestination+DATADGOldestonlinelogsequence3Currentlogsequence6另一个节点也执行：SQL>alterdatabaseopen;Databasealtered.SQL>selectopen_modefromgv$database;OPEN_MODE--------------------READWRITEREADWRITE

检查数据库状态

grid@cwgsdb1:~$crsctlstatres-t--------------------------------------------------------------------------------NAMETARGETSTATESERVERSTATE_DETAILS--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.DATADG.dgONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2ora.LISTENER.lsnrONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2ora.SYSTEMDG.dgONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2ora.asmONLINEONLINEcwgsdb1StartedONLINEONLINEcwgsdb2Startedora.gsdOFFLINEOFFLINEcwgsdb1OFFLINEOFFLINEcwgsdb2ora.net1.networkONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2ora.onsONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2ora.registry.acfsONLINEONLINEcwgsdb1ONLINEONLINEcwgsdb2--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINEcwgsdb2ora.cams.db1ONLINEONLINEcwgsdb1Open2ONLINEONLINEcwgsdb2Openora.cvu1ONLINEONLINEcwgsdb1ora.cwgsdb1.vip1ONLINEONLINEcwgsdb1ora.cwgsdb2.vip1ONLINEONLINEcwgsdb2ora.oc4j1ONLINEONLINEcwgsdb1ora.scan1.vip1ONLINEONLINEcwgsdb212.还原最新生产数据

（1）解压最新生产数据

oracle@cwgsdb1:~$cdoracle@cwgsdb1:~$cd/u01/app/oracle/dump/oracle@cwgsdb1:/u01/app/oracle/dump$lscamsData20181025.tar.gzoracle@cwgsdb1:/u01/app/oracle/dump$tarzxvfcamsData20181025.tar.gzxcamsData20181025.dmp,7310499840bytes,14278320tapeblocksxcamsData20181025.log,345007bytes,674tapeblocks

（2）执行导入命令

impdp\'/assysdba\'DIRECTORY=dpdata1DUMPFILE=camsData20181025.dmpSCHEMAS=xxxx,yyyylogfile=impdp_camsData20181025.logcluster=N13.删除导入时提示的无效对象

（注：这里需要和开发人员确认，确认后删除）

dropFUNCTION"DATABUFF"."ELEMIDX";dropFUNCTION"DB2ODESK"."FSBN";dropPROCEDURE"DB2ODESK"."BATCH_DELETE";dropPROCEDURE"DB2ODESK"."SP_DESK_CURRZS";dropPACKAGEBODY"DATABUFF"."MIGRATION_TRANSFORMER";dropFUNCTION"CAMS_BCE"."TX_ZD2";dropFUNCTION"CAMS_BCE"."TX_ZD3";14.开启生产环境归档

oracle@cwgsdb1:/u01/app/oracle/dump$srvctlstopdatabase-dcamsoracle@cwgsdb1:/u01/app/oracle/dump$srvctlstartdatabase-dcams-omountoracle@cwgsdb1:/u01/app/oracle/dump$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononThuOct2520:52:542018Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>alterdatabasearchivelog;Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination+DATADGOldestonlinelogsequence4Nextlogsequencetoarchive7Currentlogsequence7另一个节点也执行：SQL>alterdatabaseopen;Databasealtered.SQL>selectopen_modefromgv$database;OPEN_MODE--------------------READWRITEREADWRITE15.部署生产环境RMAN策略，并执行全量备份

按照测试环境验证过的流程，部署生产环境RAMN策略，并执行手工全量备份。

16.手工收集统计信息

execdbms_stats.gather_schema_stats('XXXX');17.修改生产应用中数据库连接为service连接

按照测试环境验证过的流程，修改生产应用中数据库连接为service连接

18.启动生产环境应用并验证

（注：生产系统使用查询交易进行验证）

按顺序依次启动应用，测试多组跨子系统的查询交易，然后在数据总线监控平台上查看交易的报文以及成功状态。

19.验证批量功能

（注：如果遇到问题，需第一时间处理）

生产环境执行跑批操作，将会计日期跑到第二日，同时验证功能是否正常。

20.生产环境数据库查询用户设定

（这里选择现有用户scott作为插叙用户，只赋予查询权限）

由于测试阶段已经将scott用户解锁，这里不再重复操作。

select'grantselectonXXXX.'||OBJECT_NAME||'toscott;'fromDBA_OBJECTSwhereowner='XXXX'andobject_typein('TABLE','VIEW');

执行上述语句生成的SQL，可为scott用户赋予查询所有业务表和视图的权限。

21.开启电票前置机

登陆电票前置机weblogic控制台，通过控制台开启电票前置机应用。

22.其他问题处理

（1）由于迁移时遇到ORA-04063: view "CAMS_CWAP.QUERYSHOUXIN_V" 有错误的问题，为保证数据表、视图权限完整性，单独执行报表权限脚本。

（2）Linux和Unix系统中date命令不一样，迁移后需单独调整。

（3）Linux和Unix系统中nc命令不一样，迁移后需单独调整。

（4）测试过程发现新生产数据库与测试环境未进行网络隔离，存在一定风险。已通知网络工程师处理。

23.隔日检查RMAN备份集，确认生产运行情况

经过确认，RMAN已经按照既定策略执行备份和历史文件删除，生产环境运行稳定。

至此，生产环境切换工作全部完成完毕，生产环境Oracle数据库成功从Linux X86单机迁移到Solaries双节点RAC集群。

到此，相信大家对“Oracle数据库怎么从Linux x86单机迁移到Solaries双节点RAC集群”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！