数据库运维管理系列之跨平台迁移Oracle11g数据库

现有环境：

OS:Windows Server2008R2

DB版本：OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction（select * from v$version; ）

(非ASM管理)

目标：

将原库整库迁移至Linux rhel6.5 64位OS下

实施步骤：

1，在新操作系统下安装oracle数据库软件到Linux下：（参照../oracle/Linux下oracle安装） 安装时间大约：14:30--

注：仅安装Oracle数据库软件，不安装数据库

2，操作步骤

Source Database

2.1 重启数据库至read only状态

​​SQL> shutdown immediate;​​

​​SQL> startup mount;​​

​​SQL>​​​​alter​​​​database​​​​open​​​​read​​​​only​​​​;​​

2.2 利用RMAN工具convert对应的文件

​​C:\>rman target sys/system@orcl​​

​​恢复管理器: Release 11.2.0.1.0 - Production​​​​on​​​​星期五 7月 5 23:38:38 2013​​

​​Copyright (c) 1982, 2009, Oracle​​​​and​​​​/​​​​or​​​​its affiliates.​​​​All​​​​rights reserved.​​

​​连接到目标数据库: ORCL (DBID=1347002447)​​

​​RMAN>​​CONVERTDATABASENEWDATABASE'orcl'TRANSPORTSCRIPT'C:\rman_convert\transportscript.sql'TOPLATFORM'LinuxIA(64-bit)'format'C:\rman_convert\%U';

此时C:\rman_convert\生成以下文件夹：

xxxxxxxxxxxxx

2.3 复制convert文件夹到linux系统

把C盘的rman_convert文件夹打包复制到linux系统中

Target Database：

2.4 创建对应的文件夹，复制数据文件，修改TRANSPORTSCRIPT.SQL和参数文件

#建立文件夹

cd/home/oracle/app/oracle/

mkdir-p/home/oracle/app/oracle/admin/orcl/{adump,dpdump,pfile}

mkdir-p/home/oracle/app/oracle/flash_recovery_area/

mkdir-p/home/oracle/app/oracle/admin/orcl/adump/

#移动数据文件

mv/home/oracle/app/rman_cpnvert/DATA_D-ORCL_I-1388705516_TS-QWFOC_FNO-5_2GR0496S/home/oracle/app/oracle/oradata/orcl/qwfoc.dbf

mv/home/oracle/app/rman_cpnvert/DATA_D-ORCL_I-1388705516_TS-SYSAUX_FNO-2_2IR049DP/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf

mv/home/oracle/app/rman_cpnvert/DATA_D-ORCL_I-1388705516_TS-SYSTEM_FNO-1_2HR049D0/home/oracle/app/oracle/oradata/orcl/system01.dbf

mv/home/oracle/app/rman_cpnvert/DATA_D-ORCL_I-1388705516_TS-UNDOTBS1_FNO-3_2JR049E8/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf

mv/home/oracle/app/rman_cpnvert/DATA_D-ORCL_I-1388705516_TS-USERS_FNO-4_2KR049EO/home/oracle/app/oracle/oradata/orcl/users01.dbf

#移动参数文件并修改相关参数

[oracle@ora11g/]$mv/home/oracle/app/rman_cpnvert/INIT_00R0496S_1_0.ORA/home/oracle/app/oracle/admin/orcl/pfile/initORCL.ora

参数文件修改如下：

more /home/oracle/app/oracle/admin/orcl/pfile/initORCL.ora：

[oracle@localhostpfile]$more/home/oracle/app/oracle/admin/orcl/pfile/initORCL.ora

#Pleasechangethevaluesofthefollowingparameters:

control_files="/home/oracle/app/oracle/oradata/orcl/control01.dbf"

db_recovery_file_dest="/home/oracle/app/oracle/flash_recovery_area/"

db_recovery_file_dest_size=10737418

audit_file_dest="/home/oracle/app/oracle/admin/orcl/adump/"

db_name="ORCL"

#Pleasereviewthevaluesofthefollowingparameters:

#__oracle_base="D:\app\Administrator"

__shared_pool_size=4865392

__large_pool_size=167772

__java_pool_size=167772

__streams_pool_size=0

__sga_target=20635975

__db_cache_size=15099494

__shared_io_pool_size=0

remote_login_passwordfile="EXCLUSIVE"

db_domain=""

dispatchers="(PROTOCOL=TCP)(SERVICE=orclXDB)"

__pga_aggregate_target=13757317

#Thevaluesofthefollowingparametersarefromsourcedatabase:

processes=1000

sessions=1105

memory_target=343932920

db_block_size=8192

compatible="11.2.0.0.0"

#log_archive_dest_1="LOCATION=D:\arch"

undo_tablespace="UNDOTBS1"

audit_trail="OS"

open_cursors=300

deferred_segment_creatinotallow=FALSE

#diagnostic_dest="D:\APP\ADMINISTRATOR"

transportscript.sql文件修改后内容如下：

oracle@localhostrman_cpnvert]$pwd

/home/oracle/app/rman_cpnvert

[oracle@localhostrman_cpnvert]$moreTRANSPORTSCRIPT.SQL

--Thefollowingcommandswillcreateanewcontrolfileanduseit

--toopenthedatabase.

--DatausedbyRecoveryManagerwillbelost.

--Thecontentsofonlinelogswillbelostandallbackupswill

--beinvalidated.Usethisonlyifonlinelogsaredamaged.

--Aftermountingthecreatedcontrolfile,thefollowingSQL

--statementwillplacethedatabaseintheappropriate

--protectionmode:

--ALTERDATABASESETSTANDBYDATABASETOMAXIMIZEPERFORMANCE

STARTUPNOMOUNTPFILE='/home/oracle/app/oracle/admin/orcl/pfile/initORCL.ora'

CREATECONTROLFILEREUSESETDATABASE"ORCL"RESETLOGSARCHIVELOG

MAXLOGFILES16

MAXLOGMEMBERS3

MAXDATAFILES100

MAXINSTANCES8

MAXLOGHISTORY2532

LOGFILE

GROUP1'/home/oracle/app/oracle/oradata/orcl/redo01.log'SIZE50MBLOCKSIZE512,

GROUP2'/home/oracle/app/oracle/oradata/orcl/redo02.log'SIZE50MBLOCKSIZE512,

GROUP3'/home/oracle/app/oracle/oradata/orcl/redo03.log'SIZE50MBLOCKSIZE512

DATAFILE

'/home/oracle/app/oracle/oradata/orcl/qwfoc.dbf',

'/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf',

'/home/oracle/app/oracle/oradata/orcl/system01.dbf',

'/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf',

'/home/oracle/app/oracle/oradata/orcl/users01.dbf'

CHARACTERSETZHS16GBK

;

--Databasecannowbeopenedzeroingtheonlinelogs.

ALTERDATABASEOPENRESETLOGS;

--Commandstoaddtempfilestotemporarytablespaces.

--Onlinetempfileshavecompletespaceinformation.

--Othertempfilesmayrequireadjustment.

ALTERTABLESPACETEMPADDTEMPFILE'/home/oracle/app/oracle/oradata/orcl/temp01.dbf'

SIZE2000MAUTOEXTENDONNEXT52428800MAXSIZE32767M;

ALTERTABLESPACETEMPADDTEMPFILE'/home/oracle/app/oracle/oradata/orcl/temp02.dbf'

SIZE30408704AUTOEXTENDONNEXT52428800MAXSIZE32767M;

ALTERTABLESPACEQWFOC_TMPADDTEMPFILE'/home/oracle/app/oracle/oradata/orcl/qwfoc_tmp.dbf'

SIZE524288000AUTOEXTENDONNEXT52428800MAXSIZE32767M;

--Endoftempfileadditions.

--

setechooff

prompt~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

prompt*Yourdatabasehasbeencreatedsuccessfully!

prompt*Therearemanythingstothinkaboutforthenewdatabase.Here

prompt*isachecklisttohelpyoustayontrack:

prompt*1.Youmaywanttoredefinethelocationofthedirectoryobjects.

prompt*2.Youmaywanttochangetheinternaldatabaseidentifier(DBID)

prompt*ortheglobaldatabasenameforthisdatabase.Usethe

prompt*NEWDBIDUtility(nid).

prompt~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SHUTDOWNIMMEDIATE

--STARTUPUPGRADEPFILE='C:\RMAN_CONVERT\INIT_00R0496S_1_0.ORA'

--@@?/rdbms/admin/utlirp.sql

--SHUTDOWNIMMEDIATE

STARTUPPFILE='/home/oracle/app/oracle/admin/orcl/pfile/initORCL.ora'

--ThefollowingstepwillrecompileallPL/SQLmodules.

--Itmaytakeserveralhourstocomplete.

@@?/rdbms/admin/utlrp.sql

setfeedback6;

[oracle@localhostrman_cpnvert]$

2.2进入sqlplus执行TRANSPORTSCRIPT.SQL文件

sqlplus/assysdba

​​[oracle@ora11g /]$ sqlplus /nolog​​

​​SQL*Plus: Release 11.2.0.1.0 Production​​​​on​​​​Sat Jul 6 04:21:58 2013​​

​​Copyright (c) 1982, 2009, Oracle.​​​​All​​​​rights reserved.​​

​​SQL> conn /​​​​as​​​​sysdba​​

​​Connected​​​​to​​​​an idle instance.​​

​​SQL>@/home/oracle/app/rman_convert/TRANSPORTSCRIPT.SQL​​

​​ORACLE instance started.​​

​​Total System​​​​Global​​​​Area 146472960 bytes​​

​​Fixed​​​​Size​​​​​1335080 bytes​​

​​Variable​​​​Size​​​​​92274904 bytes​​

​​Database​​​​Buffers 50331648 bytes​​

​​Redo Buffers 2531328 bytes​​

​​Control file created.​​

​​Database​​​​altered.​​

​​Tablespace altered.​​

​​...............​​

​​,,,,......​​