oracle 创建远程,Oracle 创建PDB-远程克隆

爱被打了一巴掌 2022-10-21 04:58 148阅读 0赞

Oracle

创建PDB-

远程克隆

二：远程克隆Cloning a Remote PDB

![210a00be3f3b5efe16529971d16def51.png][]

远程克隆

将187服务器上chenpdb数据库远程克隆到222服务器上cjcpdb04库

\---187

远程库

Oracle

Database

Enterprise

Edition Release

19.0

.0.0.0

Production

Version

19.3

.0.0.0

SQL

show

pdbs

CON\_ID CON\_NAME

OPEN

MODE

RESTRICTED

\---------- ------------------------------ ---------- ----------

PDB$SEED

READ

ONLY

CHENPDB

READ

WRITE

\---

创建测试数据

SQL

alter

session

set

container

chenpdb

;

Session

altered.

SQL

create

user

chen

identified

oracle

;

User

created.

SQL

grant

connect

resource

dba

create

pluggable

chen

;

SQL

grant

create

pluggable

chen

;

Grant

succeeded.

SQL

conn chen

oracle

chenpdb

SQL

create

table

employees\_01

select

from

hr.employees

;

Table

created.

SQL

select

file\_name

from

dba\_data\_files

;

FILE\_NAME

\--------------------------------------------------------------------------------

u01

app

oracle19

oradata

CHENDB

chenpdb

system01.dbf

u01

app

oracle19

oradata

CHENDB

chenpdb

sysaux01.dbf

u01

app

oracle19

oradata

CHENDB

chenpdb

undotbs01.dbf

u01

app

oracle19

oradata

CHENDB

chenpdb

users01.dbf

\---

为了保障数据一致性，也可以将待克隆的数据库设置为只读状态

\---SQL> alter pluggable database chenpdb close;

\---SQL> alter pluggable database chenpdb open read only;

\---222

本地库

\---tnsname.ora

添加

CHENPDB\_LINK

(

DESCRIPTION

(

ADDRESS

(

PROTOCOL

TCP

)(

HOST

192.168

.2.187

)(

PORT

1521

))

(

CONNECT\_DATA

(

SERVER

DEDICATED

)

(

SERVICE\_NAME

chenpdb

)

CJCPDB04

(

DESCRIPTION

(

ADDRESS

(

PROTOCOL

TCP

)(

HOST

cjcos

)(

PORT

1521

))

(

CONNECT\_DATA

(

SERVER

DEDICATED

)

(

SERVICE\_NAME

cjcpdb04

)

\[oracle

cjcos oradata\]$ pwd

u01

app

oracle12

oradata

\[oracle

cjcos oradata\]$ mkdir cjcpdb04

\---

创建连接远程库的dblink

SQL

CREATE

DATABASE

LINK

chenpdb\_link

CONNECT

chen

IDENTIFIED

oracle

USING

'chenpdb\_link'

;

\---远程克隆

SQL

CREATE

PLUGGABLE

DATABASE

cjcpdb04

FROM

chenpdb

chenpdb\_link

FILE\_NAME\_CONVERT

(

'/u01/app/oracle19/oradata/CHENDB/chenpdb/'

'/u01/app/oracle12/oradata/cjcpdb04/'

);

Pluggable

database

created.

\---查看对应告警日志

2020

T13

14.265860

CREATE

PLUGGABLE

DATABASE

cjcpdb04

FROM

chenpdb

chenpdb\_link

FILE\_NAME\_CONVERT

(

'/u01/app/oracle19/oradata/CHENDB/chenpdb/'

'/u01/app/oracle12/oradata/cjcpdb04/'

)

2020

T13

03.124780

CJCPDB04

(

Endian

type

dictionary

set

little

2020

T13

05.708201

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

Pluggable

Database

CJCPDB04

with

pdb

created

UNUSABLE.

any

errors

are encountered

before

the

pdb

marked

NEW

then

the

pdb must be dropped

local

undo

localundoscn

x0000000000000118

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

2020

T13

08.228640

Applying media

recovery

for

pdb

4099

from

SCN

2162581

SCN

2162616

Remote

log

information

count

thr

seq

logfile

\-/

u01

app

oracle19

product

19.0

dbhome\_1

dbs

archparlog\_1\_7\_f2af50d\_1036413577.arc

los

2146891

nxs

18446744073709551615

CJCPDB04

(

Media

Recovery

Start

2020

T13

08.253256

CJCPDB04

(

Serial Media

Recovery

started

CJCPDB04

(

max\_pdb

2020

T13

08.725328

CJCPDB04

(

Media

Recovery

Log

u01

app

oracle19

product

19.0

dbhome\_1

dbs

archparlog\_1\_7\_f2af50d\_1036413577.arc

2020

T13

10.008175

CJCPDB04

(

Incomplete

Recovery

applied

until

change

2162616

time

2020

T13

10.133184

CJCPDB04

(

Media

Recovery

Complete

(

cjcdb01

)

2020

T13

11.061364

CJCPDB04

(

Autotune

undo

retention

turned on.

2020

T13

51.439938

CJCPDB04

(

Undo

initialization

recovery

err

start

1180295010

end

1180295043

diff

(

0.0

seconds

)

CJCPDB04

(

27424

\] Successfully onlined

Undo

Tablespace

CJCPDB04

(

Undo

initialization

online

undo

segments

err

start

1180295043

end

1180295053

diff

(

0.0

seconds

)

CJCPDB04

(

Undo

initialization finished serial

start

1180295010

end

1180295055

diff

(

0.0

seconds

)

CJCPDB04

(

Database

Characterset

for

CJCPDB04

AL32UTF8

CJCPDB04

(

JIT

pid

27424

requesting

stop

CJCPDB04

(

Buffer

Cache

flush

started

CJCPDB04

(

Buffer

Cache

flush

finished

2020

T13

53.986700

Completed

CREATE

PLUGGABLE

DATABASE

cjcpdb04

FROM

chenpdb

chenpdb\_link

FILE\_NAME\_CONVERT

(

'/u01/app/oracle19/oradata/CHENDB/chenpdb/'

'/u01/app/oracle12/oradata/cjcpdb04/'

)

\---222

本地数据库

SQL

show

pdbs

CON\_ID CON\_NAME

OPEN

MODE

RESTRICTED

\---------- ------------------------------ ---------- ----------

PDB$SEED

READ

ONLY

CJCPDB01                       MOUNTED

CJCPDB02                       MOUNTED

CJCPDB03                       MOUNTED

CJCPDB04                       MOUNTED

SQL

alter

session

set

container

cjcpdb04

;

Session

altered.

SQL

startup

Pluggable

Database

opened.

\---

查看数据

SQL

conn chen

oracle

cjcpdb04

Connected.

SQL

select

count

(\*)

from

employees\_01

;

COUNT

(\*)

\----------

107

\---常见

错误：

\---1

权限不足

CREATE

PLUGGABLE

DATABASE

cjcpdb04

FROM

chenpdb

chenpdb\_link

ERROR

line

ORA

17628

Oracle

error

1031

returned

remote Oracle server

ORA

01031

insufficient

privileges

\---187

远程数据库授予chen用户create pluggable database权限

SQL

conn

sys

oracle

chenpdb

sysdba

Connected.

SQL

grant

create

pluggable

database

chen

;

Grant

succeeded.

\---2

本地数据库compatible低于远程数据库

ORA

65294

PDB

's compatible parameter value (19.0.0.0.0) is higher than CDB'

compatible parameter

value

(

12.2

.0.0.0

)

\---222

本地数据库

SQL

show

parameter compatible

NAME

TYPE

VALUE

\------------------------------------ ----------- ------------------------------

compatible

string

12.2

noncdb\_compatible

boolean

FALSE

\---187

远程

SQL

show

parameter compati

NAME

TYPE

VALUE

\------------------------------------ ----------- ------------------------------

compatible

string

19.0

\---222

本地数据库

SQL

alter

system

set

compatible

'19.0.0'

scope

spfile

;

System

altered.

SQL

shutdown

immediate

SQL

startup

SQL

show

parameter compatible

NAME

TYPE

VALUE

\------------------------------------ ----------- ------------------------------

compatible

string

19.0

欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！

[210a00be3f3b5efe16529971d16def51.png]: /images/20221021/1ae40f6c545548209fceb780398931cd.png

oracle 创建远程,Oracle 创建PDB-远程克隆

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle cdb远程克隆多pdb从理论到实战

相关 oracle远程expdp,oracle expdp 导出远程数据库

相关创建远程仓库并且克隆远程仓库到本地

相关 oracle 创建远程,Oracle 创建PDB-远程克隆

相关 Oracle 12c 基于PDB种子数据库创建PDB

相关 Oracle 12C -- 使用seed PDB创建新的pdb

相关 Oracle 12c系列(二)｜PDB的创建

相关 Oracle 18c创建PDB的几种方式

相关 Oracle 18c 创建PDB可使用的参数说明

相关 centos7 oracle12c 创建一个pdb