11.2.0.3 xtts 迁移到12c PDB

最新推荐文章于 2022-12-03 23:50:17 发布
最新推荐文章于 2022-12-03 23:50:17 发布
阅读量984 收藏 4
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m15217321304/article/details/106280582
版权 
1，源与目标数据库的概况
编号      数据库类型      数据库名称   数据库版本    数据库IP地址     操作系统平台
1         oracleRAC    devdb     11.2.0.3      192.168.40.191        redhat 6.5
2         oracleRAC    orcl      12.2.0.1      192.168.40.180        redhat 6.5

2，创建源端数据库的测试表空间及测试用户并创建测试表和插入数据

--//数据文件放在了本地(只是测试用)
drop tablespace TBS_XTTS including contents and datafiles;
create tablespace tbs_xtts datafile '/home/oracle/tbs_xtts01.dbf' size 10m;
create user user_xtts identified by system account unlock default tablespace tbs_xtts;
grant resource,connect to user_xtts;
conn user_xtts/system
create table t_test(a int);
insert into t_test values(1);
commit;


SQL> create tablespace tbs_xtts datafile '/home/oracle/tbs_xtts01.dbf' size 10m;

Tablespace created.

SQL> create user user_xtts identified by system account unlock default tablespace tbs_xtts;

User created.

SQL> grant resource,connect to user_xtts;

Grant succeeded.

SQL> 
SQL> 
SQL> conn user_xtts/system
Connected.
SQL> create table t_test(a int);

Table created.

SQL> insert into t_test values(1);

1 row created.

SQL> commit;

Commit complete.

SQL>
set linesize 300
col name for a50
select file#,name from v$datafile;
     FILE# NAME
---------- --------------------------------------------------
         1 +DATA/devdb/datafile/system.256.940551845
         2 +DATA/devdb/datafile/sysaux.257.940551847
         3 +DATA/devdb/datafile/undotbs1.258.940551847
         4 +DATA/devdb/datafile/users.259.940551847
         5 +DATA/devdb/datafile/undotbs2.264.940552089
         6 +DATA/devdb/datafile/tset.297.1040701645
         7 /home/oracle/tbs_xtts01.dbf

3，在源端数据库对data file 7进行data file copy

--源端执行         
rman target /
backup as copy datafile 7 tag 'datafile 7 copy note' format '/home/oracle/tbs_xtts01.copy';


--//表空间个文件
rman target /
backup as copy datafile 7,8 tag 'datafile 7,8 copy note' format '/home/oracle/tbs_xtts01_%U';
或者
backup as copy tablespace tbs_xtts format '/home/oracle/xxx_%U';


[oracle@rac1]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on ? 58 17:35:54 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEVDB (DBID=845281939)

RMAN> backup as copy datafile 7 tag 'datafile 7 copy note' format '/home/oracle/tbs_xtts01.copy';

Starting backup at 2020/05/18 17:36:19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=162 instance=devdb1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/home/oracle/tbs_xtts01.dbf
output file name=/home/oracle/tbs_xtts01.copy tag=DATAFILE 7 COPY NOTE RECID=26 STAMP=1040751380
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2020/05/18 17:36:21

RMAN> 


[oracle@rac1]$ ls -ltr tbs_xtts*
-rw-r----- 1 oracle asmadmin 10493952 May 18 17:36 tbs_xtts01.copy
-rw-r----- 1 oracle asmadmin 10493952 May 18 17:45 tbs_xtts01.dbf
[oracle@rac1]$

4,传输源端数据库测试表空间DATA FILE COPY到目标端数据库对应目录

[oracle@rac1]$ scp /home/oracle/tbs_xtts01.copy oracle@192.168.40.180:/home/oracle
oracle@192.168.40.180's password: 
tbs_xtts01.copy                                                                                                         100%   10MB  10.0MB/s   00:00    
[oracle@rac1]$ 

5，在目标端数据库对自源端数据库传输过来的测试表空间DATA FILE COPY进行字节序转换

---目标端
[oracle@node1 ~]$ pwd
/home/oracle
[oracle@node1 ~]$ ls -ltr tbs*
-rw-r-----. 1 oracle oinstall 10493952 May 15 23:41 tbs_xtts01.copy
[oracle@node1 ~]$ 

查看PDB的配置

[oracle@node1 admin]$ cat tnsnames.ora
ORCL=
(DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.180)(PORT = 1521))
        )
        (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = orcl.localdomain)
        )
)
QXY1=
(DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.180)(PORT = 1521))
        )
        (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = qxy111pdb.localdomain)
        )
)


--//监听状态

[oracle@node1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-MAY-2020 00:14:41

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                15-MAY-2020 09:06:16
Uptime                    0 days 15 hr. 8 min. 26 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.1.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.183)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=node1.localdomain)(PORT=5500))(Security=(my_wallet_directory=/gridhome/app/oracle/product/12.2.0.1/db_1/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.40.180)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_MGMT" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "962e987502a6b068e053b428a8c05c98.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "966960d9daccacf1e053b428a8c0cae8.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "QXY111XDB.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "SYS$C##GGADMIN.OGG$Q_EX1.0.ORCL.LOCALDOMAIN" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "SYS$C##GGADMIN.OGG$Q_EX2.0.ORCL.LOCALDOMAIN" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "SYS$C##GGADMIN.OGG$Q_EX3.0.ORCL.LOCALDOMAIN" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "SYS$C##GGADMIN.OGG$Q_EX4.0.ORCL.LOCALDOMAIN" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "orcl.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "pdb02.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
Service "qxy111pdb.localdomain" has 1 instance(s).
  Instance "QXY1111", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node1 admin]$

--//pdb的状态

[oracle@node1 admin]$ o

SQL*Plus: Release 12.2.0.1.0 Production on Sat May 16 00:15:10 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 QXY111PDB                      READ WRITE NO       <====需要导入的PDB
         4 PDB02                          READ WRITE YES
SQL>

--//创建用户
登陆到QXY111PDB创建
create user user_xtts identified by tiger account;
grant resource,connect to user_xtts;
grant SYSBACKUP to user_xtts;
grant sysdba to user_xtts identified by tiger;

--//使用pdb登陆rman

[oracle@node1 ~]$ rman target user_xtts/tiger@QXY1

Recovery Manager: Release 12.2.0.1.0 - Production on Fri May 15 23:48:13 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL:QXY111PDB (DBID=3045978822)

RMAN> 

RMAN> 

RMAN> convert datafile '/home/oracle/tbs_xtts01.copy'  format '/home/oracle/tbs_xtts01.dbf'  from platform 'Linux x86 64-bit';

Starting conversion at target at 15-MAY-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 instance=QXY1111 device type=DISK
channel ORA_DISK_1: starting datafile conversion
input file name=/home/oracle/tbs_xtts01.copy
converted datafile=/home/oracle/tbs_xtts01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
Finished conversion at target at 15-MAY-20

RMAN> exit

Recovery Manager complete.
[oracle@node1 ~]$

6,在源端数据库查询测试表空间data file copy的SCN

set linesize 300
col name for a50
select recid,name,file#,incremental_level,checkpoint_time,checkpoint_change# from v$datafile_copy where file#=7;


SQL> set linesize 300
SQL> col name for a50
SQL> select recid,name,file#,incremental_level,checkpoint_time,checkpoint_change# from v$datafile_copy where file#=7;

     RECID NAME                                                    FILE# INCREMENTAL_LEVEL CHECKPOINT_TIME     CHECKPOINT_CHANGE#
---------- -------------------------------------------------- ---------- ----------------- ------------------- ------------------
        7 /home/oracle/tbs_xtts01.copy                                7                   2020/05/18 17:36:20           35072924

SQL>

7,在源端数据库对测试表空间进行数据库事务变化

conn user_xtts/tiger
insert into t_test values(2);
commit;


SQL> 
SQL> conn user_xtts/tiger
Connected.
SQL> 
SQL> insert into t_test values(2);

1 row created.

SQL> commit;

Commit complete.

SQL>

--//设置表空间read only
SQL> alter tablespace tbs_xtts read only;

Tablespace altered.
 

8,在源端数据库基于 上述的DATA FILE COPY的SCN进行增量RMAN备份

backup incremental from scn 35072924 datafile 7 format '/home/oracle/incr_datafile7_first_bak_35072924_%u_%d.bak' tag='datafile7_first_incr_bak';


[oracle@rac1]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on ? 58 17:46:00 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEVDB (DBID=845281939)

RMAN> backup incremental from scn 35072924 datafile 7 format '/home/oracle/incr_datafile7_first_bak_35072924_%u_%d.bak' tag='datafile7_first_incr_bak';

Starting backup at 2020/05/18 17:46:03

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=162 instance=devdb1 device type=DISK
backup will be obsolete on date 2020/05/25 17:46:03
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/home/oracle/tbs_xtts01.dbf
channel ORA_DISK_1: starting piece 1 at 2020/05/18 17:46:03
channel ORA_DISK_1: finished piece 1 at 2020/05/18 17:46:04
piece handle=/home/oracle/incr_datafile7_first_bak_35072924_8nv0h7ar_DEVDB.bak tag=DATAFILE7_FIRST_INCR_BAK comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 2020/05/25 17:46:05
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 2020/05/18 17:46:06
channel ORA_DISK_1: finished piece 1 at 2020/05/18 17:46:07
piece handle=/home/oracle/incr_datafile7_first_bak_35072924_8ov0h7at_DEVDB.bak tag=DATAFILE7_FIRST_INCR_BAK comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2020/05/18 17:46:07

RMAN>

9,传输源端上述的增量RMAN备份到目标端数据库对应目录

[oracle@rac1]$  scp /home/oracle/incr_datafile7_first_bak_35072924_8nv0h7ar_DEVDB.bak oracle@192.168.40.180:/home/oracle
oracle@192.168.40.180's password: 
incr_datafile7_first_bak_35072924_8nv0h7ar_DEVDB.bak                                                                    100%   56KB  56.0KB/s   00:00    
[oracle@rac1]$ 

10,在目标端数据库对自源端数据库传输过来的增量RMAN备份集进行字节序转换

[oracle@node1 ~]$ ls -l /home/oracle/incr_datafile*
-rw-r-----. 1 oracle oinstall 57344 May 15 23:52 /home/oracle/incr_datafile7_first_bak_35072924_8nv0h7ar_DEVDB.bak
[oracle@node1 ~]$ 

--//登陆QXY111PDB

sqlplus user_xtts/tiger@QXY1
SQL> DECLARE
  2    handle    varchar2(512);
  3    comment   varchar2(80);
  4    media     varchar2(80);
  5    concur    boolean;
  6    recid     number;
  7    stamp     number;
  8    pltfrmfr number;
  9    devtype   VARCHAR2(512);
 10  BEGIN
 11    BEGIN
 12      sys.dbms_backup_restore.restoreCancel(TRUE);
 13      devtype := sys.dbms_backup_restore.deviceAllocate;
 14      sys.dbms_backup_restore.backupBackupPiece(bpname => '/home/oracle/incr_datafile7_first_bak_35072924_8nv0h7ar_DEVDB.bak',fname => '/home/oracle/first_incr_bak.bak',handle => handle,media=> media,comment=> comment, concur=> concur,recid=> recid,stamp => stamp, check_logical => FALSE,copyno=> 1, deffmt=> 0, copy_recid=> 0,copy_stamp => 0,npieces=> 1,dest=> 0,pltfrmfr=>13);
 15    END;
 16  END;
 17  /

PL/SQL procedure successfully completed.

SQL>

[oracle@node1 ~]$ pwd
/home/oracle
[oracle@node1 ~]$ ls -ltr first_incr_bak.bak 
-rw-r-----. 1 oracle asmadmin 57344 May 15 23:53 first_incr_bak.bak
[oracle@node1 ~]$ 

11,在目标端数据库对上述的DATA FILE COPY以及初次的增量RMAN备份集进行前滚应用

sqlplus user_xtts/tiger@QXY1

set serveroutput on;
   DECLARE
   outhandle varchar2(512) ;
   outtag varchar2(30) ;
   done boolean ;
   failover boolean ;
   devtype VARCHAR2(512);
BEGIN


   DBMS_OUTPUT.put_line('Entering RollForward');


   -- Now the rolling forward.
   devtype := sys.dbms_backup_restore.deviceAllocate;


   sys.dbms_backup_restore.applySetDatafile(
   check_logical => FALSE, cleanup => FALSE) ;


   DBMS_OUTPUT.put_line('After applySetDataFile');


   sys.dbms_backup_restore.applyDatafileTo(
     dfnumber => 7,
     toname => '/home/oracle/tbs_xtts01.dbf',
     fuzziness_hint => 0, max_corrupt => 0, islevel0 => 0,
     recid => 0, stamp => 0);


  DBMS_OUTPUT.put_line('Done: applyDataFileTo');


  DBMS_OUTPUT.put_line('Done: applyDataFileTo');


  -- Restore Set Piece
  sys.dbms_backup_restore.restoreSetPiece(
    handle => '/home/oracle/first_incr_bak.bak',
    tag => null, fromdisk => true, recid => 0, stamp => 0) ;


  DBMS_OUTPUT.put_line('Done: RestoreSetPiece');


  -- Restore Backup Piece
  sys.dbms_backup_restore.restoreBackupPiece(
    done => done, params => null, outhandle => outhandle,
    outtag => outtag, failover => failover);


  DBMS_OUTPUT.put_line('Done: RestoreBackupPiece');
  sys.dbms_backup_restore.restoreCancel(TRUE);
  sys.dbms_backup_restore.deviceDeallocate;
END;


/

Entering RollForward
After applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece

PL/SQL procedure successfully completed.

SQL>

12,在源端数据库导出测试表空间的元数据

 sqlplus '/as sysdba'
 col directory_name for a50 
 col directory_path for a50
 set linesize 300
 select directory_name,directory_path from dba_directories;


DIRECTORY_NAME                                     DIRECTORY_PATH
-------------------------------------------------- --------------------------------------------------
XTTSFILES                                          /home/oracle/xttsfiles
DATADUMP                                           /ogg/datadump
XMLDIR                                             /u01/app/oracle/product/11.2.0/db_1/rdbms/xml
DPDATA1                                            /tmp/datadump
DATA_PUMP_DIR                                      /u01/app/oracle/product/11.2.0/db_1/rdbms/log/
ORACLE_OCM_CONFIG_DIR                              /u01/app/oracle/product/11.2.0/db_1/ccr/state

6 rows selected.

SQL> 

[oracle@rac1]$ expdp  "'/ as sysdba'" dumpfile=expdp_tbs_xtts.dmp directory=XTTSFILES transport_tablespaces=tbs_xtts logfile=expdp_tbs_xtts.log 

Export: Release 11.2.0.3.0 - Production on ? 58 06:38:38 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 "SYS"."SYS_EXPORT_TRANSPORTABLE_01":  "/******** AS SYSDBA" dumpfile=expdp_tbs_xtts.dmp directory=XTTSFILES transport_tablespaces=tbs_xtts logfile=expdp_tbs_xtts.log 
 TRANSPORTABLE_EXPORT/PLUGTS_BLK
 TRANSPORTABLE_EXPORT/TABLE
 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
YS"."SYS_EXPORT_TRANSPORTABLE_01" 
******************************************************************************
SYS.SYS_EXPORT_TRANSPORTABLE_01 ?:
  /home/oracle/xttsfiles/expdp_tbs_xtts.dmp
******************************************************************************
 TBS_XTTS 
  /home/oracle/tbs_xtts01.dbf
 "SYS"."SYS_EXPORT_TRANSPORTABLE_01"  06:39:33 


[oracle@rac1]$

13,传输源端导出的测试表空间元数据到目标端数据库对应目录

create directory XTTSFILES as '/home/oracle/xttsfiles';

sqlplus user_xtts/tiger@QXY1
 col directory_name for a50 
 col directory_path for a50
 set linesize 300
 select directory_name,directory_path from dba_directories;
 
 
 SQL>  col directory_name for a50 
SQL>  col directory_path for a50
SQL>  set linesize 300
SQL>  select directory_name,directory_path from dba_directories;

DIRECTORY_NAME                                     DIRECTORY_PATH
-------------------------------------------------- --------------------------------------------------
DBMS_OPTIM_LOGDIR                                  /gridhome/app/oracle/product/12.2.0.1/db_1/cfgtoollogs
DBMS_OPTIM_ADMINDIR                                /gridhome/app/oracle/product/12.2.0.1/db_1/rdbms/admin
XTTSFILES                                          /home/oracle/xttsfiles

---源端
scp /home/oracle/xttsfiles/expdp_tbs_xtts.dmp oracle@192.168.40.180:/home/oracle/xttsfiles/

[oracle@rac1]$ cd xttsfiles/
[oracle@rac1]$ ls
expdp_tbs_xtts.dmp  expdp_tbs_xtts.log
[oracle@rac1]$ scp /home/oracle/xttsfiles/expdp_tbs_xtts.dmp oracle@192.168.40.180:/home/oracle/xttsfiles/
oracle@192.168.40.180's password: 
expdp_tbs_xtts.dmp                                                                                                      100%   88KB  88.0KB/s   00:00    
[oracle@rac1]$ 


14,在目标端数据库导入测试表空间

impdp user_xtts/tiger@QXY1 directory=XTTSFILES  transport_datafiles='/home/oracle/tbs_xtts01.dbf' dumpfile=expdp_tbs_xtts.dmp logfile=impdp_tbs_xtts.log
 
[oracle@node1 ~]$ impdp user_xtts/tiger@QXY1 directory=XTTSFILES  transport_datafiles='/home/oracle/tbs_xtts01.dbf' dumpfile=expdp_tbs_xtts.dmp logfile=impdp_tbs_xtts.log

Import: Release 12.2.0.1.0 - Production on Fri May 15 23:59:36 2020

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "USER_XTTS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "USER_XTTS"."SYS_IMPORT_TRANSPORTABLE_01":  user_xtts/********@QXY1 directory=XTTSFILES transport_datafiles=/home/oracle/tbs_xtts01.dbf dumpfile=expdp_tbs_xtts.dmp logfile=impdp_tbs_xtts.log 
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "USER_XTTS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Sat May 16 00:00:47 2020 elapsed 0 00:00:43

[oracle@node1 ~]$

15、测试验证数据

[oracle@node1 ~]$ sqlplus user_xtts/tiger@QXY1

SQL*Plus: Release 12.2.0.1.0 Production on Sat May 16 00:01:10 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Fri May 15 2020 23:59:36 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select TABLESPACE_NAME from dba_tablespaces;

TABLESPACE_NAME
--------------------------------------------------------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
UNDO_2
USERS
TBS_XTTS

7 rows selected.

SQL> select * from t_test;

         A
----------
         2
         1

SQL>

16、设置源端和目标端的表空间为read write;

qxy0503
关注
专栏目录
（第76天）XTTS 升级：11GR2 到 19C
LuciferLiu_DBA
03-24 307
XTTS（Cross Platform Transportable Tablespaces，跨平台迁移表空间）是 Oracle 推出的一个用来迁移单个表空间数据以及将一个完整的数据库从一个平台移动到另一个平台的迁移备份方法。在企业越来越大的数据量、相对停机时间要求日益减少的情况下，利用 XTTS 可以完成使用增量备份方式实现跨平台的数据迁移，能够减少停机时间、可以进行增量备份，并且能实现跨平台的数据迁移。将源数据库中的表空间设为只读将数据文件传输到目标系统将数据文件转换为目标系统字节序格式。
Eygle力荐：Oracle 19c升级文档、视频、问答集锦
Enmotech的博客
05-11 479
前段时间，墨天轮分享了直播《Oracle 19c升级实战分享 - 云和恩墨大讲堂2020》，在这里我们共享一下PPT和视频，以及在直播过程中，读者提出升级过程中遇到的一些典型问题，供大家...
Oracle 11g rman 异机还原再升级到 12c PDB
03-23
oracle 11.2.0.4异机还原升级到12c，然后再从non-pdb转成pdb整理详细文档。
oracle11g数据库pdb,Oracle11g数据库迁移到Oracle12C的PDB（使用impdp/expdp）
weixin_35948624的博客
04-05 399
Oracle11g数据库迁移到Oracle12C的PDB(使用impdp/expdp)发布时间：2020-07-05 21:13:13来源：51CTO阅读：22658作者：PengChongguiOracle11g数据库迁移到Oracle12C的PDB(使用impdp/expdp)alter pluggable database hrdb close immediate;DROP PLUGGABL...
Oracle-使用XTTS方式迁移11G到PDB数据库
最新发布
sinat_36757755的博客
12-03 1973
Oracle11G迁移到12c之后的PDB升级方式主要有expdp/impdp,TTS以及XTTS，其中，expdp/impdp的迁移方式适用于小数据量的迁移，停机窗口较长，TTS的迁移方式使用于中小数据量的迁移，停机窗口长，而XTTS由于支持增量同步，跨平台迁移，所以适用于大数据量的迁移，并且停机窗口相对较短。
探索Oracle之数据库升级七 11gR2 to 12c 升级完成后插入PDB
12-21 109
探索Oracle之数据库升级七 11gR2 to 12c 升级完成后插入PDB 前言： 从Oracle 12c开始，引入了容器数据库的概念，可以实现数据...
Oracle 11.2.0.4到Oracle 19.3 PDB XTTS迁移方案测试.doc
05-17
Oracle 11.2.0.4到Oracle 19.3 PDB XTTS迁移方案测试.doc
Oracle跨平台迁移技术详解
06-14
Oracle跨平台迁移技术详解，文档详细概述了oracle与oracle不同版本之间，oracle与不同异构数据库直接跨平台迁移技术详细解说，一书在手，数据库迁移不是问题！
DBA进阶（二）Oracle数据库使用xtts传输表空间实现跨平台迁移
狗剩儿的记忆博客
04-12 1033
文章目录前言一、背景介绍1.1源端开启归档模式1.2备份文件的传输方案二、实际操作步骤2.1导出创建源库用户脚本2.2 源端进行0级rman备份2.3 目标端提取0级rman备份2.4 源端进行1级rman备份2.5 目标端提取1级rman备份2.6 源端提取用户对象信息2.7 源端表空间设置只读（停机开始）2.8源端进行最后一次1级rman备份2.9 源端导出表空间元数据2.10 源端还原表空间可读写（停机结束）2.11 目标端应用1级rman增量备份2.12 目标端导入用户权限和对象2.13 目标端导入
Oracle 11gR2迁移升级至12cR2 RAC
03-26
异机迁移oracle 11.2.0.4单机至12cR2 RAC, DBUA直接升级
续：跨平台版本迁移之 XTTS 方案操作指南
Enmotech的博客
04-22 1666
作者 | 罗贵林： 云和恩墨技术工程师，具有8年以上的 Oracle 数据库工作经验，曾任职于大型的国家电信、省级财政、省级公安的维护，性能调优等。精通 Oracle 数...
XTTS V4
sqlora的专栏
11-27 1158
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1) Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Database Exadata Express Cloud Service - Version
Oracle 12.2 新特性: Online PDB relocate (PDB hot move)
coco3600的博客
12-04 574
Oracle 12 . 2 新特性 : Online PDB relocate (PDB hot move) ...
12c跨平台完成PDB的备份迁移
weixin_34183910的博客
06-13 1351
使用Rman，Pluggable database (PDBs) 可以被传送到不同平台并插入到目标的 CDB 中，连同 PDB 的备份Rman 也会 copy 必要的元数据（metadata） 到目标CDB 端。源 CDB 和目标 CDB 必须是相同的字节序（Endian）下面的步骤展示了如何从 Solaris(Big Endian) 迁移一个关闭的 PDB 到 AIX (B...
动手为王 | Oracle 数据库跨版本升级迁移实践
Enmotech的博客
02-27 2253
作者简介李真旭Oracle ACE 专家，拥有超过10年的 Oracle 运维管理使用经验，参与过众多移动、电信、联通、银行等大型数据库交付项目，具有丰富的运维管理经验，对 Oracle 数据库管理运行机制、锁机制、优化机制等具有深入理解；擅长 Oracle 数据库的Performance Tunning、Troubleshooting 以及异常恢复。个人技术博客：http://www.killd
XTTS跨平台表空间增量迁移
cnb71835的博客
03-18 490
测试环境文档，非正式环境迁移文档，免去涉密因素 一、准备工作 1.1、平台检查 column platform_name format a30 ...
XTTS 简介
Ryan——进阶之路
06-01 7431
传输表空间技术从 Oracle8i 诞生，甲骨文公司经过多个版本的不停的改进完善，时至今日已经发展成为跨平台大数据量迁移的一大利器，尤其从 Oracle11.2.0.3 以后 XTTS 推出使用跨平台增量备份的方式，通过迁移不同字节序格式系统之间的数据，大大的减少了停机的时间。 一、XTTS发展 从8i，tts技术的诞生，引入了相同平台相同块大小之间的表空间传输。到了9i，tts开始支持同
Oracle 11.2.0.4到19.3 PDB XTTS迁移实战
"Oracle 11.2.0.4到Oracle 19.3 PDB XTTS迁移方案测试，涉及Oracle数据库版本升级以及表空间的迁移。" Oracle数据库迁移是一个复杂的过程，尤其是在不同版本之间，如从Oracle 11.2.0.4升级到19.3版本，并且涉及...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值