Chủ Nhật, 28 tháng 5, 2017

12C pluggable Database Transport with Backup Sets

-- Backup pluggable database to backup set
SYS@CDB>show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED  READ ONLY  NO
3 PDB1  READ WRITE NO
4 PDB2  MOUNTED
5 NCDB  MOUNTED
SYS@CDB>alter pluggable database ncdb open read only;

Pluggable database altered.

RMAN> backup pluggable database ncdb format '/home/oracle/sales/%U';

Starting backup at 29-MAY-17
configuration for DISK channel 2 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00026 name=/u01/app/oracle/oradata/CDB/orcl/example01.dbf
input datafile file number=00023 name=/u01/app/oracle/oradata/CDB/orcl/system01.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/CDB/orcl/sysaux01.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/CDB/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 29-MAY-17
channel ORA_DISK_1: finished piece 1 at 29-MAY-17
piece handle=/home/oracle/sales/1ks5ern1_1_1 tag=TAG20170529T103512 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 29-MAY-17

Starting Control File and SPFILE Autobackup at 29-MAY-17
piece handle=/home/oracle/backup/c-2061076445-20170529-02 comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAY-17
-- unplug NCDB trong CDB
SYS@CDB>alter pluggable database ncdb close;

Pluggable database altered.

SYS@CDB>alter pluggable database ncdb unplug into '/home/oracle/sales/nvdb.xml';

Pluggable database altered.

-- plug in NCDB to CDB2
[oracle@edd1r2p1 sales]$ . oraenv
ORACLE_SID = [CDB2] ? CDB2
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@edd1r2p1 sales]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon May 29 11:40:05 2017

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SYS@CDB2>CREATE PLUGGABLE DATABASE salespdb USING '/home/oracle/sales/nvdb.xml'
  SOURCE_FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/CDB/orcl/system01.dbf', '/u01/app/oracle/oradata/CDB2/sales/data_D-CDB_I-691792393_TS-SYSTEM_FNO-23_kes5et6m','/u01/app/oracle/oradata/CDB/orcl/sysaux01.dbf','/u01/app/oracle/oradata/CDB2/sales/data_D-CDB_I-691792393_TS-SYSAUX_FNO-24_76s5et6m','/u01/app/oracle/oradata/CDB/orcl/users01.dbf','/u01/app/oracle/oradata/CDB2/sales/data_D-CDB_I-691792393_TS-USERS_FNO-25_o5s5et6m','/u01/app/oracle/oradata/CDB/orcl/example01.dbf','/u01/app/oracle/oradata/CDB2/sales/data_D-CDB_I-691792393_TS-EXAMPLE_FNO-26_sps5et6m')
  NOCOPY
  TEMPFILE REUSE;  2    3    4

Pluggable database created.

SYS@CDB2>show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED  READ ONLY  NO
3 PDB2_1  MOUNTED
4 PDB2_2  MOUNTED
5 PDB3_3  MOUNTED
6 SALESPDB  MOUNTED
SYS@CDB2>alter pluggable database salespdb open;

Pluggable database altered.

SYS@CDB2>show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED  READ ONLY  NO
3 PDB2_1  MOUNTED
4 PDB2_2  MOUNTED
5 PDB3_3  MOUNTED
6 SALESPDB  READ WRITE NO


Không có nhận xét nào:

Đăng nhận xét