oracle 到 linux,Oracle 11g Windows 迁移至 Linux

OS:

windows server 2008 R2 enterprise

DB:

11.2.0.1.0

数据库配置：

ORACLE_BASE=D:\app\Administrator

ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1

ORACLE_SID=yoon

↓

OS:

Oracle Linux Server release 5.7

DB:

11.2.0.3.0

数据库配置：

ORACLE_BASE=/u01/oracle;

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

ORACLE_SID=yoon

1、登录到Windows下的oracle

① 创建pfile

② 创建spfile

③ 关闭数据库

④ 拷贝数据文件、控制文件、重做日志组、参数文件 到 Linux 对应的目录

2、登录到Linux下的oracle(提前安装oracle软件)

① 在oracle用户下创建对应的目录

② 在windows下参数文件名有大小写，在linux将文件名改为小写

③ 编辑linux下的参数文件inityoon.ora 将windows路径改成linux路径

即：

[oracle@yoon dbs]$ cat inityoon.ora

yoon.__db_cache_size=1543503872

yoon.__java_pool_size=16777216

yoon.__large_pool_size=16777216

yoon.__oracle_base='/u01/oracle'#ORACLE_BASE set from

environment

yoon.__pga_aggregate_target=1375731712

yoon.__sga_target=2063597568

yoon.__shared_io_pool_size=0

yoon.__shared_pool_size=452984832

yoon.__streams_pool_size=0

*.audit_file_dest='/u01/oracle/admin/yoon/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/oracle/oradata/yoon/control01.ctl','/u01/oracle/fast_recovery_area/yoon/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='yoon'

*.db_recovery_file_dest='/u01/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4102029312

*.diagnostic_dest='/u01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=yoonXDB)'

*.memory_target=3435134976

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

④ 创建密码文件

即：

[oracle@yoon dbs]$ orapwd file=orapwyoon password=oracle

3、登录到linux的oracle下

[oracle@yoon ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 22 17:40:56

2013

Copyright (c) 1982, 2011, Oracle. All rights

reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

SQL>

SQL> startup mount

pfile='/u01/oracle/product/11.2.0/db_1/dbs/inityoon.ora';

SQL> crate spfile from

pfile='/u01/oracle/product/11.2.0/db_1/dbs/inityoon.ora';

--下次启动时，直接以spfile参数文件启动

4、生成控制文件的跟踪文件

SQL> alter database backup controlfile to

trace;

SQL> shutdown immediate

[oracle@yoon ~]$ cd /u01/oracle/diag/rdbms/yoon/yoon/trace

[oracle@yoon trace]$ ls

-ltr --查找最新的 ‘XXX.trc' 文件 即：yoon_ora_7891.trc

[oracle@yoon trace]$ vi yoon_ora_7891.trc

[oracle@yoon backup]$ cat yoon_ora_7891.trc

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "YOON"

NORESETLOGS NOARCHIVELOG

MAXLOGFILES

16

MAXLOGMEMBERS 3

MAXDATAFILES

100

MAXINSTANCES

8

MAXLOGHISTORY 292

LOGFILE

GROUP 1

'/u01/oracle/oradata/yoon/redo01.log' SIZE 50M

BLOCKSIZE 512,

GROUP 2

'/u01/oracle/oradata/yoon/redo02.log' SIZE 50M

BLOCKSIZE 512,

GROUP 3

'/u01/oracle/oradata/yoon/redo03.log' SIZE 50M

BLOCKSIZE 512

DATAFILE

'/u01/oracle/oradata/yoon/system01.dbf',

'/u01/oracle/oradata/yoon/sysaux01.dbf',

'/u01/oracle/oradata/yoon/undotbs01.dbf',

'/u01/oracle/oradata/yoon/users01.dbf'

CHARACTER SET ZHS16GBK

;

RECOVER DATABASE

-- Database can now be opened normally.

ALTER DATABASE OPEN;

-- Commands to add tempfiles to temporary tablespaces.

-- Online tempfiles have complete space information.

-- Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE

'/u01/oracle/oradata/yoon/TEMP01.DBF' REUSE;

--数据文件改为小写

SQL> STARTUP NOMOUNT

SQL> CREATE CONTROLFILE REUSE DATABASE "YOON"

NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 '/u01/oracle/oradata/yoon/redo01.log' SIZE 50M BLOCKSIZE

512,

GROUP 2 '/u01/oracle/oradata/yoon/redo02.log' SIZE 50M BLOCKSIZE

512,

GROUP 3 '/u01/oracle/oradata/yoon/redo03.log' SIZE 50M BLOCKSIZE

512

DATAFILE

'/u01/oracle/oradata/yoon/system01.dbf',

'/u01/oracle/oradata/yoon/sysaux01.dbf',

'/u01/oracle/oradata/yoon/undotbs01.dbf',

'/u01/oracle/oradata/yoon/users01.dbf'

CHARACTER SET ZHS16GBK

;

SQL> RECOVER DATABASE;

5、关闭数据库，更新数据字典

SQL> SHUTDOWN IMMEDIATE

SQL> startup upgrade;

SQL>

@/u01/oracle/product/11.2.0/db_1/rdbms/admin/catupgrd.sql

SQL>

@/u01/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql

6、启动数据库

SQL> STARTUP;

*注意windows下的oracle版本低，linux下的oracle版本高哦*