中文字幕一区二区人妻电影,亚洲av无码一区二区乱子伦as ,亚洲精品无码永久在线观看,亚洲成aⅴ人片久青草影院按摩,亚洲黑人巨大videos

19c新特性DBCA可插拔數(shù)據(jù)庫遠(yuǎn)程克隆和重新定位

發(fā)布于：2021-02-09 09:50:20

0

668

0

遠(yuǎn)程克隆 重新定位 DBCA 數(shù)據(jù)庫

oracle19c中的一個(gè)新特性是能夠使用DBCA執(zhí)行PDB的遠(yuǎn)程克隆，還可以將PDB從一個(gè)容器數(shù)據(jù)庫重新定位到另一個(gè)容器數(shù)據(jù)庫。

讓我們看一個(gè)例子，首先克隆一個(gè)PDB，然后將PDB重新定位到另一個(gè)CDB。

這是我們最初的環(huán)境

  • 容器數(shù)據(jù)庫CDB1（host02）：PDB$SEED，PDB1

  • 容器數(shù)據(jù)庫CDB2（host03）：PDB$SEED

這是預(yù)期的最終環(huán)境

  • 容器數(shù)據(jù)庫CDB1（host02）：PDB$SEED

  • 容器數(shù)據(jù)庫CDB2（host03）：PDB$SEED、PDB1、PDB2

SQL> select name from v$database;

NAME
---------
CDB1

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED  READ ONLY  NO
 3 PDB1  READ WRITE NO

SQL> select name from v$database;

NAME
---------
CDB2

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED  READ ONLY  NO

遠(yuǎn)程克隆CDB1/PDB1到CDB2/PDB2

創(chuàng)建將用于數(shù)據(jù)庫鏈接的公共用戶。

SQL> create user c##link_user identified by Oracle4U;

User created.

SQL> GRANT CREATE SESSION, RESOURCE, CREATE ANY TABLE, UNLIMITED TABLESPACE TO c##link_user CONTAINER=ALL;

Grant succeeded.

SQL> GRANT CREATE PLUGGABLE DATABASE TO c##link_user CONTAINER=ALL;

Grant succeeded.

SQL> GRANT SYSOPER TO c##link_user CONTAINER=ALL;

Grant succeeded.

在CDB2中創(chuàng)建連接到CDB1的數(shù)據(jù)庫鏈接。

SQL> create database link cdb1_link 
  2  connect to c##link_user identified by Oracle4U
  3  using 'CDB1';

Database link created.


SQL> select * from dual@cdb1_link;

D
-
X

在靜默模式下運(yùn)行DBCA執(zhí)行遠(yuǎn)程克隆（從CDB2運(yùn)行此操作）。

[oracle@host03 admin]$ dbca 
-silent 
-createPluggableDatabase 
-createFromRemotePDB 
-sourceDB cdb2  
-remotePDBName pdb1 
-remoteDBConnString host02:1521/cdb1.localdomain 
-remoteDBSYSDBAUserName SYS 
-remoteDBSYSDBAUserPassword G#vin1 
-dbLinkUsername c##link_user 
-dbLinkUserPassword Oracle4U 
-sysDBAUserName SYS 
-sysDBAPassword G#vin1
-pdbName pdb2 
-pdbDatafileDestination '/u01/app/oracle/oradata/CDB2/pdb2/'


Prepare for db operation
50% complete
Create pluggable database using remote clone operation
100% complete
Pluggable database "pdb2" plugged successfully.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb2/pdb2/cdb2.log" for further details.

在CDB2中，驗(yàn)證是否創(chuàng)建了可插入數(shù)據(jù)庫PDB2，并注意PDB2的數(shù)據(jù)文件的位置。

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED  READ ONLY  NO
 3 PDB2  READ WRITE NO

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/CDB2/system01.dbf
/u01/app/oracle/oradata/CDB2/sysaux01.dbf
/u01/app/oracle/oradata/CDB2/undotbs01.dbf
/u01/app/oracle/oradata/CDB2/pdbseed/system01.dbf
/u01/app/oracle/oradata/CDB2/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/CDB2/users01.dbf
/u01/app/oracle/oradata/CDB2/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/CDB2/pdb2/system01.dbf
/u01/app/oracle/oradata/CDB2/pdb2/sysaux01.dbf
/u01/app/oracle/oradata/CDB2/pdb2/undotbs01.dbf
/u01/app/oracle/oradata/CDB2/pdb2/users01.dbf

將PDB1從CDB1重新定位到CDB2

以靜默模式運(yùn)行DBCA以執(zhí)行重新定位（從CDB2運(yùn)行此操作）。

[oracle@host03 admin]$ dbca 
-silent 
-relocatePDB 
-sourceDB cdb2  
-remotePDBName pdb1 
-remoteDBConnString host02:1521/cdb1.localdomain 
-remoteDBSYSDBAUserName SYS 
-remoteDBSYSDBAUserPassword G#vin1
-dbLinkUsername c##link_user 
-dbLinkUserPassword Oracle4U 
-sysDBAUserName SYS 
-sysDBAPassword G#vin1
-pdbName pdb1 
-pdbDatafileDestination '/u01/app/oracle/oradata/CDB2/pdb1/'

Prepare for db operation
50% complete
Create pluggable database using relocate PDB operation
100% complete
Pluggable database "pdb1" plugged successfully.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb2/pdb1/cdb20.log" for further details.

克隆和重新定位后驗(yàn)證環(huán)境。

SQL> select name from v$database;

NAME
---------
CDB2

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED  READ ONLY  NO
 3 PDB2  READ WRITE NO
 4 PDB1  READ WRITE NO


SQL> select name from v$database;

NAME
---------
CDB1

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED  READ ONLY  NO