Oracle数据库迁移 Windows To Linux

姚树友

1813

7页

11次

2020-04-17

10墨值下载

源库：创建源库的

ple

文件

shutdown immediate

startup mount

create ple='D:\oracle\oradata\protect\ple0413.ora' from sple;

源库：备份数据库

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 lesperset 4 database format 'E:\dlpdata\%d_%T_

%U_1.bak';

backup current controlle 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;

}

/dlp

是通过

NFS

从

Windows

共享过来的目录

赋权

chown -R oracle:oinstall /dlp

chmod -R 777 /dlp

修改

ple

文件

主要是修改对象的目录，从

Windows

转移到

Linux

[oracle@dlporacle dlp]$ cat ple0413.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_les='D:\oracle\oradata\protect\CONTROL01.CTL','D:\oracle\oradata\protect\CO

NTROL02.CTL','D:\oracle\oradata\protect\CONTROL03.CTL'

*.control_les='/u01/app/oracle/oradata/protect/control01.ctl','/u01/app/oracle/fast_recover

y_area/protect/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='protect'

#*.db_recovery_le_dest='C:\ora_fast'

*.db_recovery_le_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_le_dest_size=32212254720

*.disk_asynch_io=FALSE

*.fast_start_mttr_target=0

*.job_queue_processes=10

*.log_archive_cong='dg_cong=(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'

of 7

10墨值下载

oracle 升级迁移方案

关注

评论