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