文章转自链接，版权归作者所有

hps://www.modb.pro/db/12188

摘要：



迁移内容：

表空间

TBS3

Oracle version

+' ,%

-./0*,$ /,123,2'&$4%

2.

迁移过程

查看平台信息

567897/8797:

5097;<8/97=97/87%

97/>97/878>8/97

?????????????????????????????????????????????????????????????

:>? )$@:?"A"+

D>7,2 "'&-"+

>7#" "'&-"+

"'&->@?"A".

"'&->@:?"A".

"'&--D::?"".

E7",,FG"' ,2>@?"A".

D7",,FG"' ,2>@:?"A".

7",,FG"' ,2-D::?"".

E,"('+)$@-D:A".

,"('+)$@-D:?:A".

3.

(

5'$JK&<*,$<23'$"LMNBM%

87;6<

??????????????????????????????????????????????????

8/8B/B:69:

8/BOB:PQ

4.

目标

PDB

 3"''/&#3:+L%

)$ "" ",'%

5.

查看

OFFLINE DATAFILE

5RJ9>RJ87J6*,$K< !23&M99>8M%

',,2

6.

检查表空间自包含

567/8//BQ@MMJ6A%

S5, &&*&),$ 

解压，配置

H,T -.I<&'#"$'?-.,'K/#"

3"KU$'?-.,'K/#"

"'V('+U-.'KL& W

"'V('+U-. ,'W

"'V('+U-. "K

"'V('+U-.$

"'V('+U-.,(

"'V('+U-.&',$,&'W



H,T -.I<$L "+/,&

*,) "S3,$S,S-.S+/,&

L&*,$S3,$S,S-.S+/,&

,+,' S, S-.

L&,' S3,$S,S-.S+/ 

8. xs

传到目标端服务器一份

H,T -.I<?0:DC:US3,$S,S-.S

,T:DC:M2, U

:Q:QSU

QSU

-. ,'WNE

QSU

-. "KNQ

D:QSU

-.$NQ

QSU

-.&',$,&'WNC

QSU

目标创建临时实例

/'$YZ

,$(YZ

-,/>$

11. source-XTTS

</B7SS"'S-. "K?

RRS3,$S,S-.S-.'-:DC:US3,$S,S-.S

S3,$S,S-.S+/,&S0:DC:US3,$S,S-.S+/ 

S3,$S,S-.S$','K$ :DC:US3,$S,S-.S$','K$

?,'KJ,