在这之后，把linux服务器上的数据库和实例名从大写的orcl改为小写的orcl，并修改了所有的参数文件内容和密码文件重新解压缩冷备份
装一个windows 2008 server 64并装oracle，，然后迁移库至linux环境里
 windows server 2008-192.168.182.128 oracle 11.2.0.3.0 oracle_sid=orcl
 oracle enterprise linux 5.8-192.168.182.131 oracle 11.2.0.1.0 oracle_sid=orcl
流程与10g库迁移到11g相同，在修改控制文件的脚本的时候，除了要修改路径，还要修改数据库名
 1 check information from prod
 on 128-windows oracle服务器
 sqlplus / as sysdba
sys@orcl>select dbid from v$database;
      dbid
 ----------
 1371889729
sys@orcl>create pfile='c:\initorcl.ora' from spfile;
file created.
sys@prod1>alter database backup controlfile to trace;
database altered.
sys@prod1>show parameter user_dump
name                                type        value                                                                                         
------------------------------------ ----------- ------------------------------
 user_dump_dest                      string      c:\oracle\diag\rdbms\orcl\orcl
                                                  \trace
cd c:\oracle\diag\rdbms\orcl\orcl\trace
 copy the trc file to c:\dbclone\control.txt
 and edit it:
 from:
 startup nomount
 create controlfile reuse database orcl resetlogs  noarchivelog
    maxlogfiles 16
    maxlogmembers 3
    maxdatafiles 100
    maxinstances 8
    maxloghistory 292
 logfile
  group 1 '/u01/app/oracle/oradata/orcl/redo01.log'  size 50m blocksize 512,
  group 2 '/u01/app/oracle/oradata/orcl/redo02.log'  size 50m blocksize 512,
  group 3 '/u01/app/oracle/oradata/orcl/redo03.log'  size 50m blocksize 512
 -- standby logfile
 datafile
  '/u01/app/oracle/oradata/orcl/system01.dbf',
  '/u01/app/oracle/oradata/orcl/sysaux01.dbf',
  '/u01/app/oracle/oradata/orcl/undotbs01.dbf',
  '/u01/app/oracle/oradata/orcl/users01.dbf',
  '/u01/app/oracle/oradata/orcl/example01.dbf'
 character set al32utf8
 ;
 to:
 startup nomount
 create controlfile set database orcl resetlogs  noarchivelog
    maxlogfiles 16
    maxlogmembers 3
    maxdatafiles 100
    maxinstances 8
    maxloghistory 292
 logfile
  group 1 '/u01/app/oracle/oradata/orcl/redo01.log'  size 50m blocksize 512,
  group 2 '/u01/app/oracle/oradata/orcl/redo02.log'  size 50m blocksize 512,
  group 3 '/u01/app/oracle/oradata/orcl/redo03.log'  size 50m blocksize 512
 -- standby logfile
 datafile
  '/u01/app/oracle/oradata/orcl/system01.dbf',
  '/u01/app/oracle/oradata/orcl/sysaux01.dbf',
  '/u01/app/oracle/oradata/orcl/undotbs01.dbf',
  '/u01/app/oracle/oradata/orcl/users01.dbf',
  '/u01/app/oracle/oradata/orcl/example01.dbf'
 character set al32utf8
 ;
2.2 cold backup tar-128 orcl
sys@orcl>select name from v$dbfile;
name                                                                                                                                           
--------------------------------------------------------------------------------
 c:\oracle\oradata\orcl\users01.dbf                                           
c:\oracle\oradata\orcl\undotbs01.dbf                 
c:\oracle\oradata\orcl\sysaux01.dbf                                                                                                             
c:\oracle\oradata\orcl\system01.dbf
 c:\oracle\oradata\orcl\example01.dbf