oralce异机插拔pdb三种方式.docx

骆加坤

189

3页

7次

2024-07-04

5墨值下载

第五种，通过插入

unplugged

的

PDB

来创建

PDB

：

插入前需要对目标库做兼容性验证

(

根据拔出的

xml

文件

)

set serveroutput on

begin

if not sys.DBMS_PDB.Check_Plug_compa!bility('/home/oracle/pdb4.xml') then

Raise_Applica!on_Error(-20000,'Incompa!ble');

end if;

end;

源容器：

alter pluggable database pdb2 close immediate;

alter pluggable database pdb2 unplug into '/u01/pdb2.xml';

目标容器：

nocopy

模式：

scp * 192.168.43.111:/u01/app/oracle/oradata/CDB/pdb2/ ---

拷贝文

件到目标库

mkdir pdb2

create pluggable database pdb_plug_nocopy using '/u01/pdb2.xml'

NOCOPY TEMPFILE REUSE;

copy

模式：

scp * 192.168.43.111:/u01/app/oracle/oradata/CDB/pdb2/ ---

拷贝文

件到目标库

mkdir pdb2_copy;

--Use the data files of the unplugged PDB to plug the PDB into the

CDB and copy the data files to a new location.

create pluggable database pdb_plug_nocopy using '/u01/pdb2.xml'

COPY

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/CDB/pdb2/','/u01/app/orac

le/oradata/CDB/pdb2_copy/');

move

模式：

scp * 192.168.43.111:/u01/app/oracle/oradata/CDB/pdb2/ ---

拷贝文

件到目标库

mkdir pdb2_move;

--'/u01/app/oracle/oradata/CDB/pdb2/'

文件会被删除

create pluggable database pdb_plug_move using '/u01/pdb2.xml' move

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/CDB/pdb2/','/u01/app/orac

le/oradata/CDB/pdb2_move/');

删除

pluggble database

SQL> drop pluggable database orcl including datafiles;

查看服务

select * from v$pdbs

select * from v$database

select * from v$active_services

启动

PDB

启动单个

PDB

SQL> alter pluggable database orcl open;

Pluggable database altered.

查看状态

select name,open_mode from v$pdbs;

启动所有

PDB

alter pluggable database all open;

关闭：

alter pluggable database orcl close immediate

alter pluggable database all close immediate;

查看所有

PDB

SQL> show pdbs;

of 3

5墨值下载

插拔pdb

关注

评论