Oracle数据库迁移 Windows To Linux （RMAN异构迁移）

两边数据数据库版本一致-RMAN异构迁移

听很多大佬说RMAN是不支持异构迁移的....，但是还是操作了一波，可以成功！

源库：创建源库的pfile文件

shutdown immediate

startup mount

create pfile='D:\oracle\oradata\protect\pfile0413.ora' from spfile;

源库：备份数据库

这里数据库比较大，有1T的数据量。

这里备份是在数据库mount模式下进行备份（冷备份）的

run{
       allocate channel d1 type disk;
       allocate channel d2 type disk;
       allocate channel d3 type disk;
       allocate channel d4 type disk;     
       allocate channel d5 type disk;     
       allocate channel d6 type disk;     
       allocate channel d7 type disk;     
       allocate channel d8 type disk;     
       backup as compressed backupset filesperset 4 database format 'E:\dlpdata\%d_%T_%U_1.bak';
       backup current controlfile format 'E:\dlpdata\ctl_%d_%T_%t_%s_%p';
       release channel d1;
       release channel d2;
       release channel d3;
       release channel d4;
       release channel d5;
       release channel d6;
       release channel d7;
       release channel d8;
}

共享备份目录到Linux系统

/dlp是通过NFS从Windows共享过来的目录，里面主要是数据库RMAN的备份文件，具体操作过程就不再赘述。

 

给备份文件赋权

chown -R oracle:oinstall /dlp

chmod -R 777 /dlp

修改pfile文件

主要是修改一系列目录，从Windows转移到Linux

[oracle@dlporacle dlp]$ cat pfile0413.ora

protect.__data_transfer_cache_size=0
protect.__db_cache_size=1778384896
protect.__java_pool_size=33554432
protect.__large_pool_size=83886080
#protect.__oracle_base='D:\oracle'#ORACLE_BASE set from environment
protect.__oracle_base='/u01/app/oracle'
protect.__pga_aggregate_target=805306368
protect.__sga_target=2415919104
protect.__shared_io_pool_size=0
protect.__shared_pool_size=503316480
protect.__streams_pool_size=0
*.aq_tm_processes=1
*.compatible='12.1.0.2.0'
#*.control_files='D:\oracle\oradata\protect\CONTROL01.CTL','D:\oracle\oradata\protect\CONTROL02.CTL','D:\oracle\oradata\protect\CONTROL03.CTL'
*.control_files='/u01/app/oracle/oradata/protect/control01.ctl','/u01/app/oracle/fast_recovery_area/protect/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='protect'
#*.db_recovery_file_dest='C:\ora_fast'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=32212254720
*.disk_asynch_io=FALSE
*.fast_start_mttr_target=0
*.job_queue_processes=10
*.log_archive_config='dg_config=(protect,protect_dg)'
*.log_archive_dest_2='SERVICE=protect_dg COMPRESSION=ENABLE LGWR ASYNC AFFIRM VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=protect_dg'
*.log_archive_dest_state_2='ENABLE'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=1000
*.pga_aggregate_limit=0
*.pga_aggregate_target=768m
*.processes=1000
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.session_max_open_files=20
*.sessions=1500
*.sga_target=2304m
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'

catalog备份文件

startup nomount pfile='/dlp/pflie0413.ora'

restore controlfile from '/dlp/CTL_PROTECT_20200414_1037668370_67_1';

sql 'alter database mount';

crosscheck backup;

delete expired backup;

catalog start with '/dlp/';

还原数据库

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
allocate channel c7 type disk;
allocate channel c8 type disk;
set   newname for   datafile 1 to '/dlpdata/SYSTEM01.DBF';
set   newname for   datafile 2 to '/dlpdata/SYSAUX01.DBF';
set   newname for   datafile 3 to '/dlpdata/UNDOTBS01.DBF';
set   newname for   datafile 4 to '/dlpdata/DRSYS01.DBF';
set   newname for   datafile 5 to '/dlpdata/LOB01.DBF';
set   newname for   datafile 6 to '/dlpdata/LOB02.DBF';
set   newname for   datafile 7 to '/dlpdata/LOB03.DBF';
set   newname for   datafile 8 to '/dlpdata/USERS01.DBF';
set   newname for   datafile 9 to '/dlpdata/USERS02.DBF';
set   newname for   datafile 10 to '/dlpdata/USERS03.DBF';
set   newname for   datafile 11 to '/dlpdata/USERS04.DBF';
set   newname for   datafile 12 to '/dlpdata/LOB04.DBF';
set   newname for   datafile 13 to '/dlpdata/LOB05.DBF';
set   newname for   datafile 14 to '/dlpdata/LOB06.DBF';
set   newname for   datafile 15 to '/dlpdata/LOB07.DBF';
set   newname for   datafile 16 to '/dlpdata/LOB08.DBF';
set   newname for   datafile 17 to '/dlpdata/USERS05.DBF';
set   newname for   datafile 18 to '/dlpdata/LOB09.DBF';
set   newname for   datafile 19 to '/dlpdata/LOB10.DBF';
set   newname for   datafile 20 to '/dlpdata/LOB11.DBF';
set   newname for   datafile 21 to '/dlpdata/LOB12.DBF';
set   newname for   datafile 22 to '/dlpdata/LOB13.DBF';
set   newname for   datafile 23 to '/dlpdata/LOB14.DBF';
set   newname for   datafile 24 to '/dlpdata/LOB15.DBF';
set   newname for   datafile 25 to '/dlpdata/LOB16.DBF';
set   newname for   datafile 26 to '/dlpdata/LOB17.DBF';
set   newname for   datafile 27 to '/dlpdata/LOB18.DBF';
set   newname for   datafile 28 to '/dlpdata/LOB19.DBF';
set   newname for   datafile 29 to '/dlpdata/LOB20.DBF';
set   newname for   datafile 30 to '/dlpdata/LOB21.DBF';
set   newname for   datafile 31 to '/dlpdata/LOB22.DBF';
set   newname for   datafile 32 to '/dlpdata/LOB23.DBF';
set   newname for   datafile 33 to '/dlpdata/LOB24.DBF';
set   newname for   datafile 34 to '/dlpdata/LOB25.DBF';
set   newname for   datafile 35 to '/dlpdata/LOB26.DBF';
set   newname for   datafile 36 to '/dlpdata/LOB27.DBF';
set   newname for   datafile 37 to '/dlpdata/LOB29.DBF';
set   newname for   datafile 38 to '/dlpdata/LOB30.DBF';
set   newname for   datafile 39 to '/dlpdata/SYSTEM02.DBF';
restore database;
switch datafile all;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
release channel c7;
release channel c8;
}

数据还原后的调整

alter database open resetlogs upgrade;

Database altered.

show parameter pfile;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string


根据pfile生成spfile

create spfile from pfile='/dlp/pfile0413.ora';

File created.

编译无效对象

@?/rdbms/admin/utlrp.sql

重做TEMP表空间

col name for a50;

select file#, ts#, name, status from v$tempfile;

     FILE#        TS# NAME                                               STATUS

---------- ---------- -------------------------------------------------- -------

         1          3 D:\ORACLE\ORADATA\PROTECT\TEMP01.DBF               ONLINE



alter database tempfile 'D:\ORACLE\ORADATA\PROTECT\TEMP01.DBF' drop;

Database altered.

直接删除，会提示不能删除默认临时表空间：

drop tablespace temp;

drop tablespace temp

*

ERROR at line 1:

ORA-12906: ????????????

解决方案：新建一个临时表空间，将其设置为默认临时表空间，再删除原本的临时表空间

CREATE TEMPORARY TABLESPACE temp2 TEMPFILE '/dlpdata/TEMP2.DBF' SIZE 200m AUTOEXTEND ON;

Tablespace created.

alter database default temporary tablespace temp2;

Database altered.

drop tablespace temp;

Tablespace dropped.

CREATE TEMPORARY TABLESPACE temp TEMPFILE '/dlpdata/TEMP01.DBF' SIZE 1G REUSE AUTOEXTEND ON NEXT 200M  MAXSIZE 30G;

Tablespace created.

alter database default temporary tablespace temp;

Database altered.

shutdown immediate

startup

drop tablespace temp2 including contents and datafiles;

select file#, ts#, name, status from v$tempfile;

     FILE#        TS# NAME                                               STATUS

---------- ---------- -------------------------------------------------- -------

         2          3 /dlpdata/TEMP01.DBF                                ONLINE

再次重新编译无效对象

@?/rdbms/admin/utlrp.sql

以上，数据库迁移成功。